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

Argfile Exclude large number of objects

We have a database that has a large number of stored procedures and tables that I want to exclude from the comparison.
I have the compare being executed by a NANT build file and I am trying to use either the command line /execute: or the arg file <exclude>

There is no real pattern to a lot of the stored procedures or tables so the regular expression doesn't really help. (or if I use the pattern I will exclude procedures that I want included)

what is the best way to do this?

E.g.
<exclude>StoredProcedure:\[taRequesterItem0\]</exclude>
<exclude>StoredProcedure:\[RequesterVariableAllocation1\]</exclude>
This would be my preference but how many exclude nodes are supported?

OR
<exclude>StoredProcedure:\[taRequesterItem0\]|\[RequesterVariableAllocation1\]</exclude>
This looks ugly if you have 100 - 400 stored procedures to exclude.

Thanks
wodutoit
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    The method of using multiple <exclude> is the way I would do it.

    I'm not aware of a limit that would cause a problem.

    E.g.
    <exclude>StoredProcedure:\[taRequesterItem0\]</exclude>
    <exclude>StoredProcedure:\[RequesterVariableAllocation1\]</exclude>

    Let me know if you have any problems.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.