Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

sqlexpress 2012 install to support dacpac?

Posted on 2014-04-08
5
471 Views
Last Modified: 2014-04-15
is there a special install for dacpac?  eg tools or advanced..

my sqlxprs instance only displays bacpac?
0
Comment
Question by:XGIS
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 39989104
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":

http://www.microsoft.com/en-us/download/details.aspx?id=35580

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):

http://www.microsoft.com/en-us/download/details.aspx?id=42299

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?
0
 
LVL 7

Author Comment

by:XGIS
ID: 39998477
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.
SSMS2012V11-ExtractDataTierOptio.png
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 39999309
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?
0
 
LVL 7

Author Comment

by:XGIS
ID: 40001343
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...
CaDpture.PNG
0
 
LVL 7

Author Closing Comment

by:XGIS
ID: 40001353
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..
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question