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


Article ID: 195182


Updated On:


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


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).


SQL Server




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.