Migration prerequisites

The prerequisites for the migration are as follows:

Basic prerequisites

  • Take a backup of your existing database.
  • Copy the file system of the previous version to the mount location.
  • Provide appropriate values the database parameters of all Unica components.
  • For Interact, the schema name in the target setup should be the same as the one in the base setup.
  • Manually map the tables and restart the Campaign Pod.

SQL Server-specific prerequisites

If your database is SQL Server database, before executing the migration, manually execute the following SQL files on the Platform database:

  • If the Base version is 9.1.x
    • HOME_DIR/Platform/db/db/upgrade91to911/ManagerSchema_DB_Type_911upg.sql HOME_DIR/Platform/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql;
    • HOME_DIR/Platform/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql; HOME_DIR/Platform/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql;
    • HOME_DIR/Platform/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql; HOME_DIR/Platform/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql;
    • HOME_DIR/Platform/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql; HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql;
    • HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 9.1.2
    • HOME_DIR/Platform/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql; HOME_DIR/Platform/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql;
    • HOME_DIR/Platform/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql; HOME_DIR/Platform/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql;
    • HOME_DIR/Platform/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql; HOME_DIR/Platform/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql;
    • HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql; HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 10.0.0
    • HOME_DIR/Platform/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql; HOME_DIR/Platform/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql;
    • HOME_DIR/Platform/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql; HOME_DIR/Platform/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql;
    • HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql; HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 10.1.0
    • HOME_DIR/Platform/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql; HOME_DIR/Platform/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql;
    • HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql; HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 11.0.0
    • HOME_DIR/Platform/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql; HOME_DIR/Platform/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql;
    • HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql; HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 11.0.0
    • HOME_DIR/Platform/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql; HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql;
    • HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 11.1.0
    • HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql; HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 11.1.0
    • HOME_DIR/Platform/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql; HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • If the Base version is 12.0.0
    • HOME_DIR/Platform/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql