MIGRATEdb Files

MIGRATEdb Release Notes

==================================================================================================
29 October 2014 Version 0.9
==================================================================================================
* BUG: More than 2 substitution variables in parsed SQL would result in an error.
* Preserve new lines when parsing SQL.

==================================================================================================
4 August 2012 Version 0.8
==================================================================================================
* BUG: Ignore empty lines at the end of an sql file. Causes invalid SQL error in Oracle.
* Add a "parse" parameter to allow the parsing of statements in SQL script files to be turned off.
* Change ordering of output message so that the SQL that failed is printed.
* Ignore lines that have "whenever" or "prompt" at the start.
* Performance improvement (Rework migration queries so that database bind variables are used).

==================================================================================================
13 September 2009 Version 0.7
==================================================================================================
* Allow substitutions of &variable.
* Add a path variable for the SQL script.
* Allow specified path and file for SQL scripts to be Ant variables.
* BUG: revert to Java 1.5.

==================================================================================================
4 September 2009 Version 0.6
==================================================================================================
* Ignore the upper/lower case of 'true' in exists="true".
* Added ability to run an external SQL script file for a test or action.
* Add option to output the executed SQL to a file.
* More custom Oracle migrations added.

==================================================================================================
19 February 2007 Version 0.5
==================================================================================================
* Code refactored: use runtime exceptions, some renaming
* Allow substitution of any ANT property.
* More custom Oracle migrations added.
* Raise an exception when a substitution in the SQL (eg ${some-variable}) is not replaced.
* Improve management of the database connection.

==================================================================================================
11 September 2006 Version 0.4
==================================================================================================
* Allow many tests to be specified for a change - each test is an exit point from the change.
* More custom Oracle migrations added.

==================================================================================================
23-May-2006 Version 0.3
==================================================================================================
* Add Generic Migrations to packaged migrations and to documentation.

==================================================================================================
5-May-2006 Version 0.2
==================================================================================================
* Add Derby database to the project to facilitate better testing and show a working usage example.
* Allow custom migrations to be supplied via a program parameter. Project includes beginning custom file for Derby and Oracle databases.

==================================================================================================
30-March-2006 Version 0.1
==================================================================================================
Basic functionality.