mysql - Declarative SQL Schema Migrator -

all of sql database schema migration tools can find ask define schema discrete set of migration steps, amount sequences of create/alter/drop statements.

i'm looking tool enables me describe schema declaratively rather procedurally, ie. single set of create table statements or in other format, migrator inspect live database (eg. using information_schema tables) , make changes required have match schema i've described.

does such tool exist?

thanks

have @ redgate tools, have compare tool , extension generate deployment scripts used flyway:

"mysql compare":

https://www.red-gate.com/products/mysql/mysql-compare/

flysql:

http://www.red-gate.com/products/flysql/

ed