Change of Primary key in a published article

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wingman - 28 Apr 2006 17:28 GMT

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?

Wingman

Reply to this Message

Paul Ibison - 28 Apr 2006 17:36 GMT

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)

Reply to this Message