Excluding columns using an XML argument file

MikeDMikeD Posts: 9
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • Thank you Brian, that works perfectly.

    Mike.
This discussion has been closed.