Versions Compared

Old Version 3

changes.mady.by.user Unknown User (s.wartenberg)

Saved on

compared with

New Version 4

changes.mady.by.user Unknown User (s.wartenberg)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Publisher database upgrade

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

Include Page
_WarnBackupDBBeforeUpgrade
_WarnBackupDBBeforeUpgrade

 

 

 

Panel

On this page:

Table of Contents
maxLevel1

Upgrade steps

 

Note
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

 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

 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

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

Step 5:

Run either

 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.

Panel

On this page:

Table of ContentsmaxLevel1

Changes in third-party libraries

Please take a look at the Blueriq Publisher 4 libraries [editor]