Replication Articles

• Yogeshwar Phull

  Default port

  Points: 1434

  More actions

  April 25, 2013 at 8:18 am

  #271869

  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!!

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  April 25, 2013 at 1:06 pm

  #1610103

  You can create publication from backup and use sp_addarticle SP for adding articles.