Review SQL upgrade script and modify, if necessary

Before you run the Campaign upgrade tool (acUpgradeTool), determine whether you must modify the SQL upgrade script that is provided for your database.

You must modify the SQL script if you made customizations to the Campaign system tables that resulted in modifications to the default Data Definition Language (DDL) scripts that are included with Campaign. Examples are if you defined custom audience levels or changed field names.

In this case, you must modify the provided SQL upgrade script for your database to match your customizations.

The SQL upgrade scripts are installed in the /tools/upgrade/8.5+To9.0 directory. Use the appropriate script for your database type:

ac_upgrade_db2.sql: DB2® upgrade script (non-Unicode)

ac_upgrade_db2_unicode.sql: DB2® upgrade script (Unicode)

ac_upgrade_oracle.sql: Oracle upgrade script (non-Unicode)

ac_upgrade_oracle_unicode.sql: Oracle upgrade script (Unicode)

ac_upgrade_sqlsvr.sql: MS SQL Server upgrade script (non-Unicode)

ac_upgrade_sqlsvr_unicode.sql: MS SQL Server upgrade script (Unicode)

Example modifications to the SQL upgrade script