sqlexpress 2012 install to support dacpac?

is there a special install for dacpac?  eg tools or advanced..

my sqlxprs instance only displays bacpac?
Who is Participating?
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
I'm not sure exactly what you're asking here, but are you looking for a SQL 2012 component? Like from the feature packs? If you want to install something there, like SMO or the native client, you can check this link and expand "Install instructions":


If you're looking for SQL Management Studio for your Express installation, you can find the new SQL 2014 version here (click download, and then Management Studio is at the bottom of the list):


If that's not what you're looking for, can you include some additional details, like a link to what you're looking for or some explanation of the features you think you're missing?
XGISAuthor Commented:
Hello Ryan,
Pls note the extract data tier option I have in SSMS at home is as per the attached.
The version I was using on my laptop remotely may have been different.. I will get some shots from it..  I did try to install the DAC extensions but it said it was already done.
Ryan McCauleyData and Analytics ManagerCommented:
So to clarify, you see that option in SSMS when you're at home, but you don't see it in SSMS on your laptop? If that's the case, can you confirm that the versions of SSMS match in both places?
XGISAuthor Commented:
Hello Ryan... After I did some extra installs I think Shared Management Objects yielded the required menus.  From memory the DAC framework said a more recent versions was already installed with SSMS.     The version on the laptop was actually 11.0.2100.60 which may explain some of the differences also...
XGISAuthor Commented:
Thankyou for your time.. the answer was to install the extra components... and better still do a total reinstall of the same version for best compatibility..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.