I would appreciate any recommendations on a database comparison tool.
My situation:
I have two databases which are supposedly from the same version of my software product. However, a casual examination of a few tables has revealed that some of the tables in database A are missing fields or are noticably different from their counterpart in database B.
I need a tool that will do a table-by-table comparison of the two databases and return a side-by-side list of the differences in structure, indexes, contstraints, and triggers. It should also tell me if there are tables in database A that were missing in database B, and vice versa.
Ideally, this should be something I can download for free from Microsoft or a third party vendor, but I might be able to get a little money from the IT budget if the tool provides a proven ROI. Regardless of the cost, the tool must be relatively small (under 10MB), and should be able to be run on databases while they are in production without any sort of noticable performance lag on the production systems.
My situation:
I have two databases which are supposedly from the same version of my software product. However, a casual examination of a few tables has revealed that some of the tables in database A are missing fields or are noticably different from their counterpart in database B.
I need a tool that will do a table-by-table comparison of the two databases and return a side-by-side list of the differences in structure, indexes, contstraints, and triggers. It should also tell me if there are tables in database A that were missing in database B, and vice versa.
Ideally, this should be something I can download for free from Microsoft or a third party vendor, but I might be able to get a little money from the IT budget if the tool provides a proven ROI. Regardless of the cost, the tool must be relatively small (under 10MB), and should be able to be run on databases while they are in production without any sort of noticable performance lag on the production systems.