Page History
...
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
...
Driver | ojdbc8.jar | postgresql-42.2.14.jar | mssql-jdbc-89.2.20.jre8.jar |
---|---|---|---|
New Version | Oracle 21.5 | PostgreSQL 42.3.2 | MS Sql Server 9.2 |
...