all groups > sql server replication > april 2006 >
You're in the

sql server replication

group:

Change of Primary key in a published article


Change of Primary key in a published article Wingman
4/28/2006 9:28:02 AM
sql server replication:
We are using SQl 2K with sp4, and using push transaction replication.

Recently we need to add a new field into an existing primary key where it
belongs to a published table. What is the quickest way for me to replicate
the new primary key over without reloading the data since the table is quite
large?

Re: Change of Primary key in a published article Paul Ibison
4/28/2006 5:36:08 PM
Doing a nosync initialization is the quickest way. This is actually possible
on an article basis, although I find this unsupportable if the rest of the
subscription is not nosync, so I'd do a nosync of the entire publication
(http://www.replicationanswers.com/NoSyncInitializations.asp).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button