Does anyone have an idea for a scipt that can check an array/XML of table definitions with the current database tables and make appropriate alter/create queries to synch them? I'm currently using php5 and mysql 5.
有没有人知道scipt可以使用当前数据库表检查表定义的数组/ XML并进行适当的alter / create查询来同步它们?我目前正在使用php5和mysql 5。
2 个解决方案
#1
I have a feeling that MySQL Workbench is able to create alter/diff SQL scripts
我觉得MySQL Workbench能够创建alter / diff SQL脚本
#2
pick some database migration framework or write your own. and read this https://blog.codinghorror.com/get-your-database-under-version-control/
选择一些数据库迁移框架或编写自己的。并阅读此https://blog.codinghorror.com/get-your-database-under-version-control/
#1
I have a feeling that MySQL Workbench is able to create alter/diff SQL scripts
我觉得MySQL Workbench能够创建alter / diff SQL脚本
#2
pick some database migration framework or write your own. and read this https://blog.codinghorror.com/get-your-database-under-version-control/
选择一些数据库迁移框架或编写自己的。并阅读此https://blog.codinghorror.com/get-your-database-under-version-control/