XML Comparison Columns

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

XML Comparison Columns

Postby lc6529 » Wed Jun 05, 2013 5:38 pm

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
lc6529
 
Posts: 20
Joined: Wed Apr 18, 2007 7:32 pm

Postby Manfred.Castro » Wed Jun 05, 2013 6:58 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Follow Up

Postby lc6529 » Wed Jun 05, 2013 8:20 pm

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?
lc6529
 
Posts: 20
Joined: Wed Apr 18, 2007 7:32 pm

Postby Manfred.Castro » Wed Jun 05, 2013 8:45 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron