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

Oracle

PostgreSQL

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.