July 9, 2013 at 8:49 am
Is there a way to do replication with out making the schema changes? we want to replicate from our prod configuration tables to a test system but without overriding the schema changes that are in the test system. I was originally thinking that I would use snapshot but I believe that will override any schema changes that are on the test system.
July 12, 2013 at 9:23 am
Not sure if I understand you right.
If you fear that the snapshot does changes on the tables on the subscriber, this depends on the snapthot settings.
First, have the table created on the subscriber before applying the snapshot. Check the article properties of the table. There's a configuration for "action if object exists" or something similar. Check the available options and choose the right for you.
If you fear that schema changes on the publisher affect the subscriber, check the "replicate_ddl"-property on the publication.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply