Publish DACPAC file failed due to bind rule with a user-defined data type

[ssreerama]

• SqlPackage or DacFx Version: 6.1.8089.0
• .NET Framework (Windows-only) or .NET Core: both
• Environment (local platform and source/target platforms): Tested on SQL MI / SQL 2022
• Issue: When cx try to publish a DACPAC file to an existing databse (Azure SQL MI) that has bind rule with a user defined data type they will get error :SQL72018: SqlRule could not be imported but one or more of these objects exist in your source.

Steps to Reproduce:

1. Create a database [DBOAD01]
2. Run the below script 1
3. Deploy the attached sample dacpac using the NET Core version (ICM: 377020710 has the sample dacpac).

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

[ssreerama]

Script -1: to create user defined data types and adding bind rule.

USE [DBOAD01]
GO
CREATE TYPE [dbo].[u_id] FROM [bigint] NOT NULL
GO
CREATE TYPE [dbo].[u_upd_dt] FROM [datetime] NOT NULL
GO
CREATE TYPE [dbo].[u_web_lgn_cd] FROM [bigint] NOT NULL
GO
CREATE RULE [dbo].[r_acr_cyc_mo_qt] 
AS
@range>100;
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[r_acr_cyc_mo_qt]', @OBJName=N'[dbo].[u_id]'