I have an application which uses SQL Server 2008 database.
There is a table where I put user data of two countries i.e country 1 & country 2.
There are references to other tables so that country 1 users can see country 2 records and vice versa through the application
Now , my requirement is to segregate user data of country 1 into DB1 and user data of country 2 into DB2 .
how do I manage existing references now so that country 1 users still can see country 2 records and vice versa through the application although records has been separated in two different databases ?