XML ArgFile and <include>
d3jul
Posts: 4
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
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
Comments
<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
Redgate Software
I will test with 8.50.
Thanks for the reply.
Thanks.
Redgate Software
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