About the problem of making changes to the database during the development of the application they wrote on Habré manytimes . Versioned database migration is a convenient approach to solving a problem.
For a long time I have been involved in the development of ECM7.Migrator - a tool for automating database changes. How to use it and why it is convenient, we wrote here .
8 months ago we released version 2.0, and this week version 2.6 was released. Compared to version 2.0, much has changed.
The classes of all providers have been completely rewritten: the API has become simpler and more convenient, all methods work adequately (and a large number of unit tests were written to check the adequacy);
SQL Azure and Firebird support;
The Up and Down methods are renamed Apply and Revert; it is not necessary to implement Revert ;
Handling query delimiters (for example, “GO” for MSSQL);
Ability to work with DB schemas (different from the default schema);