Faster way to exclude all tSQLt content
It takes a while to setup all the exclude filters, and this time is worse when the solution to a problem is to unlink and relink. Provide a way to quickly exclude tSQLt content and/or save / restore filters.
Rob
shared this idea
We provide an option to ignore all T-SQL-T content – you can get to this from the setup tab.
-
In SQL Source Control 5, you can still find this option in the Setup tab:
1. scroll to 'Options just for this database'
2. click on 'Comparison options'
3. under 'Ignore', check the 'tSQLt framework and tests' checkbox.
4. Click 'Save' -
Jamal
commented
How can you do this with SQL Source Control 5?
-
Hi Rob,
You can edit your comparison options to exclude tSQLt stuff quickly - here's how:
1. Open the Setup tab of SQL Source Control
2. Right-click the 'Linked to' path and click 'Edit Comparison Options...'
3. Change the value of the <IgnoreTSQLT> tag to 'True'
4. Click 'Save and Close'You can commit and get comparison options just like filters, so you'll probably want to commit the comparison options change once you're done. Hope that helps!
-
Valthor Druzin
commented
There's always a workaround of just copying the filter file to the new working location.
Before you unlink, On the Setup Tab of SSC, you can right click the "Linked to" path, and select "Open Working Base Location". There you can find the Filter.scpf file which you can copy and set aside. When you've unlinked and relinked the database to ssc, you can always just copy the Filter file into the new Working location using the same method of finding the working base.But, in either case, your filter file should be check into your Source Control repository anyway, so when you've just relinked you can always just go ahead and check out the filter from source control, using the 'Get Latest' tab
