QAInsight.net, QABlog.com, QABlog.net
Brent Strange's thoughts on Software Quality Assurance and technology

 
Wednesday, February 14, 2007
 
 

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?