XML Comparison Columns

lc6529

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

Manfred.Castro

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

lc6529

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

---

OK

Am I doing something wrong?

Manfred.Castro

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.