Excluding columns using an XML argument file

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

  Brian Donahue October 01, 2005 10:40

  - 0 +
• 
  Thank you Brian, that works perfectly.
  
  Mike.

  MikeD October 03, 2005 06:55

  - 0 +

Add comment

Please sign in to leave a comment.