Best practices for database migrations

Richard Huxton dev at archonet.com
Mon Nov 18 08:17:32 GMT 2013


On 18/11/13 02:01, Simon Wistow wrote:
> Is there a current favourite for doing database migrations (i.e having a
> programatic way for a database to upgraded to a new version by having a
> series of sql commands run on it)?

Never needed anything as heavy as this, but I trust the author (David 
Wheeler) to have thought it through:

https://github.com/theory/sqitch
https://metacpan.org/release/App-Sqitch

You don't mention your target RDBMS. This was originally targetting 
PostgreSQL and now support MySQL and Oracle according to the docs.

There are a series of blog posts detailing his approach and the reasons 
behind the project too.

-- 
   Richard Huxton
   Archonet Ltd


More information about the london.pm mailing list