php-mysql-diff
php-mysql-diff copied to clipboard
camcima
MySQL Schema Diff - Comparison / Migration Script Generation
Hi. I'm using PHP MySQL Diff 1.2.1 (installed from composer). I give the command these two schemas. from.schema > CREATE TABLE `post` ( > `post_date` date NOT NULL COMMENT 'Created...
Hi. Changing only table comments does not work. The alter statement is output, but there is no value. Execution result. >ALTER TABLE `target_table` > ; Is not it supposed to...
Look like not all cases handled. From MySQL help: ``` data_type: BIT[(length)] | TINYINT[(length)] [UNSIGNED] [ZEROFILL] | SMALLINT[(length)] [UNSIGNED] [ZEROFILL] | MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL] | INT[(length)] [UNSIGNED] [ZEROFILL] | INTEGER[(length)]...
https://github.com/camcima/php-mysql-diff/blob/a12f9648b9948827800dad41c62616088e4dcd10/src/RegExpPattern.php#L15
https://github.com/camcima/php-mysql-diff/blob/a12f9648b9948827800dad41c62616088e4dcd10/src/RegExpPattern.php#L14
If the from table has a ROW_FORMAT and the to table doesn't the migration sql is: ALTER TABLE `table_name` ROW_FORMAT=; Which is not a correct format, it should be ROW_FORMAT=DEFAULT...
As it is now, if the difference between two databases is a renamed table, this library will delete the old and recreate the new one, losing all the data. It...
Alternatives that could be found so fat: - A somewhat living fork by @benjaminhu: https://github.com/Benjaminhu/php-mysql-diff - Dbdiff @DBDiff : https://github.com/DBDiff/DBDiff (ancient) - Schemadiff by @phlib https://github.com/phlib/schemadiff Any other ideas?
