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

MGibsonMGibson Posts: 15 Bronze 2
Error raised is To deploy sensitivity classification information to this platform, the ADD SENSITIVITY CLASSIFICATION syntax should be used.
Tagged:

Answers

  • MGibsonMGibson Posts: 15 Bronze 2
    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

  • 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!

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.