April 25, 2015 at 10:06 am
Regarding Snapshot replication....
If I have 200 tables on my source DB and 100 tables on my target DB... and I set up a publication w/ just 1 article to be published....
Will the invocation of the snapshot/apply affect any tables on my target other than the article I'm replicating? (someone told me to be careful not to wipeout the entire target DB)
April 25, 2015 at 11:31 pm
The generated snapshot will include only the replicated table.
However, the best way is to test it on a test system in order to be sure.
April 26, 2015 at 6:40 am
thx for feedback Matan... yes, I attempted to test this but received error because the target subscriber.. was publishing the article downstream to another SQL Server..
I disabled that down stream REPL, created/populated new TEST_table on the subscriber DB, and re-init'd the snapshot for the primary transactional repl pub.
All worked fine. The 2nd table, TEST_table, was not affected
thx again!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply