Skip to main content
3 of 6
added 47 characters in body
Peter
  • 1.5k
  • 1
  • 16
  • 36

Temporarily removing replication from Publisher

Is it possible to temporarily remove Transactional Replication from a publisher database in order to allow a release to be executed against the database?

If I stopped the log reader agent would I be able to perform DDL/DML changes against the publisher database without error?

The product vendor has a bespoke tool which issues the T-SQL commands against the database for the release, which will include dropping and recreating constraints, keys, indexes etc. I need to make sure releases can happen without error caused by replication - the database needs to allow the changes.

Publisher and Distribution db live on the same server. Both publisher and subscriber are SQL 2014 Enterprise. I am replicating the entire database.

Help is appreciated. Thanks Peter

Update: Yes I am replicating schema changes

Peter
  • 1.5k
  • 1
  • 16
  • 36