Tag: DatabaseCompare
The DatabaseCompare action, along with the applicable SetParam child actions, lets you automate the Database Comparator.
<DatabaseCompare>
<Setparam Field="Server" Value="ACME02/ACME"/>
<SetParam Field="Database" Value="mail\johnmailtestrep.nsf"/>
<SetParam Field="ModifiedAfter" Value="2015-07-25T22:00:00"/>
</DatabaseCompare>
SetParam Options
| Field Name | Compatible Field Values | Value Description | Comment |
|---|
| ModifiedAfter | User definable | Date or Date/Time in compatible YYYY-MM-DDThh:mm:ss AM/PM format | Mandatory |
| Server | User definable | Any string to define server name or IP address | Mandatory if "Database" attribute is present |
| Database | User definable | Database file path of the target database | Mandatory if "Server" attribute is present |
Sub Actions: RunAudit
The sub-action RunAudit emulates clicking the 'Audit' button in the Database Comparator; it is a mandatory action to carry out the audit proposed in the SetParam options.
Tag Attributes
| Attributes | Attribute Value | Value Description | Comment |
|---|
| Select | Differences
All | The audit mode | Not Mandatory - default is 'Differences' |
| Note | Reminder:
A MySelection action script block can be nested within this action block to add selections to a virtual My Selection folder. |
|---|
Example Script
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5" Version="1.0">
<Load Server="ACME01/ACME" Database="admin4.ntf" Select="True"/>
<DatabaseCompare>
<Setparam Field="Database" Value="alog4.ntf"/>
<Setparam Field="Server" Value="ACME02/ACME"/>
<SetParam Field="ModifiedAfter" Value="2012-07-25T22:00:00"/>
<RunAudit Select="All"/>
<Select Lines="All"/>
<Export>
<SetParam field="FilePath" value="C:\quick-export.html"/>
<SetParam field="ExportType" value="HTML"/>
<SetParam field="FileOutput" value="Unicode"/>
<SetParam field="OpenFileOnceGenerated" value="true"/>
</Export>
</DatabaseCompare>
</ytriaAutomation>
In the script above, the action DatabaseCompare and the specified SetParam options will set the Database Comparator tool to conduct an audit between the databases "admin4.nsf" on the server ACME01/ACME, and the database "alog4.ntf" located on server ACME02/ACME. The documents that will be audited are those that were modified after 10:00:00 PM on July, 25 2012. The action RunAudit will launch the audit itself and show All results. The results of this audit will be exported from the Database Comparator grid to an HTML file. The Database Comparator tool dialog will close.