Migrations Free and open source utility for standardizing and safely migrating database schemas from one version to another
Download

Migrations Ranking & Summary

Migrations Tags

Migration Migrate database migration schema database schema move database source version migrating files

Migrations Description

Migrations works off of a simple pattern based system. Migrations is an application created to be told the location of a configuration file (often referred to as the migrations.xml). Whereever this file is located at will be 1 or more folders which contain sql scripts. Each folder represents a schema concern (things which could in theory reside in different database schemas even if they don't always in reality). Main features: Multiple schema interactions with dependency resolution for both upgrade and downgrade Runtime substitution of values such as tablespace names or data types Version tracking of schema changes Clean path for upgrading and downgrading the database Multiline script support for doing things like pl/sql Final raw sql script generation Basic auditing of schema information including when it was modified, who modified it, and the ip it was modified from. Production mode allowing for only upgrades to take place and not allowing accidental destruction of schema and data. Clean migration indicators to allow understanding of which delta migrations failed and whether or not to prevent further migrations until human intervention has taken place in case of bad migration scripts. Simple API usable for testing frameworks to do cleaner integration testing.

Migrations Related Software