2

We have set up Transactional replication where two Publishers feed into one Subscriber. Now if try to change the schema of any one Publisher or both publishers, replication breaks.

We have tried to pause the replication and change the schema in publisher as well as subscriber, but as soon as we re-start the replication it breaks.

The only option that we found is, we have to drop the replication, sync the schema and the start the snapshot replication.

Is there a better way of doing this?

1
  • I presume this question should be tagged with SQL Server or similar. May 29, 2021 at 10:27

1 Answer 1

0

From Make Schema Changes on Publication Databases:

Schema changes to tables must be made by using Transact-SQL or SQL Server Management Objects (SMO). When schema changes are made in SQL Server Management Studio, Management Studio attempts to drop and re-create the table. You cannot drop published objects, therefore the schema change fails.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.