XML ArgFile and <include>

[d3jul]

I have a pb with the switch <include> in my argfile.
It compare all the tables of the database instead of comparing tables that are in the list.

My ArgFile :
<?xml version="1.0"?>
<commandline>
<server1>10.3.58.12\metier</server1>
<database1>BO</database1>
<server2>10.3.54.12</server2>
<database2>BO</database2>
<include>Table:ANIMPRIX</include>
<scriptfile>c:\test_compare\Data_Upgrade_BO.sql</scriptfile>
<out>c:\test_compare\Data_Upgrade_BO.log</out>
</commandline>

My .bat:
sqldatacompare /argfile:"c:\test_compare\Config_Compare_Data_BO.xml"


I have the 9.0.1.2 version of SqlDataCompare.

Thanks

[james.billings]

Thanks for your post. Does it work if you bracket the table? For instance:

<include>Table:\[ANIMPRIX\]</include>

If not, it may be a bug. I've found one here where the include option occasionally is ignored, although I thought it only related to working with script folders...
If the change above doesn't help, can you see if the same thing occurs in 8.50? You can find that here

[d3jul]

I have the same issue with the bracket.

I will test with 8.50.

Thanks for the reply.

[d3jul]

It's OK with the 8.5 version.

Thanks.

[james.billings]

Ahh, good to hear. I'll add a note of this forum thread to the bug we have; hopefully it can get looked at soon.

[efrelund]

Is there any update on this? I think I am seeing the same problem...

When i specify /Include:Missing on the command line, or <include>Missing</include> in an xml args file, the command line tool includes all my tables, instead of the ones that I include in the /Include:Table: list, or in the <include>Table:X</include> xml tags.

We really need to be able to include only certain tables, but also set the include missing flag.

Thanks!

Red Gate SQL Data Compare Command Line Utility V9.0.0.117