Skip to content
← SQL Change Automation

How can we improve SQL Change Automation?

SQL Change Automation

Categories

JUMP TO ANOTHER FORUM

(thinking…)

allow passing filters to SQLCI

We have a shared database environment that is usesdby many applications that have different release schedules. We need a way to filter to a specific set of objects (i.e. schema, and/or object name)

3 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Chad Hattabaugh shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Michelle Taylor responded  · 

Filters can now be passed to relevant cmdlets using the -FilterPath parameter and to SQLCI.ps1 using the filter parameter.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Peter Gerrard commented  ·   ·  Report

    Hi Chad,

    SQL CI already supports filters used by SQL Source Control and that get checked in to Source Control, or by using /additionalCompareArgs to override that filter.

    How you set /additionalCompareArgs depends on how you use SQL CI (generally in the advanced options), you then need add to /additionalCompareArgs something like:
    /filter:C:\MyFilters\filtername.scpf