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.
| 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 Publication2. right-clicked Publication name --> View Agent Status3. clicked STARTIn the Subscription database, I see the new table with today as the creation date and the table is populated |
 |
|
|
|
|
|
Transactional Replication -Adding Only 1 Article