DB and Several Systems
-
Hi, I have two software system. Each one has a database in SqlServer 2000. One of both have to use another one database and it is better that there was some relation between some tables in two databases. So I think that I must add all tables of first database to second. But DB management will be so difficult because tables of both systems will mixed together. Can anyone suggest a solution for this problem? regards, Mehdi
-
Hi, I have two software system. Each one has a database in SqlServer 2000. One of both have to use another one database and it is better that there was some relation between some tables in two databases. So I think that I must add all tables of first database to second. But DB management will be so difficult because tables of both systems will mixed together. Can anyone suggest a solution for this problem? regards, Mehdi
If the relations are simple (and a small number), then it's better doing things "by hand", and keep the database separated: 1. Create triggers to enforce what would be foreign keys, and to keep data in sync. 2. Create views to ease SELECTs. Yes, even I am blogging now!