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:
What are you using? Do you know of a tool that fits me needs?