Server Fault is a question and answer site for system and network administrators. 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

Is there a way to perform a differential copy that will add only the changes in the structure from the local database to the new database?

share|improve this question
up vote 1 down vote accepted

Are you only interested in structure? If so you may need a third-party tool like Redgate's SQL tools (SQL Compare.) They're quite expensive but a really decent investment if you use SQL heavily.

If you're more interested in differential backups, SQL handles those in the maintenance plans.

share|improve this answer

Merge replication?

We've not had much luck with it in a OLTP configuration (sometimes it reorders the commands, resulting in inserts trying to merge BEFORE the structure changes that they depend on, which then causes catastrophic failures on the side receiving the changes). However, for JUST structure changes, where you're not actively submitting data at the same time it might be OK.

share|improve this answer

Your Answer


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

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