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