The File option from the SQL Compliance Manager Menu allows users
Available actions
Connect
New
Registered SQL Server - Starts the New Registered SQL Server wizard, allowing you to enable and configure auditing on another SQL Server instance.
Audited Databases - Starts the New Audited Database wizard, allowing you to enable auditing on additional databases hosted by this SQL Server instance. For more information, see Add Audited Databases.
SQL Server Login - Allows you to create a SQL Server login. SQL Compliance Manager creates this login at the SQL Server instance that hosts the Repository databases. For more information, see Create a login.
Alert Rule - Allows you to create a new alert using the New Event Alert Rule wizard. SQL Compliance Manager stores this alert rule in the Repository.
Event Filter - Allows you to create a new event filter using the New Event Filter wizard. IDERA SQL Compliance Manager stores this event filter in the Repository.
Import
- Audit settings - Allows you to import audit settings previously exported from another audited instance or database. For more information, see Import your audit settings wizard.
- Alert Rules - Allows you to import alert rules previously exported from another SQL Server instance. By default, the imported alert rules are disabled. For more information. see Import your alert rules.
- Event Filters - Allows you to import Event Filters previously exported from another SQL Server instance. By default, the imported Event Filters are disabled. For more information, see Import your Event Filters.
Export
- Audit settings - Allows you to export audit settings for this SQL Server instance to an XML file. This file includes audit settings configured at the server and database level. You can later use this file to import audit settings across multiple SQL Server instances, ensuring consistent auditing and compliance throughout your environment.
- Alert Rules - Allows you to export all previously-created alert rules to an XML file. You can later use this file to import alert rules across multiple SQL Server instances, ensuring consistent alerting on activity throughout your environment. For more information, see Export your alert rules.
- Event Filters - Allows you to export Event Filters created for this SQL Server instance to an XML file. You can later use this file to import Event Filters across multiple SQL Server instances, ensuring consistent filtering of specific events throughout your environment. For more information, see Export your Event Filters.
Attach Archive Database
Manage Licenses
Exit
Exits the SQL Compliance Manager Windows Console.