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,
WITH ROLLBACK IMMEDIATE;
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.