Recommend this page to a friend! |
Classes of Shabeer ALi M | PHP MySQL Scheman | README.md | Download |
|
DownloadMySQL SchemanMySQL schema, a simple MySQL schema synchronization utility. This will create an UPDATE/ADD query automatically based on the schema difference in the database and schema file. Why we use MySQL SchemanDevelopers find it very hard to synchronize MySQL schema while developing any application. The current conventional method is to create an SQL file with all the changes & update it in the staging/production server. The main demerit of this method is if there are multiple people and multiple SQL changes on the same table the process is a bit hectic. In order to solve this, we developed a platform where you can update the schema in a file, and by running sync to database it will create the SQL Query for the changes and it will execute. InstallationIf you use Composer, you can install MySQL Scheman with the following command:
{
}
./vendor/bin/scheman --help
./vendor/bin/scheman --config config.json --export yourdatabase.json
./vendor/bin/scheman --config config.json --sync yourdatabase.json
|