...

Currently i2b2 db upgrade is a multi-step process of running upgrade SQL scripts and stored procedures individually on db instance. This release simplifies the process of running the table upgrade SQL scripts scripts  and stored procedures from data_build.xml .

Steps to Perform db upgrade:

...

files

...

.

...

...

1.7.09c

...

In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-09c upgrade_tables_release_1-7-10 upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a

In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a

In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-10  upgrade_tables_release_1-7-12a

In the Pmdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-09c  

...

1.7.10

...

In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_table_release_1-7-10 upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a

In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a

In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-10 upgrade_tables_release_1-7-12a

1.7.11

...

In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11  upgrade_table_release_1-7-12a

In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-11 upgrade_tables_release_1-7-12a

In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a

...

In the Crcdata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a

In the Hivedata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a

In the Metadata folder run the following ant command: ant -f data_build.xml upgrade_tables_release_1-7-12a

...

Details are here

Changelog

Database Drivers

...

...