This is the first time I am going to add tables to replication.
I have outlined the below steps to add a new table to existing replication. Please correct me if I am wrong. The table is just created - no data.
exec sp_addarticle @publication = N'pub1', @article = N'tab1', @source_owner = N'dbo', @source_object = N'tab1' EXEC sp_addsubscription @publication = 'pub1', @subscriber = 'sub1', @destination_db = 'MLT-Rep' GO EXEC sp_addsubscription @publication = 'pub1', @subscriber = 'sub2', @destination_db = 'MLT-Rep'
After this, I am supposed to run Snapshot right? How do I go about doing that? Just navigate to the "Local Publication" -> "View Snapshot Agent Status" -> Start
Are the above steps right?