New Posts New Posts RSS Feed: Multiple Databases, Same Schema, One SQL Instance
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Multiple Databases, Same Schema, One SQL Instance
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
JohnLocke View Drop Down
Newbie
Newbie


Joined: 03-Sep-2012
Location: United States
Posts: 2 		Post Options Post Options   Quote JohnLocke Quote  Post ReplyReply Direct Link To This Post Topic: Multiple Databases, Same Schema, One SQL Instance
    Posted: 04-Sep-2012 at 5:50am
Our current C#, Winforms, SQL Server application can use multiple Databases (same schema on each DB) on a single SQL Server 2008 R2 instance so that our vertical market customers who have multiple operating companies can use our app for all of them while keeping each operating company's data separate.

I.e.  Joe's Feed Industries might have a wholesale and a retail business.  So they'd install our app on one server, configure and license two databases via our "server tool".  Then on their workstations, they'd be presented with a dropdown box during the start-up of our application that has them choose which database they wish to work with.

Since we are considering a move to XAML, DevForce/Cocktail, we need to understand how DevForce would work in this scenario from both the  server deployment and client coding perspectives.

Can you shed some light on this ?

Thank you !
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post Posted: 05-Sep-2012 at 12:26pm
Hi John,
 
There is a current discussion thread in our forum about this.
 
Regards,
   Silvio.
Back to Top
JohnLocke View Drop Down
Newbie
Newbie


Joined: 03-Sep-2012
Location: United States
Posts: 2 		Post Options Post Options   Quote JohnLocke Quote  Post ReplyReply Direct Link To This Post Posted: 05-Sep-2012 at 9:22pm
It appears from the thread you referenced, that no action is needed during database creation on the server in order to enable DevForce 2010 clients to connect to one of many databaseson the server.

Is that true ?
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post Posted: 07-Sep-2012 at 9:54am
Hi John,
You are correct, when you create the database there's no special step to enable its use with DevForce.
 
Silvio.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down