Migrations

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

Migrations Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Apache
  • Price:
  • FREE
  • Publisher Name:
  • Sejal Patel
  • Publisher web site:
  • Operating Systems:
  • Mac OS X
  • File Size:
  • 1.7 MB

Migrations Tags


Migrations Description

Free and open source utility for standardizing and safely migrating database schemas from one version to another Migrations works off of a simple pattern based system. Migrations will 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). Here are some key features of "Migrations": · 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. · Easy to use unix and windows startup scripts What's New in This Release: · Updated the sql error dialogs to allow resuming the sql execution without aborting the entire process. · Updated the internal algorithm for determining migrations to determine all resources needed before starting any migration instead of running migration and then discovering missing resources. · Updated the templating code to only error/prompt for template values if a resource needed during that migration has need of the value. · Improved the algorithm to more accurately display the progress meter across multiple simultaneous schema migrations. · Disabled the property name text field in the property update popup to reduce confusion. · Fixed an issue where not providing all of the connection information would cause the application to try and proceed with invalid values.


Migrations Related Software