Excluding columns using an XML argument file

MikeD

I am using an XML argument file to specify the paramaters for my data comparison but I cannot find an example of how to exclude columns.

Has anyone done this or found an example?
I am using version 3.3.8.304

Mike.

Brian Donahue

Hello Mike,

You can narrow down the columns compared by SQLDataCompare using the columns tag. I'm sorry, but this doesn't seem to be documented in the curent Toolkit help file. The command line argument is documented, but the format for the XML version is not.

To compare only the testdate and test_id columns of a table named testTable, the XML argfile would look like this:

<?xml version="1.0"?>
<commandline>
   	<database1>TestDataBase</database1>
	<database2>TestDataBase2</database2>
	<columns>testTable:testdate,test_id</columns>
</commandline>

Hopefully this helps.

MikeD

Thank you Brian, that works perfectly.

Mike.