Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding Index to a replicated Table Expand / Collapse
Author
Message
Posted Monday, January 28, 2008 11:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 11, 2012 5:40 AM
Points: 28, Visits: 149
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


Post #448489
Posted Thursday, January 31, 2008 7:11 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 2:49 PM
Points: 1,279, Visits: 2,203
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
Post #450268
Posted Friday, February 1, 2008 2:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 11, 2012 5:40 AM
Points: 28, Visits: 149
Does it mean that even if the identity gets updated only at the Publisher..The values for the identity column might be different?
Post #450368
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse