Sample Header Ad - 728x90

Merge Replication: Updates to Schema

4 votes
1 answer
149 views
We have a main SQL Server which replicates to two backup servers via continuous merge replication. There are regular updates to the schema. Regular changes include: 1. Adding new tables and relationships with existing tables 2. Changing the data type of columns on tables already replicated **What is the easiest way to maintain replication in such an environment?** If changes are made to the publisher, some changes cannot be synced to the subscriber and the whole replication has to be setup again (agent + subscriptions). These databases are too big to replicate in its entirety every time there is an update. Any advice will be appreciated.
Asked by j7m (141 rep)
Jan 28, 2015, 06:58 AM
Last activity: Jul 13, 2025, 06:05 PM