Deploy dacpac files through Powershell in Azure SQL DataWarehouse database

Question

While deploying the dacpac file from powershell in Azure SQL DW database I am getting following error: Exception calling "Deploy" with "3" argument(S): "An error occurred during deployment plan generation. Deployment cannot continue."

Is there any way to deploy dacpac file in Azure SQL DW Database using Powershell?

How do you deploy your dacpac file in PowerShell? Specifically what cmdlet are you using — juvchan
– juvchan, Commented Jun 7, 2016 at 21:38
We explicitly load the .net libraries (installed by SSDT) and then use the Microsoft.SqlServer.Dac.DacPackage object in powershell to deploy the dacpac's — Amruta
– Amruta, Commented Jun 8, 2016 at 6:34

Sonya Marshall · Accepted Answer · 2016-09-30 04:36:14Z

1

SQL DW does not yet support database projects. This feature is planned. You can vote for this feature here, https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/13313247-database-project-from-visual-studio-to-support-azu, which will also give you updates to the progress of this feature.

answered Sep 30, 2016 at 4:36

Sonya Marshall

5062 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deploy dacpac files through Powershell in Azure SQL DataWarehouse database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related