Kbase P137619: What is the best way to move audit policies from one database to another?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2011 |
|
Status: Verified
GOAL:
What is the best way to move audit policies from one database to another?
GOAL:
Can audit policies be exported from one database and imported to another database?
GOAL:
Is it possible to dump audit policies from one database and load them into another?
GOAL:
How to Dump and Load Audit Policies from one database to another
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
FIX:
The Audit Administrator may export policies from a database using the Audit Policy Maintenance tool to create a .xml file containing the policies and then import these same policies to a new database which has Auditing Enabled.
To Export existing policies to a xml file chose the following from the Audit Policy Maintenance tool menu:
1. File/Export Policy ...
2. Supply path/file-name
3. Click OK to create the .xml file.
The .xml file may be imported using the Audit Policy Maintenance tool on the new database after Auditing has been enabled by choosing:
1. File/Import Policy ...
2. Browse to path and select xml file-name containing the polices
3. Click OK to import the .xml file selected in step 2.
The Audit Administrator may also use the Data Administration tool to dump Audit Policies as ASCII text, which then can be loaded using the standard Load methodology using:
1. Admin/Dump/Audit Policies/Dump as Text (.ad file) ...
2. Admin/Dump/Audit Policies/Audit Events
The resultant .ad files may then be imported using by choosing:
1. Admin/Load/Load Data and Definitions/Table Contents (.d file) ..."
2. Check the Show Hidden Tables toggle
3. Select the Audit Policy tables named:
_aud-audit-policy
_aud-file-policy
_aud-field-policy
_aud-event-policy
_aud-event