Argfile Exclude large number of objects

wodutoit

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

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.