Orchard Hungary is an archive

This site is now an archive. We'll keep it so the content is accessible, but we won't update it anymore. However, we frequently publish Orchard-related news on our other site Orchard Dojo, so be sure to check that out instead. And if you're interested in news about our Orchard development company, Lombiq, check out our website.

SQL database scripting/diff tools that work

Tags: database, SQL, SQL Server, diff

Tuesday, August 28, 2012 5:26:19 PM

Recently I needed software for one very specific task: given two databases, calculate their (data and schema) differences and generate an appropriate change script. There are dozens of solution for this, but I tried many till I found two that satisfied the following criteria:

  • Work with SQL Server
  • Diff data and schema of the whole database (not just individual tables)
  • Either be free or have a reasonable price (there are a lot of supposedly great tools out there, but frankly I find $600 or even $1000 a bit expensive for an individual developer licence)

And the winner is...

Atlantis Schema Inspector and Atlantis Data Inspector! Both tools just work great: after comparing two databases besides being able to generate a change script they can also be directly synchronize. Actually due to module migrations for Orchard almost only Data Inspector is needed.

Oh, I forgot the other app, haven't I (I really count the Atlantis tools as one)? The other one is Data Synchronization Studio from Simego. It also looks great and I've also seen it work great with some databases, but with one particular DB I quickly got fatal errors, so I had to use Atlantis's tools.

Happy diffing!

No Comments