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:
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>
<include>Identical, Missing, Different</include>
Can anyone assist please?