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

How to alter a primary key on a Replicated Table in SQL Server 2008 Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 3:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
We have a table in Sql Server 2008 R2, which has been (Transactional Replication) replicated to two subscriber. We need to increase the size of primary key column from char(14) to char(28).This specific article is part of publication that includes other articles.

I fallowed the following steps and it wroked fine.

1- Remove that article from publication

2- Apply the changes on primary key on publisher and subscribers

3- Re-Add article to publication

When I checked the web,I noticed that many people were talking about fallowing steps:

1- drop the subscription

2- drop the article

3- modify the table

4- add the article
5- add the subscription

Do I need to drop the subscription?
Post #1453797
Posted Wednesday, May 22, 2013 8:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:47 AM
Points: 839, Visits: 1,198
You are doing it in perfectly right way. You do not have to drop the whole subscription.
Post #1455560
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse