How to compare two database tables structure in mysql

DBDiff is an automated database schema and data diff tool. It compares two databases, local or remote, and produces a migration file of the differences automatically.

When used alongside a compatible database migration tool, it can help enable database version control within your team or enterprise.

Supporting DBDiff

DBDiff is a MIT-licensed open source project with its ongoing development made possible entirely by the support of backers.

For getting a mention in return, please consider:

Features

• Works on Windows, Linux & Mac command-line/Terminal because it has been developed in PHP
• Connects to a source and target database to do the comparison diff, locally and remotely
• Diffs can include changes to the schema and/or data, both in valid SQL to bring the target up-to-date with the source
• Some tables and/or fields can be ignored in the comparison with a YAML collection in the config file (see File Examples)
• Diffs are SUPER fast and this tool has been tested with databases of multiple tables of millions of rows
• Since this diff tool is being used for m
  how to compare two database tables structure in mysql
  how to sync two databases in mysql