• Created by Unknown User (s.wartenberg), last modified on Oct 09, 2017

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Publisher database upgrade

As the Publisher 4.0 aligned with Blueriq 10, the database columns are updated from VARCHAR to NVARCHAR. 

 

 

 

 

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 [editor]

 

  • No labels