ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Migrating AWA (Automic Workload Automation) database

book

Article ID: 195182

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine 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

Here are two ways to do this:

1. Use the DB Unload and use the 'Unload all objects'. 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 (reports and statistics are not moved)

2. Use the Client Copy utility to copy client(s) over to another environment (reports and statistics are moved, but this must be done between the exact same version)

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