🏗 👀 I'm working on a companion app for this package 👀 🏗
mysqlcompare
mysqlcompare is a command line tool to compare two database schema's and retreive the difference in an sql file.
Installation
composer global require lloadout/mysqlcompare
Usage
Init
Connection data can be defined in a connections.json file , to create the connection file you run the following command
mysqlcompare init
a connections.json
file will be created , specifying a source and target connection and an sqlfile to store the sql statements in.
If you connect through an ssh connection you specify user@host:port
in the ssh field of the json. Your password will be prompted, either for you user or your ssh key.
Compare
The execution of comparison is done via
mysqlcompare compare