Using Sql server 2005, please can anyone tell me if this is possible:
Database 1 has a table [Users] that contains an identity field User_ID, starting at 1. It also has a Location field, always set to 1 for users added at this site.
Database 2 has the same table, User_ID as identity field starting at 1, but Location field set to 2.
So I have At Database 1 Database 2
User_ID Location User_ID Location
1 1 1 2
2 1 2 2
3 1 3 2
Is there any way to have these sites replicating so that I end up with the following at both sites:
User_ID Location
1 1
2 1
3 1
1 2
2 2
3 2
It seems that because I am using an identity field, the user_id is re-seeded on merging. This is obviously a simplified example and it is not feasible to have different start ranges for the seeds. Changing the "not for replication" option seems to have no effect. Is this possible?
Start Free Trial
