0

I have done transnational replication to my SQL Server 2014 instance.

There are two db servers subscribing to it. Currently I have added only some of the tables (10 tables) as articles to replicate. However, in the future there will be new tables added to the distributor database that needs to be included as replication articles.

I know that whenever I want to add a new article to the replication, I can go to the Properties of publication and add new articles through the wizard.

However, my problem is that there are some tables added by an application through T-SQL queries.Those tables need to be replicated. So there is no way I can go to the wizard and add those to articles.

Is there a way that I can add articles to the replication through a T-SQL? or Is there any system stored procedure or anything we can use to add articles to replication.

Chathuranga Ranasinghe
  • 529
  • 1
  • 4
  • 21
  • _Is there a way that I can add articles to the replication through a T-SQL? or Is there any system stored procedure or anything we can use to add articles to replication_ Yes. If you google you will find it. – Nick.Mc Dec 06 '18 at 10:45
  • @Nick.McDermaid I did. But I could not find any useful resource. – Chathuranga Ranasinghe Dec 06 '18 at 10:49
  • You can use the script button in the wizard to script out all the T-SQL required. You can adjust that as required – Nick.Mc Dec 06 '18 at 10:58

0 Answers0