See Also:
To change the default architecture file that opens see Options.
The Architecture files (. audx) contain all the information ApexSQL Audit requires to set up Auditing on your database. They are XML based files that contain tags for a variety of template attributes like Name and Description as well as a tag for each of the major scripts required to run ApexSQL Audit, for example the DDL script to set up the Auditing tables.
ApexSQL Audit ships with a complete, ready to use Architecture Profile ( ApexSQL.audx) that you can use unmodified and which should fit the needs of most customers. It will be opened by default by ApexSQL Audit.
|
See Also:
To change the default architecture file that opens see Options.
|
To view and edit an architecture file's SQL Script tags and Architecture Name and Architecture Description attributes, open the "Manage Audit Architecture" form in the Outlook Bar as shown here.
If an architecture file has already been loaded by ApexSQL Audit this form will open pre-populated. Note: Architecture Name and Architecture Description text boxes are filled out and all of the script nodes are enabled (
), meaning they contain SQL Scripts. If any nodes are disabled (
) then this means scripts are missing.
This node contains a SQL Script
This node does not contain a SQL Script, it was never populated or has been cleared by the user.
|
Button |
Description |
|
|
This will create a new architecture file. |
|
|
|
|
|
This will open an architecture file. The Open Audit Architecture File dialog displays. |
|
|
|
|
|
This will save the current architecture file. |
|
|
|
|
|
This will save the current architecture file with a new name. |
|
|
|
|
|
Installs the architecture file. A warning is displayed before installation. |
|
|
|
|
|
Removes all auditing structures of the database. A warning is displayed before removing. |
|
|
|
|
|
Analysis the current architecture file. The Script Execution Result window will be displayed after analysis is complete. |
|
|
|
|
|
Opens the online help. |
|
|
|
|
|
Closes the dialog. Architecture changes are checked prior to close and if changed, user is given opportunity to save. |
|
|
|
|
|
Displays the Edit Element window allowing you to edit the script of the selected node. |
|
|
|
|
|
Removes the script information related to the selected node. |
|
|
|
You can edit the scripts simply by double clicking on the Node you want to view or edit. Alternatively you can click 
or 
, or click "Edit" or "Clear" from the tree view's right click
popup menu.
This will allow you to edit the individual sections of scripts.
After you make changes - hit the 
button.
|
Tech Tip:
To commit any final changes to the Audit Profile (. audx) file itself you must Save the Architecture file via the main form.
|
Editing and Saving individual scripts in memory will not automatically save the Audit Profile. This two-step process allows you to close the Manage Architecture file with the option to not save the changes you have made.
Finally, the Manage Architecture form will allow you to Install, Remove and Analyze your architecture file just the way it can be done in the "Install Architecture" form. This will let you quickly test and check your changes if you are making significant changes to an existing profile or creating a new one.
An example of Open Audit Architecture File is displayed below:
Select the architecture file and click 
.
In the dialog below, click 
if you want to install the scripts of the architecture file, otherwise click 
.
In the dialog below, click if you want to remove the architecture file, otherwise click .
An example of Script Execution Results window is displayed below:
Copyright © 2008 ApexSQL LLC. All Rights Reserved.
