Updating your archive databases allows you to take advantage of the performance enhancements provided by optimized indexing in the latest version. When you update an archive database, IDERA SQL Compliance Manager locks the Repository and applies the new indexing scheme to the specified database.
You can update your archive databases using the Management Console or the command line interface (CLI).
Update your archive database using the Management Console
To update archive databases using the Management Console:
- Attach existing archives.
- Select Auditing > Configure Repository Databases.
- On the Configure Repository Databases window, select the Databases tab.
- Select the databases you want to update, and then click Update Now.
Update your archive databases using the CLI
To update your archive databases using the CLI:
- From a DOS prompt, navigate to your SQL Compliance Manager installation directory.
- Enter the following at the prompt:
SQLcmCMD updateindex –all