Page History

...

1. Use the SQL Compliance Manager setup program to manually deploy the SQL Compliance Manager Agent to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database.

...

1. Use the SQL Compliance Manager setup program to manually deploy the SQL Compliance Manager Agent to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -Regulation {PCI | HIPAA | PCI, HIPAA}.

...

1. Use the SQL Compliance Manager setup program to manually deploy the SQL Compliance Manager Agent to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "FERPA regulation guideline file path".

...

1. Use the SQL Compliance Manager setup program to manually deploy the SQL Compliance Manager Agent to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "SOX regulation guideline file path".

...

1. Determine which currently audited database has the audit settings you want to apply to the new database.
2. Export your audit settings from the source database.
3. Use the SQL Compliance Manager setup program to manually deploy the SQL Compliance Manager Agent to the instance that hosts the target database.
4. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "exported audit settings file path".