You can quickly and easily upgrade to this version of SQL Compliance Manager from version 4.5 or later. All versions prior to 4.5 must upgrade to version 4.5 before upgrading to this version. Upgrading SQL Compliance Manager allows you to take advantage of the new features available in this latest version.
The SQL Compliance Manager 5.0 installation kit default extraction path is the same as previous versions and may cause issues if the previous files still reside at that location. Before launching the SQL Compliance Manager 5.0 upgrade, either select a different installation location or delete the files from the following location:
c:\Program Files\Idera\SQLcompliance x64 Installation Kit or c:\Program Files (x86)\Idera\SQLcompliance x86 Installation Kit
SQL Compliance Manager 5.0 requires that you upgrade the SQL Compliance Manager agents to version 5.0.
Upgrade checklist
 | Follow these steps ... |
|---|---|
| Ensure the computers on which you want to upgrade SQL Compliance Manager meet or exceed the hardware, software, and permissions requirements for this version. For example, ensure .NET 4.0 or later is running on the target computer. |
| Ensure your Windows logon account has local administrator permissions on the computers you intend to upgrade. |
| Close all open applications on the computers running the SQL Compliance Manager components. |
| Back up your trace directories, especially the Collection Server Trace Directory. |
| Upgrade your SQL Compliance Manager Repository, Collection Server, and Console. |
| When prompted, schedule a time for SQL Compliance Manager to perform maintenance on your Repository databases. |
| |
| Upgrade your previously deployed SQLcompliance Agents. |
| Ensure your upgrade includes any new reports by redeploying the SQL Compliance Manager reports. If you are upgrading from version 3.0 or earlier and you use Microsoft Reporting Services, you must redeploy the SQL Compliance Manager Reports in order to generate reports using the upgraded Repository databases as the data source. |
| Test your upgrade by collecting and reporting on your audit data. |
SQL Compliance Manager audits all activity on your server. Learn more > >