October 28, 2003 at 1:14 pm
I am working on a job where different applications are setup as different databases on a single SQL Server. Each application references an Employees and Departments tables. Naturally we don’t want to have to maintain these identical tables in multiple databases. So, we are looking at setting up a view in each database that will reference just one ‘master’ table for both the Employees and Departments tables. I have done this for one application and it has worked ok. However, now that I am referencing Employees and Departments as views instead of tables I see no way to setup relationships between the Employees and Departments and the other related tables. Or, is there another way to setup the databases, so there is only one ‘master’ table for each Employees and Departments.
Thanks,
Brian
October 29, 2003 at 7:02 am
Hi, not sure if this will help or really be what you are looking for but have you thought about creating a 'Common' database to house tables that are referenced by multiple databases?
...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply