Print Page | Close Window

Multiple Databases, Same Schema, One SQL Instance

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3605
Printed Date: 13-May-2026 at 3:48am


Topic: Multiple Databases, Same Schema, One SQL Instance
Posted By: JohnLocke
Subject: Multiple Databases, Same Schema, One SQL Instance
Date 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 !


Replies:
Posted By: sbelini
Date Posted: 05-Sep-2012 at 12:26pm
Hi John,
 
There is a current discussion thread in our forum about this.
It's at http://www.ideablade.com/forum/forum_posts.asp?TID=3449&title=manual-custom-connection-without-having-to-leave-the-application -

Posted By: JohnLocke
Date 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 ?

Posted By: sbelini
Date 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.


Print Page | Close Window