Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have recently setup transactional replication on our test and production databases. As part of that change, we've had to make changes to how we create upgrade scripts as well. The goal is to make changes that do not require invalidating the current snapshot.

Thus far, we've had two significant changes:

  1. For stored procedures, use ALTER instead of DROP/CREATE. This involves creating a dummy empty procedure the first time (by checking if exists) and then altering in all cases.
  2. For renaming table columns, instead of sp_rename, add new column / populate column / drop old column.

I'd like to know what other types of changes we may need to make in order to successfully upgrade the database without invalidationg the snapshot.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.