Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Transactional Replication -Adding Only 1 Article

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-10-20 : 17:31:20
When I rebuilt the publication, I omitted 1 table.
I would rather not have to rebuild the entire publication again, it has 150 tables.
Will these steps work?
1. add the table in the publications articles.
2. create the table in the subscription database and manually populate it....

Now, will data changes for that table get replicated to the subscriber..... OR will I have to run a Snapshot first?
Thanks!

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-10-21 : 13:42:00
I was able to add the 1 table.
This is what I did thru the Management Studio GUI, for the benefit of anyone who may not want to reinit and run the Snapshot for all articles.
1. added the table to the articles in the Publication
2. right-clicked Publication name --> View Agent Status
3. clicked START

In the Subscription database, I see the new table with today as the creation date and the table is populated
Go to Top of Page
   

- Advertisement -