我使用SQL CREATE脚本从MySQL workbench导出，然后使用他们的“导出SQL ALTER”功能，我最终得到了一系列创建脚本(当然编号)和ALTER脚本，可以应用它们之间的更改。

3.- Export SQL ALTER script Normally you would have to write the ALTER TABLE statements by hand now, reflecting your changes you made to the model. But you can be smart and let Workbench do the hard work for you. Simply select File -> Export -> Forward Engineer SQL ALTER Script… from the main menu. This will prompt you to specify the SQL CREATE file the current model should be compared to. Select the SQL CREATE script from step 1. The tool will then generate the ALTER TABLE script for you and you can execute this script against your database to bring it up to date. You can do this using the MySQL Query Browser or the mysql client.Voila! Your model and database have now been synchronized!

来源:MySQL Workbench Community Edition: Schema同步指南

当然，所有这些脚本都在版本控制下。

My team versions our database schema as C# classes with the rest of our code. We have a homegrown C# program (<500 lines of code) that reflects the classes and creates SQL commands to build, drop and update the database. After creating the database we run sqlmetal to generate a linq mapping, which is then compiled in another project that is used to generate test data. The whole things works really well because data access is checked at compile time. We like it because the schema is stored in a .cs file which is easy to track compare in trac/svn.

查看使用源代码控制管理数据库更改的LiquiBase。

是的,总是这样。您应该能够在需要时使用一组有用的示例数据重新创建生产数据库结构。如果你不这样做，随着时间的推移，保持运行的小改变会被遗忘，然后有一天你会被咬，严重的。这是一种保险，你可能认为你不需要，但当你这样做的那一天，它的价格是它的10倍!

RedGate软件提供了一些很棒的工具，可以帮助你对数据库进行版本化。确保让开发者为开发工作构建自己的独立本地数据库，而不是依赖于“开发服务器”，因为“开发服务器”有时可能停机，有时也可能不停机。

我有一切必要的重新创建我的数据库从裸露的金属，减去数据本身。我相信有很多方法可以做到这一点，但我所有的脚本等都存储在subversion中，我们可以通过将所有这些从subversion中取出并运行安装程序来重建DB结构等。