Redgate SQL Compare XML Syntax INCLUDE Syntax

lc6529

I am trying to compare a table that exists in separate databases on two different servers.

Table 1 is the master, there is a job that will truncate all data once a week and then repopulate it.

Table 2 exists on a production server.

My comparison goal is to compare table 1 to table 2 and only ADD new records or MODIFY existing records and do nothing when the tables are identical.

I can do this through a command line argument and I when I pipe the results to a text file I can see if records were added, modified or both tables are identical.

I would like to use an XML argument file, but when I do so I get the message Error: The selected objects are identical or no objects have been selected in the comparison.


My command line looks like this:

sqldatacompare /Argfile:Compare_Tables.xml

I know my XML file is correct in the setup for the servers, databases and passwords. The area I am having issues with is the INCLUDE statements.

I have tried:

<include>Table:\[LABELFORMATS\]Identical, Missing, Different</include>
<synchronize/>
</commandline>

And

<include>Table:\[LABELFORMATS\]</include>
<include>Identical, Missing, Different</include>
<synchronize/>
</commandline>

Can anyone assist please?

Brian Donahue

With the command-line, you can do /Include:Missing globally, but you cannot apply that on a per-table basis. You should just use <Include>Missing</Include> as one of the XML elements to include all missing records.

lc6529

Yes that seemed to work!

Thanks!