<jack>

If it’s too hard you’re doing it wrong.

tern - The SQL Fan's Migrator

Posted at — Feb 7, 2011

I just released tern – a new migration system.

Tern is designed to simplify migrating database schemas with views, functions, triggers, constraints and other objects where altering one may require dropping and recreating others. For example, if view A selects from view B which selects from table C, then altering C could require five steps: drop A, drop B, alter C, recreate B, and recreate A. Tern can be told to alter C and it will automatically perform the other four steps.

Head over to Github for more details.