@Nagesh CL Thanks for your patience, sorry for the delay in my response,
The SSDT interface for “deployment options” is for performing the publish action in SSDT. These options won’t apply to deploy/publish operations in other interfaces such as ADO pipelines.
The pipeline task for “Azure SQL Dacpac Task” has a field for additional parameters where users can input additional options, such as /p:ScriptDatabaseOptions=False. More information about the available properties is available in the SqlPackage documentation - https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?view=sql-server-ver16#properties-specific-to-the-publish-action
I hope this information helps.
Regards
Geetha
Hi @GeethaThatipatri-MSFT ,
Is there any response on the issue please?
Thanks.
Hi @GeethaThatipatri-MSFT ,
Is there any response on this issue please?
Thanks.