Publisher database upgrade

As the Publisher 4.0 aligned with Blueriq 10, the database columns are updated from VARCHAR to NVARCHAR. Therefore Blueriq has updated it's schema. Also, due to the upgrade to Hibernate 5 (which is more strict then older versions), Blueriq leverages on the default Hibernate behavior for generating ID's. This means Blueriq does not rely on IDENTITY columns anymore and introduced SEQUENCES to be more in sync with Oracle. 

The scripts can be found in the Publisher installation zip in dbscripts/publisher and dbscripts/publisher-client.

 

On this page:

Upgrade steps

 

The steps should be executed by an experienced DBA-er and all necessary precautions should be taken before migration.


Step 0: Backup the database for publisher as well as publisher-client.

Step 1: Run either mssql_update_4.0.0_script_01.sql or oracle_update_4.0.0_script_01.sql. This will rename the current tables.

Step 2: Run either oracle.sql or mssql.sql. This will create the new tables.

Step 3: Run either mssql_update_4.0.0_script_02.sql or oracle_update_4.0.0_script_02.sql. This will copy the data from the old tables to the new tables.

Step 4: Test the publisher and publisher-client so you know everything works as expected.

Step 5: Run either mssql_update_4.0.0_script_03.sql or oracle_update_4.0.0_script_03.sql. This will remove the old tables.

Changes in third-party libraries

Please take a look at the Blueriq Publisher 4 libraries