Deploying extended properties to Azure and the sql generated is raising an error

MGibson

Error raised is To deploy sensitivity classification information to this platform, the ADD SENSITIVITY CLASSIFICATION syntax should be used.

MGibson

PRINT N'Creating extended properties'
GO
IF EXISTS(SELECT 1 FROM sys.system_views sv WHERE sv.name = N'sensitivity_classifications')
BEGIN
    RAISERROR('To deploy sensitivity classification information to this platform, the ADD SENSITIVITY CLASSIFICATION syntax should be used.', 16, -1)
    SET NOEXEC ON
END
GO

DanC

HI @MGibson so there's two options here really, so first if you don't mind ignoring sensitivity classifications you can use the SQL Compare option "Ignore sensitivity classifications". 

Secondly, if you do care, you will need to use "ADD SENSITIVITY CLASSIFICATION" rather than extended properties. 

I hope this helps!