What are the challenges you face when working across database platforms? Take the survey
Options

Argfile Exclude large number of objects

wodutoitwodutoit Posts: 2
edited August 27, 2009 9:27AM in SQL Compare Previous Versions
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

Comments

  • Options
    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
Sign In or Register to comment.