Best practices for database migrations

Richard Huxton dev at
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:

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 mailing list