XML Comparison Columns

lc6529lc6529 Posts: 30
When using an XML File, Is There A Way To Tell SQLDataCompare
Which Columns to use in the comparison?

I have two tables to compare and without getting into a lot of detail, I need to compare the non-indexed fields CUSTOMER and PARTNO


  • Options
    I assume you are using an xml file to specify command line arguments and you want to use the non-indexed fields CUSTOMER and PARTNO as the comparison key.
    To specify a comparison key that is is not an index, use the GUI to set up and save a project with the settings you require. You can then use that project from the command line with the /Project switch.
    http://documentation.red-gate.com/displ ... mmand+line

    For more information on using the GUI to set comparison keys, see Selecting the comparison key, under Selecting tables and views.
    http://documentation.red-gate.com/displ ... parisonkey
    Manfred Castro
    Product Support
    Red Gate Software
  • Options
    Ok, I did that and I piped the results to a text file.

    I used these switches

    /Include:Missing /Include:Different /Include:Identical /Verbose /Sync

    and my report file looks like this EACH time I run it.

    Object type Name Records DB1 DB2
    Table [dbo].[Orders] 4694 == ==
    Table [dbo].[Orders] 20 <> <>

    Am I doing something wrong?
  • Options
    If you want to include or exclude objects from an existing project, you must modify your selection using the graphical user interface. You cannot use the /Include and /Exclude switches with /Project.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.