XML Comparison Columns

• 
  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 June 05, 2013 13:58

  - 0 +
• 
  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 June 05, 2013 15:20

  - 0 +
• 
  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 June 05, 2013 15:45

  - 0 +

Add comment

Please sign in to leave a comment.