Tag: DatabaseCompare

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


SetParam Options

Field NameCompatible Field ValuesValue Description
ModifiedAfterUser definableDate or Date/Time in compatible YYYY-MM-DDThh:mm:ss AM/PM format - Required
ServerUser definableAny string to define server name or IP address - Required if "Database" attribute is present
DatabaseUser definableDatabase 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

AttributesAttribute ValueValue Description
SelectDifferences

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

<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>
XML

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.