How can we help you today? How can we help you today?

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

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

Comments

2 comments

Sort by
  • 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

    MGibson
    0
  • 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!
    DanC
    0

Add comment

Please sign in to leave a comment.