Take the 2-minute tour ×

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
add comment

2 Answers

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
add comment

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
add comment

Your Answer


