Sql Server 2008 Cross-database table linking (relationships)
- by Alex
Hi guys, I have a bit of an issue, and to be honest I don't think there's an answer, but I'll give it a try anyway.
So I have two databases [A]-Company and [B]-Product. Both databases have a Country table which is then linked to other tables in each individual database. The problem is that the data between the two Country tables is a complete duplicate. So, I essentially have to duplicate some of the relationships in each database, and maintenance on top of that is just difficult...
So, I'm curious is there a way to create a cross-database relationship between tables so I can have only one set of Country+Helper tables that govern both databases?
Thanks in advance!