Allow tSQLt tests to be synchronized
I want to sync my tSQLt tests with my test environment.
Anonymous
shared this idea
If you use the -SQLCompareOptions parameter you can apply additional options – see https://documentation.red-gate.com/display/DLMA2/Using+SQL+Compare+options+with+DLM+Automation+cmdlets for more details.
Note that some of the options (including ignoretSQLt) are selected by default. You can deselect the default options by adding a minus sign (-) as documented on the above page.
-
Alex Yates
commented
You can already do this.
Using a SQL CI SYNC task to update your test database you should use the /additionalCompareArgs switch. https://documentation.red-gate.com/display/SCI1/Using+the+sync+command#Usingthesynccommand-/additionalCompareArgs(optional)
Using this switch you can add additional SQL Compare arguments to the SYNC to tweak the behavour.
If you use the SQL Compare /options switch you can apply additional options from this list:
https://documentation.red-gate.com/display/SC11/Options+used+in+the+command+line#Optionsusedinthecommandline-IgnoretSQLtNote that some of the options (including ignoretSQLt) are selected by default. You can deselect the default options by adding a minus sign (-) as documented on the SQL CI SYNC page.
-
How are you hoping this would work. Which CI task are you running?
