diffing two databases

Question

Is there a tool to find the difference between two databases.

Both the schema and the actual data are pretty much the same, but not 100%. Do you know a tool that can help to succinctly describe the changes.

Answer 1

The SQL tools from RedGate do this for both schema and data.

Edit: just noticed the tag for this is mysql so my answer will probably not be of use.

Answer 2

Do an export of both DB structures and use CVS (SVN, etc..) compare function.

Answer 3

I am not sure about free diffs, but I use Aqua Data Studio and it has great compare tools, including a Schema diff compare tool.

Answer 4

Toad for MySQL has good schema and data comparison/sync tools, and it is free.

Answer 5

Toad Data Modeler has grate tools for schema comparison

Answer 6

Nob Hill's Database Compare tool, is good for Data and Schema compare and it can do much more.

Answer 7

Try mysql-diff, command-line tool that can compare live DB or SQL script with live DB or SQL script.

Answer 8

I would definitely go with AdeptSQL if you're using MSSQL. It's the least good looking but the most talented db compare tool amongst the ones I've tried. It can compare both the structure and the data. It tells you which tables exist on one db but does not exist on the other, compares the structure and data of the common ones and it can produce the script to synchronize the two. It's not free but has a 30 day trial (as far as I can remember)

Answer 9

There is a free, Open Source, project that does exactly what you are looking for:

www.diffkit.org