Migrating AWA (Automic Workload Automation) database

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

We offer several utilities that can be used to facilitate moving the AWA database to a separate or even different database type (i.e. SQL to Oracle).

Environment

SQL Server

Oracle

PostgreSQL

Resolution

1. Use the DB Unload and use the 'Export all data'. This will put the content of the database in a transport case that can then be then loaded to another environment using the DB Load utility

2. Use the Client Copy utility to copy client(s) over to another environment

It is highly recommended reducing the number of statistics and reports before using either option.