deploy dacpac via SSMS 2012 missing values

Question

ok, I have VS2012, SSDT, and SSMS 2012 installed on my box along with an instace of SQLServer 2008 R2.

I build a DB project that references another project in the same solution. I have it defined in the SQLCMD Variables with a Default & Local value. I build the solution. It generates a dacpac file in the sql folder. I then try to deploy it in SSMS and it fails saying Missing Values.

How do I load a publish xml file when deploying with SSMS IDE??? I know I can use SQLPackage.exe via CMD Line but would like to use SSMS Wizzard.

Thanks in advance!

Jeremy

---

In the book of life, the answers aren't in the back.

Answer 1

Hi Jeremy,

To Deploy a DAC Using a Wizard:

1.In Object Explorer, expand the node for the instance to which you want to deploy the DAC.

2.Right-click the Databases node, then select Deploy Data-tier Application…

3.Complete the wizard dialogs:
•Introduction Page
•Select DAC Package Page
•Review Policy Page
•Update Configuration Page
•Summary Page
•Deploy Page

Deploy a Data-tier Application: http://msdn.microsoft.com/en-us/library/ee210569.aspx.

Hope this helps,
Maggie

 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 2

Hi Jeremy,

I’m writing to follow up with you on this post. Was the problem resolved after performing our action plan steps?

If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.  

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 3

I was using the deploy wizard but this must be an issue with me not knowing how to use the new LocalDB projects in Visual Studio 2012. When I build the project in VS 2012, it generates the dacpac file but it is missing the parameters since they are kept in the publish.xml file. I will look into again soon, but for now I have to get some work done before I come back to this :-)

Thanks for your help!

---

In the book of life, the answers aren't in the back.

Answer 4

I don't think the question has been answered. I'm having the same problem, and this link (http://sqlblog.com/blogs/jamie_thomson/archive/2012/11/13/a-dacpac-limitation-deploy-dacpac-wizard-does-not-understand-sqlcmd-variables.aspx) seems to make sense to me. Simply put, this is a product limition of current dacpac deployment wizard tool.