Options : Schema Changes Tab

This tab allows you to set the option related to changes you make in the databases. These changes will be reported depending on the time range you choose. For example, if you choose ApexSQL Audit to report schema changes every one hour, then if you make changes to the database during this time interval, these changes will be reported.

For information about any button in the Options dialog click here.

Check for Schema Changes Behaviour

Automatically Report Schema Changes on Project Open option controls a way the schema changes check will be performed each time you open an Audit Project.

Report Every Schema Changes for option allows you setting up a time range for reporting the detected schema changes.

Time Range	Description
Starts	Will check for schema changes every "n" application launches.

Hours	Will check for schema changes every "n" hours.

Days	Will check for schema changes every "n" days.

Weeks	Will check for schema changes every "n" weeks.

Report Schema Changes for Non Audited Tables

If this option is selected then the changes you made even in non-audited tables will be reported at the time range you chose to check the schema changes.

New Object Behaviour

If Automatically Check All New Tables option is selected then the new tables will be marked for auditing.

If Automatically Check All New Fields option is selected then the new fields will be marked and the table(s) they belong to will be prepared for auditing.