Filter SQL Test objects via command line or XML config

JackAceJackAce Posts: 75
edited March 6, 2014 8:51AM in SQL Compare Previous Versions
Is there an easy way to filter out objects needed for SQL Test / tSQLt / SQLCop? I thought there was an option to have these automatically filtered in SQL Compare.

Right now, I am filtering these objects using the <exclude> tag in the XML configs, but it seems tedious to list out all these exclusions.
&lt;exclude&gt;Table:\&#91;tSQLt\&#93;&lt;/exclude&gt;
&lt;exclude&gt;StoredProcedure:\&#91;SQLCop\&#93;&lt;/exclude&gt;
&lt;exclude&gt;StoredProcedure:\&#91;UnitTest\&#93;&lt;/exclude&gt;
&lt;exclude&gt;StoredProcedure:\&#91;tSQLt\&#93;&lt;/exclude&gt;
&lt;exclude&gt;View:\&#91;tSQLt\&#93;&lt;/exclude&gt;
&lt;exclude&gt;Function:\&#91;tSQLt\&#93;&lt;/exclude&gt;
&lt;exclude&gt;Assembly:\&#91;tSQLtCLR\&#93;&lt;/exclude&gt;
&lt;exclude&gt;UserDefinedType:\&#91;tSQLt\&#93;&lt;/exclude&gt;

Is there an easier way? I thought I had a conversation with David Atkinson a while back who mentioned that there was some flag you could specify that filtered these objects automatically.

Comments

  • Eddie DEddie D Posts: 1,646 Rose Gold 5
    Hi, thank you for your forum post.

    Please try enabling the option to ignore "tSQLt framework and tests" in the Ignore section of the SQL Compare options.

    Via the GUI ->Edit project ->Options tab -> Ignore -> tSQLt framework and tests

    Via the command line use the /options:ignoretSQLt or /options:itst.

    Using a XML argument files <options>itst</options>

    A full list of the available project options can be found HERE.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.