Filter SQL Test objects via command line or XML config

JackAce · March 5, 2014 12:38PM

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.

Eddie D · March 6, 2014 8:51AM

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

Filter SQL Test objects via command line or XML config

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk