data comparison tool

[mjhessler]

Does anyone have an opinion on specific “data comparison tools”?

We are looking for something to use in our test or dev environments that will be able to compare snapshots of the data in a 14 gig SQL SERVER database before verse after a test event. There are 545 tables in the db.

We have been able to record and compare data in specific tables but are learning that other tables were also being changed that we didn’t track. We want to be able to see all changes to the database. Please share your experience or recommendation on a third party tool or method.

 

[SQLDenis]

SQLCompare by RedGate is pretty good

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[SQLSister]

I think Dennis means SQLDataCompare - SQL compare compares structure, SQL DataCompare compares data inthe tables. At any rate, Red-gate has good products and the couple of times I've had to deal with them over a technical issue, they were great to work with. I highly recommend any of their products.

Questions about posting. See faq183-874

 

[SQLDenis]

You are right SQL Data compare, here is a screenshot of their bundle which I have installed

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[mjhessler]

How does red-gate "SQL Data compare" compare with Apex SQL Diff? Has anyone tried both or know why one might be better than the other? I want to know my options before I recommend a purchase. I haven't try either of them yet.