DataCompare with Command Line Utility using XML file

sandusandu Posts: 20
edited May 2, 2006 4:16AM in SQL Toolkit Previous Versions
Hi
I am trying to compare data of some tables and I am using the include and exclude arguments.
I have 4 tables 3 which I want to compare and one not
the names of the tables are:
TBL_SYSkipErrorPermission,
tbl_SYSecurityPermissionsProposed,
tbl_SYSecurityPermissionOperationProposed,
tbl_SYSecurityPermissionsAttributesProposed


I am using the following code:
<exclude objecttype="Table" matches="TBL_SYSkipErrorPermission"></exclude>
<include objecttype="Table" matches="tbl_SYSecurityPermissionsProposed"></include>
<include objecttype="Table" matches="tbl_SYSecurityPermissionOperationProposed"></include>
<include objecttype="Table" matches="tbl_SYSecurityPermissionsAttributesProposed"></include>
and the result is that none of them is compared
Can you please advice
Thanks
Sandu
· Share on Twitter

Comments

  • sandusandu Posts: 20
    the table with the exclude argument is
    tbl_SYSecurityPermissions
    withe the code
    <exclude objecttype="Table" matches="tbl_SYSecurityPermissions"></exclude>
    · Share on Twitter
  • TilmanTilman Posts: 395 Bronze 2
    Hi,

    I'm afraid the exclude/include syntax in the help file is wrong. The proper syntax is

    <exclude>ObjectType:ObjectName</exclude>

    I.e. in your case it should be:

    <exclude>Table:TBL_SYSkipErrorPermission</exclude>

    Similar for the include switch.

    Sorry about that. The help file will be up to date in the next release.

    Tilman
    · Share on Twitter
Sign In or Register to comment.