Filter.scpf file not applied in dbbuildtask

ozhug

Hi all,
Within our database Microsoft Dynamics pushes data to the database and maintains tables, stored procedures, and functions it uses for doing this work.

We have excluded these from our SCA project using a filter in the Filter.scpf file.

    <Filters version="1">

      <None version="1">

        <Include>False</Include>

        <Expression>((@NAME LIKE 'crm%') AND (@SCHEMA = 'dbo'))</Expression>

      </None>

We are adding a view that references one of these tables 'dbo.crm_bkl_asset' and getting an error.

How can we use these tables that are in the database but not under the control of SCA.

##[warning] DbBuildTask: ERROR \a\1\s\Migrations\1.1.0-Changes\022_20220113-1125_fred.sql(0,0): Invalid object name 'dbo.crm_bkl_asset'.

Sergio R

You can exclude the code that creates that view from script verification : https://documentation.red-gate.com/sca/developing-databases/concepts/verifying-projects/excluding-objects-from-script-verification

Alternatively, you could add some code in that migration that checks for the existence of 'dbo.crm_bkl_asset' and creates it if it doesn't exist so that the dependency relation is satisfied.