RSS Links

 

Here are all of the RSS links for sections of this site

VB.NET/ASP.NET
 Java
 Unix/Linux
 Windows
 SQL Server

Home arrow SQL Server arrow How do I replicate identity columns in SQL Server
How do I replicate identity columns in SQL Server PDF Print E-mail
Wednesday, 31 December 2008

Replication of Identity columns in SQL Server is a tricky business
you will need to bear in mind the following:-

  • Make sure you set the NOT_FOR_REPLICATION flag on the identity
  • You need to workout and assign separate ranges for each server i.e. server 1 may start at 1, server 2 may start at 20000. replicate first, and then go in and update the identity range using either VS or DBCC CHECKIDENT

There is more information at

http://msdn.microsoft.com/en-us/library/ms152543(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms152529(SQL.90).aspx
http://www.mssqltips.com/tip.asp?tip=1274
http://blogs.conchango.com/stevewright/archive/2007/04/16/SQL-Server-2005-Merge-Replication-Subscriber-unexpectedly-deleting-during-data-Synchronisation.--.aspx

Last Updated ( Wednesday, 31 December 2008 )
 
< Prev   Next >
 
Designed by Graham Robinson Software