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.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Replication without schema changes

Author  Topic 

sundevilscott
Starting Member

12 Posts

Posted - 2013-07-09 : 10:43:08
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.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-07-10 : 02:59:36
- Article Properties
- Destination Object
- Action if Name is in use
- Keep Existing Object Unchanged

Note that this is a dangerous practice and can cause replication failures when there are schema changes.
Go to Top of Page
   

- Advertisement -