Tables are compared, don't matching include switch

DanielL

i try to achieve synchronizing only 1 table, especially only adding new entries to the destination

i am using command line SQLDataCompare.exe with an argfile:

<?xml version="1.0"?>
<commandline>
<server1>Server1</server1>
<database1>Logging</database1>
<server2>Server2</server2>
<database2>Logging</database2>
<include>Table:[Applications]</include>
<synchronize/>
</commandline>

but other tables are also compared and synchronized. WHY???

sam.blackburn

In the documentation, the table name is not in square brackets. Does that make a difference?

https://documentation.red-gate.com/display/SDC13/Using+XML+to+specify+command+line+arguments

DanielL

Square brackets are necessary, if the regular expression would hit more than 1 table (e.g. ApplicationsConfiguration and Applications

The solution was to escape the square brackets.

<include>Table:\[Common\]\.\[Applications\]</include>

sam.blackburn

Glad you found a solution, and thanks for sharing it!