As the Publisher 4.0 aligned with Blueriq 10, the database columns are updated from VARCHAR to NVARCHAR.
Unable to render {include} The included page could not be found.
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.