> Looking for a tool that I can compare like db's on different servers.
> I.E. I want to compare and see differences in the data on our dev
> server versus our production servers.
> Anyone know of a good one?
AlfaAlfa's SQL Server Comparison Tool (SCT) -
www.sql-server-tool.com
- can compare data between tables, even in dbs on different servers.
You can select between two methods of comparisons - row-by-row
comparison or primary key comparison (in the second case, the program
will compare data with matching PKs). You can fine-tune comparison -
exclude selected columns, specify offset etc.
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.
