A DirectManage Audit 3.x installation typically creates and deals with two types of databases i.e. an Audit Server database (also known as the Management database) and Audit Store database. The Audit Server database stores DirectManage Audit 3.x application specific settings whereas the Audit Store database is used to store the actual audited user sessions. A typical DirectManage Audit 3.x installation consists of one Audit Server database and one or more Audit Store database(s).

In a nutshell, here are the steps involved when migrating database from one database server to another:

Step 1  - Stop all the collectors

Step 2  - Take backup of existing databases (optional but recommended)

Step 3 -  Detach the existing databases and attach them to the new database server

Step 4  -  Ensure that CLR integration is enabled on the new database server and login for NT AUTHORITY\SYSTEM exists on the server

Step 5  -  Restore the TRUSTWORTHY flag and owner of the database

Step 6  - Modify the newly attached Audit Server database

Step 7 -  Restoring connection between Audit Server database and Audit Store database

Step 8  -  Update the database entries in Active Directory

Step 9  -  Start all the collectors

Attached document explains in details each step above should be taken in case if database migration is inevitable in order to keep the impact on the DirectManage Audit system as minimal as possible.