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

Replication Articles Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 8:18 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, November 19, 2014 10:40 AM
Points: 867, Visits: 463
Hello

I recently got a request to configure transactional replication with around 1500 tables as articles. Is there an easy way to add those artiles rather than putting a check mark on each table under publisher propeties?

Thanks in advance!!
Post #1446526
Posted Thursday, April 25, 2013 1:05 PM
SSC Eights!

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

Group: General Forum Members
Last Login: Friday, October 31, 2014 4:01 PM
Points: 835, Visits: 1,192
You can create publication from backup and use sp_addarticle SP for adding articles.
Post #1446684
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse