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

Change in Publication articles in Relication Expand / Collapse
Author
Message
Posted Thursday, January 28, 2010 3:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 20, 2013 11:59 AM
Points: 10, Visits: 193
We have transactional replication model. Now the thing is that 20 or 30 tables of publisher’s have changed. So to make it replicated, I am having two options;-



(1) drop these articles from replication and create a new publication

(2) rebuild the publication entirely



What’s ur suggession? Should I go for option 1 or option 2?
Post #855029
Posted Friday, January 29, 2010 5:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:46 AM
Points: 1,101, Visits: 5,286
Schema changes to the tables are automatically replicated in transaction replication of SQL Server 2005 version. There is no need to recreate or rebuild the publication.
Post #855989
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse