How can we help you today? How can we help you today?

XML ArgFile and <include>

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
d3jul
0

Comments

5 comments

Sort by
  • James B
    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
    James B
    0
  • d3jul
    I have the same issue with the bracket.

    I will test with 8.50.

    Thanks for the reply.
    d3jul
    0
  • d3jul
    It's OK with the 8.5 version.

    Thanks.
    d3jul
    0
  • James B
    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.
    James B
    0
  • 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
    efrelund
    0

Add comment

Please sign in to leave a comment.