Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication without schema changes 2008 Expand / Collapse
Posted Tuesday, July 9, 2013 8:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 6, 2013 12:08 PM
Points: 8, Visits: 85
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.
Post #1471668
Posted Friday, July 12, 2013 9:23 AM


Group: General Forum Members
Last Login: 2 days ago @ 4:31 AM
Points: 199, Visits: 744
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.
Post #1473106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse