issues

This tool does not exist. The idea is a sister tool to mk_table_sync, which compares and synchronizes data. This one can compare and synchronize table structures. There is prior art on this point; see issue 438. It is important to do both static and (optionally) dynamic analysis. Only by sampling data can we know that a column was renamed, for example, rather than dropped and added.

The roadmap is to

• Create a set of modules that can compare schema and generate ALTER TABLE statements
• Add dynamic analysis to inspect data and see if it's possible to learn additional information about the tool
• Look at prior art, such as SQLYog's functionality, or this tool