Rank: Newbie
Joined: 4/21/2008
Posts: 10
|
I'd recommend changing all of the primary / foreign keys from integers to GUIDs in order to eliminate any type of conflict during replication.
It is a well-known problem that identity fields can cause serious issues during replication especially two-way replication. If they were all changed to GUIDs the chance of a conflict would likely never occur. Identity fields can be replicated, however, special precautions must be taken or the identity seeds must set such that there will never be a conflict between any two or more servers.
Is this something that we may see in a Umbraco release in the near future?
|
Rank: Fanatic
Joined: 7/21/2006
Posts: 256
Location: Salerno - Italy
|
In the SQL replication you can setup to replicate or no identities. I suggest you to use merge replication if you want align 2 db. What type of replica do you use?
Red Consulting s.a.s - Umbraco from v1.0
|