Procedure 2: SQL upgrade scripts
Use SQL upgrade scripts to upgrade your installation of Unica Campaign according to your database type.
The SQL upgrade scripts are in the
Campaign_Home/tools/upgrade/12.1+To12.1.7 folder. Use
one of the scripts from the following table according to your database type:
SQL upgrade script | 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) |
If you are using Optimize and upgrading prior to v12.0 versions please execute the extra indexes using below SQL:
aco_extra_indexes_db2.sql
aco_extra_indexes_mariadb.sql
aco_extra_indexes_ora.sql
aco_extra_indexes_sqlsvr.sql
You will not need to execute this script if you are installing Optimize as a clean install.