DB diff between before and after, export db to txt

Question

Hello all,

I have to see a difference between 2 states of the same DB (MS SQL 2008). Profiler is not an option as it is run-time tool and needs operator actions.

I have not found tools for this purpose, so the question is - is there a way to export DB data into human-readable text format to compare them with something like windiff?

Regards,

Answer 1

I know redgate offers a product to do a Schema and a Data differential. I've personally never used it, but I've seen various demos and it sounds like it might do what you need. There is also a utility that came with SQL Server 2005 called TableDiff, that lets you compare two tables that you could probably script to compare more if needed.