Author: cen Language: text
Description: database migrations Timestamp: 2017-08-29 11:25:11 +0000
View raw paste Reply
  1. In ep 332 someone asked about database migrations and what tools to use.
  2.  
  3. I strongly suggest using Liquibase. It requires java, but if you can gloss over that fact it is simply the best database migration tool out there. It supports pretty much all major database dialects, migrations are written in language agnostic formats like XML/JSON so you can use it in any project. It support conditionals (eg: seed database only when migrating in devel environment), skip non critical migrations on error and many more features. You can also mark a migration to only be run for a specific database dialect. I successfully reused a single migration set to produce tables on postgres, oracle, db2 and sql server with just minor tweaks. I've been using it for 2 years now and I am yet to find a critical feature that is missing or a bug that would be a deal breaker. Documentation is also decent and there is a lot of help out there, including stackoverflow.
  4.  
  5. Best regards, cen
  6.  
View raw paste Reply