Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
When upgrading an existing database from a dacpac we are bound to use all standard options from Dacpac deploy as there is no way to set DacDeployOptions or a publish profile. So in the case we are upgrading a database with core functionalities built in a dacpac there is no way to do this in ADS with a dacpac if you need to not drop objects not in source or set other options.
Proposed solution
Add options dialog button to "Deploy Dacpac Settings" page similar to the functionality already available in SqlProjects.Publish made in #15483
Alternatives
Convert .dacpac to a sqlproj and use publish or install SQLPackage.exe and set all options in CLI
Additional context
Page with missing options
Publish project currently supports both
gruset
commented
1 year ago
When upgrading an existing database from a dacpac we are bound to use all standard options from Dacpac deploy as there is no way to set DacDeployOptions or a publish profile. So in the case we are upgrading a database with core functionalities built in a dacpac there is no way to do this in ADS with a dacpac if you need to not drop objects not in source or set other options.
Proposed solution Add options dialog button to "Deploy Dacpac Settings" page similar to the functionality already available in SqlProjects.Publish made in #15483
Alternatives Convert .dacpac to a sqlproj and use publish or install SQLPackage.exe and set all options in CLI
Additional context Page with missing options
Publish project currently supports both
