5 ms·
Maybe you should have a look to liquibase (http://www.liquibase.org/ http://www.liquibase.org/) then. Although it uses sequence to label the migration changese
by gizmogwai 14y ago
Maybe you should have a look to liquibase (http://www.liquibase.org/ http://www.liquibase.org/) then.
Although it uses sequence to label the migration changeset, it does not rely on them to ensure that the DB is in a correct state. It relies on a hash of the various changesets so that if a changeset is updated while already applied, the system will complain about it.
- freshhawk 14y agoThat's a very interesting solution, I like the sound of it. I will check it out.
- mtrimpe 14y agoJust make real sure you don't change the formatting of a hard-coded SQL command or you'll have to add a 'validCheckSum' attribute to cover up for your past mistakes. Otherwise I can also recommend liquibase, especially since they've since added support for non-SQL (JVM code) updates and rollbacks as well.