Run Database Comparator

Tag: DatabaseCompare

The DatabaseCompare action, along with the applicable SetParam child actions, lets you automate the Database Comparator.

SetParam Options

Field Name	Compatible Field Values	Value Description
ModifiedAfter	User definable	Date or Date/Time in compatible YYYY-MM-DDThh:mm:ss AM/PM format - Required
Server	User definable	Any string to define server name or IP address - Required if "Database" attribute is present
Database	User definable	Database file path of the target database - Required 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
Select	Differences All	The audit mode - Not Required - Default is 'Differences'

Reminder: A MySelection action script block can be nested within this action block to add selections to a virtual My Selection folder.

Example Scripts

XML

<DatabaseCompare>
	<Setparam Field="Server" Value="ACME02/ACME"/>
	<SetParam Field="Database" Value="mail\johnmailtestrep.nsf"/>
	<SetParam Field="ModifiedAfter" Value="2015-07-25T22:00:00"/>
</DatabaseCompare>

XML

<ytriaAutomation>
	<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.