I need SQL data differencing tool for testing

I’m currently looking for a SQL data differencing tool that has the features:

  • Support for SQL 2000 and 2005
  • For the purpose of database migration testing, allow data snapshot comparisons. Tools I’ve encountered so far allow you to compare two, up and running databases which isn’t what I want to do. I want to snapshot a database, run my database upgrade installer, snapshot after the upgrade and then compare the two snapshots.

I’ve been recommended and have reviewed the following but they don’t meet my 2nd criteria:

AdeptSQL Diff

Red Gate SQL Compare

What are you using? Do you know of a tool that fits me needs?

4 Responses to I need SQL data differencing tool for testing

  1. sats says:

    This is not a solution but another problem i am facing
    with the same scenario

    1. I need to perform the database migration testing

    Old database is MySQL and New Database SQL Server

    Please can any one tell us the tool which supports the above criteria

  2. Steve says:

    I believe Red Gate’s SQL Data Compare meets your second requirement. It’s been a while since I’ve used it, but, at my last gig we used SQL Compare and Data Compare to figure out all the changes that needed to go into our upgrade scripts.

  3. You might also look at tools from Idera and Innovartis. I think they both have something that might do what you want.

    Also I wrote a little tool called Scriptio to do SQL Server 2005 scripting. I think this will be improved with SP2. You can easily Google for Scripitio.

  4. Shawn says:

    Hi, I’ve really enjoyed your blog 🙂 Just came across <a href="http://schemacrawler.sourceforge.net/">SchemaCrawler</a&gt; and was reminded of this post – thought it might address your need.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.