January 28, 2008 at 11:11 am
Hi Guys,
We have a merge Replication in place that replicates a database across 2 sites.
I want to add an identity field to a table that is currently replicated and the records get added only on the Publisher side
I am considering
a. Remove the article
b. Add the identity col
c. Publish the Article and Database
Does the process work?
V
January 31, 2008 at 7:11 pm
Add an index or an identity column?
Take a look here: SQL Server 2005 Books Online - Replicating Identity Columns
Note:
Adding an identity column to a published table is not supported, because it can result in non-convergence when the column is replicated to the Subscriber. The values in the identity column at the Publisher depend on the order in which the rows for the affected table are physically stored. The rows might be stored differently at the Subscriber; therefore the value for the identity column can be different for the same rows
February 1, 2008 at 2:31 am
Does it mean that even if the identity gets updated only at the Publisher..The values for the identity column might be different?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply