Page History

...

Use the following checklist to help you migrate your Collection Server.

Image Removed

Image Added	Follow these steps ...

Image Removed

Image Added

Prepare

 for

for your migration.

Image Removed

Image Added

Execute your migration by: Restoring the Repository databases Deploying the new Collection Server Configuring the

SQLcompliance

SQL Compliance Manager Agent connection

Image Removed

Image Added

If you use Microsoft Reporting Services to generate reports about your audit data, change the Reporting Services data source to use the restored Repository databases.

Image Removed

Image Added

Test your new Collection Server deployment and setup.

Migration best practices

Before you execute your migration strategy, decide whether you will want to permanently move the Collection Server to another computer.

...

• To minimize audit data loss, plan to backup the Repository databases on the temporary Collection Server immediately before reinstating the original Collection Server
• Use these migration procedures to reinstate the Collection Server on the original computer, configure the SQLcompliance SQL Compliance Manager agents, and configure Reporting Services
• To verify all components were reinstated correctly, test your implementation
• Uninstall the Collection Server you previously implemented on the temporary computer

SQL Compliance Manager audits all activity on your server. Learn more > >

...

...