IDERA SQL Compliance Manager saves exported alert rules in XML format for you to apply to other registered SQL Server instances. This flexibility saves you time when you are configuring Event and Status Alert rules on multiple SQL Server instances, and helps ensure consistency across your environment. In addition, exporting allows you to back up your alert rules to use should you need to reinstate an audited SQL Server instance. As you configure alert rules, consider which settings you would like to save for future use, and export the rules configured for that particular SQL Server instance or database.
To export your alert rules:
- Select Alert Rules in the Administration tree.
- Click Export Rules.
- Enter a file name or use the default.
- Select the location to save your alert rules file.
- Click Save.