2 SQLServers in one project

Posts   
 
    
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 12-Jan-2013 01:23:52   

I am able to add 2 Databases to a project that run off the same SQLServer. However, is it possible to have a 2nd SQLServer added to a project?

When I try to add another, the option for SQLServer is not there once I already have a SQLServer server added.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 12-Jan-2013 07:27:05   

No, you can only have one target DB 'type' (SQLServer, Oracle, Postgres, etc) per project. You can have multiple catalogs per DB server type. If you really need it, you can have two separate projects for that.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 13-Jan-2013 11:17:01   

Out of curiosity why would you want to add another server? The thing is that if you map an entity on a table in that server, you could create a relationship with that entity which crosses server borders, which isn't going to work in practice.

Frans Bouma | Lead developer LLBLGen Pro
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 14-Jan-2013 19:34:32   

We're creating WCF services that call 4 SQLServer servers for the models served to the WCF clients. We can't change the back end. (Read only)

We'd like to simplify the LLBL projects and resulting persistent projects. Having 4 LLBLs and then 4 persistent projects in the service makes it more cluttered than we'd like.

Certainly not a show stopper, but being able to aggregate the SQLServers in 1 project would create a really clean solution.