Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

 
discard

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.