Page 1 of 1
Multiple databases across application
Posted: Tue Feb 06, 2007 5:42 pm
by GeXus
I'm working on a project that could very easily make sense to have multiple databases, due to the way it could logically be broken up. I'm wondering what the best way is to handle connection strings. I'm using a wrapper class that defines the connection string, I'm thinking I could add to that and create a function that just lists all the connection strings, then call that in my page after i initiate the class.. not sure if that's the best way.
Posted: Tue Feb 06, 2007 5:49 pm
by feyd
It's often pretty difficult to justify needing more than one database for an application. If the same connection combination (user/password/client/server) match then you just need to add the database name before the table name references to access the other databases. If they are separate servers you'll need separate connections and separate queries.
Posted: Tue Feb 06, 2007 9:34 pm
by GeXus
How would you justify using more than one database? I've just thought that having several smaller databases is more efficient than having one big one
Posted: Tue Feb 06, 2007 9:37 pm
by feyd
I've never been able to justify the need for more than one database for a given application. That's why I'm saying it's pretty difficult.

Posted: Wed Feb 07, 2007 9:30 pm
by GeXus
That works for me
