Filter.scpf file not applied in dbbuildtask

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">

<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'.

ozhug January 20, 2022 03:00

Comments

1 comment

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.

Sergio R January 24, 2022 17:16

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Filter.scpf file not applied in dbbuildtask

Comments

Add comment