Automic UTF-8 DB Migration

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.
Return to list
automic
Automic UTF-8 DB Migration

Automic Features

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.