SqlPackage and ANSI_NULLS/QUOTED_IDENTIFIER

Question

I know the values of these 2 fields are locked to true in the designer, to be made available in a future release. However, even when I use the /p:IgnoreAnsiNulls=True and /p:IgnoreQuotedIdentifers=True parameters to SqlPackage /Action:Script, the generated incremental script still includes the following. Why isn't the different being ignored?

        ALTER DATABASE [$(DatabaseName)]
            SET ANSI_NULLS ON,
                QUOTED_IDENTIFIER ON,
                ANSI_NULL_DEFAULT ON
            WITH ROLLBACK IMMEDIATE;

Answer 1

Hello Richard

Thank you for your question. The IgnoreQuotedIdentIdentifiers and IgnoreAnsiNulls are options that control the comparison of script based objects like views and procedures. If you do not want to have the database options scripted, you can set the ScriptDatabaseOptions to false.

-Lonny