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
Overview
Content Tools