UTF-8 DB Migration Action Pack

Helps migrating to UTF8 DB before upgrading to Automic Automation V24


A UTF-8 enabled database is a prerequisite for an upgrade to V24 of Automic Automation.

The Migration Action Pack migrates the data in your existing (source) AE DB to a new (destination) database configured for UTF-8 before you start the regular upgrade process to V24.

The majority of the migration can take place during normal AE operation, parallel to your usual workload activities.

Different scenarios are available to help you plan your migration and upgrade process.  

The majority of the migration can take place during normal AE operation, parallel to your usual workload activities.

Online part #1 addresses the large set of historical data in the AE DB that no longer changes. Old data is copied to the new UTF-8 AE DB.

The Workflow provides three modes that copy data from the source to the destination DB:

  • Initial - copies the main part of the data.
  • Refresh - copies the delta data since the initial or last refresh step. It can be repeated multiple times to keep the data copied in Final as little as possible.
  • Final - copies the last portion of data and creates the SQL statements for the offline step.


Offline part #2 happens during the AE’s downtime. It focuses on recently changed data, which could not be copied in the online step. As of now, you cannot use your old database anymore.

The AE is shut down, and the AE DB data no longer changes. The SQL statements generated in the Online Step are executed on the destination DB.

The SQL statements generated after the final mode are applied to the destination DB while the AE is offline/shut down. The remaining data is copied from the source to the destination DB with the help of a DB link.

 

The migration action pack is fully documented in the Automic Automation online Documentation
Upgrading > Manual AE System Upgrade > Migrating the AE DB to UTF-8

Please log in using your Broadcom account to download this plugin.
Find platform support and compatibility information for Package.UTF8.DB.Migration in our compatibility matrix.
Please log in using your Broadcom account to download this plugin.
Products Automic Automation
Versions 24.*
Last update 2024-09-17 13:40:55.0
Supported by