Options
Filter.scpf file not applied in dbbuildtask
ozhug
Posts: 5 Bronze 1
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.
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">
We are adding a view that references one of these tables 'dbo.crm_bkl_asset' and getting an error.
<Filters version="1">
<None version="1">
<Include>False</Include>
</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'.
##[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'.
Tagged:
Answers
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.
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools