Migrating AWA (Automic Workload Automation) database
Article ID: 195182
Updated On:
Products
CA Automic Workload Automation - Automation Engine
CA Automic Workload Automation - Automation Engine
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.
Feedback
Yes
No
Powered by
