Home
Upgrade Guide
Upgrade Guide
Upgrading Unica Campaign and Unica Optimize
You can upgrade Unica Campaign and Unica Optimize to version 12.0 from version 11.1.0 only.
SQL upgrade scripts
Use SQL upgrade scripts to upgrade your installation of Unica Campaign according to your database type.

Upgrade Guide
- Upgrade Guide
  - Upgrade overview
    An upgrade of Unica Campaign and Unica Optimize is complete when you upgrade, configure, and deploy and configure Unica Campaign and Unica Optimize. The Unica Campaign Upgrade Guide provides detailed information about upgrading, configuring, and deploying Unica Campaign and Unica Optimize.
  - Planning the Unica Campaign and Unica Optimize upgrade
    You can upgrade your current version of Unica Campaign to bring it up-to-date with the latest features.
  - Upgrading Unica Campaign and Unica Optimize
    You can upgrade Unica Campaign and Unica Optimize to version 12.0 from version 11.1.0 only.
    - Unload unused files from memory (AIX only)
    - Undeploying and upgrading Unica Campaign
      Before upgrading Unica Campaign, you must undeploy your current installation of Unica Campaign.
    - SQL upgrade scripts
      Use SQL upgrade scripts to upgrade your installation of Unica Campaign according to your database type.
    - acUpgradeTool
      acUpgradeTool updates the Unica Campaign system tables and modifies your user data to work with the new version of Unica Campaign. You can run acUpgradeTool after you run the Unica installer in the upgrade mode.
    - Running segmentUpgrade Tool
  - Upgrade considerations to Deliver
  - Deploying Unica Campaign web application
    You can deploy the Unica Campaign web application by using an EAR file or you can deploy the individual WAR files.
  - Configuring Unica Campaign and Unica Optimize after deployment
    After you deploy Unica Campaign, you must verify that the Unica Campaign listener is running, set up the Unica Campaign system user, set Unica Campaign configuration properties, and verify the Unica Campaign installation.
  - Configuring multiple partitions for Unica Campaign
    In the Unica family of products, partitions provide a way to secure the data that is associated with different groups of users. When you configure Unica Campaign or a related Unica application to operate with multiple partitions, users can see each partition as a separate instance of the application. There is no indication that other partitions exist on the same computer.
  - Configuring multiple partitions for your Unica Optimize
    In the Unica family of products, partitions provide a way to secure the data that is associated with different groups of users. When you configure Unica Campaign or a related Unica application to operate with multiple partitions, users can see each partition as a separate instance of the application. There is no indication that other partitions exist on the same computer.
  - Configuring multiple partitions in Deliver
    Configure multiple partitions in Unica Deliver to isolate and secure data for different groups of Unica Deliver users. As each partition has its own set of configuration properties, you can customize Unica Deliver for each group of users.
  - Unica Platform utilities
    This section provides an overview of the Unica Platform utilities, including some details that apply to all the utilities and which are not included in the individual utility descriptions.
  - Uninstalling Unica Campaign and Unica Optimize
    Run the Unica Campaign and Unica Optimize uninstaller to uninstall Unica Campaign and Unica Optimize. When you run the uninstaller, the files that were created during the installation process are removed. For example, files such as configuration files, installer registry information, and user data are removed from the computer.
  - Unica Campaign web application clustering
    You can configure the Unica Campaign web application (J2EE application) in a cluster by completing additional tasks during the Unica Campaign installation.
  - Upgrading to a clustered listener environment
    Follow these instructions if you want to upgrade your existing single-listener configuration for Unica Campaign to a clustered listener configuration. A listener cluster is a set of two or more listeners that act as a unit to provide load balancing and high availability. Unica Campaign listener clusters are Active-Active; meaning each node serves requests using the load-balanced approach. Each Unica Campaign listener provides an interface between front-end clients (such as the Unica Campaign web application) and back-end analytical server processes.

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.3 folder. Use one of the scripts from the following table according to your database type:

Table 1. SQL upgrade scripts according to 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.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.