Allow deployment to SQL via SQL Project inside Visual Studio
I use a SQL Project in Visual Studio using SQL Data Tools, it would be nice to be able to deploy to SQL using the DACPAC file it creates, as it can update the database using that file
This is available from the community library
Jon Kennerly commented
Yes. Please support dacpac based deployments. Declarative (model) based database management for our company is a much better system, as it frees the cycle up from various governance issues involved with SQL Change Script methods. We will never go back to change scripts.
We do like Octopus Deploy, but would rather see dacpac support as a first class feature--that rather than a manual PowerShell dacpac call.
Ivan Perez commented
Wow, this is not in Octopus deploy? This is definately a deal killer for my company. Please support this feature and we'll adopt Octopus deploy!!!