Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-26 : 09:49:58
|
| And writes "We are about to implement a large database system. The question is whether we should use the multiple database technique or the single database technique.The data is different among the databases (if we choose a multi-database scheme) but the table structure is almost the same.We have currently decided to create four databases and because of many common structural considerations we thought of creating a fifth one containing all common tables and data.We might have to access four databases at once. We also wonder if we could use foreign keys among different databases on similar tables though.On the other hand the single database solution lacks on the primary key and we must keep many tables which are not filled with data or distinguish via a code e.g. 1 or 2Is this a good practice ? Will it help the maintenance of this system ? Will the forthcoming selection statements be hard to implement ?" |
|
|
|
|
|
Single or Multiple Databases