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 |
|
tuenty
Constraint Violating Yak Guru
278 Posts |
 Posted - 2007-09-25 : 16:48:29
|
I have many tables in different databases with the same name and structure and name. I was asked to move all tables to one database under different schema or to document why in would be better to stay with two DBs. In my previous client it was even better, from the development & maintenance point of view, to just add one extra field to each table to indicate the product type and keep just one set of tables, SPs, views & batch an online programs. On this client I have too many tables with too many fields, rows and processes that depend on them so adding a field is not an option.For now I know that if using different DB I can - use same applications with different DB connection
- copy SP, views, function etc from one db to the other without any modification
if DB is the same but schema is different I need to - specify the schema on queries, SP, views, function etc when ever looking into non dbo tables
Can someone give me some insight on what other factors I should take into account before making a decision?A candle loses nothing by lighting another candle  |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-25 : 23:24:40
|
| Should grant permission carefully so user doesn't get access more than needed. |
 |
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
Posted - 2007-10-09 : 08:47:56
|
| Would it make any difference performance wise to have more tables in one DB vs having some tables in one and some more on another (both DB would be in same Server)?A candle loses nothing by lighting another candle |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-09 : 22:58:12
|
| Don't think so. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 00:19:48
|
| "Would it make any difference performance wise ..."Consider the difficulties of Disaster Recovery getting referential integrity synchronised across multiple databases.Kristen |
|
|
|
|
|
|
Design ? schema vs database