You can quickly and easily upgrade to this version of IDERA 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.x 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.x 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 and later require that you upgrade the SQL Compliance Manager agents to the same version, i.e. version 5.0 requires Agent 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. |
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal