Solved

sql server management studio

Posted on 2014-03-17
10
308 Views
Last Modified: 2014-03-17
Hi Guys
there doesn't appear to be a 2012 or 2014 Express management studio,
Does anyone know if the 2008 version of management studio Express works on 2012 Express database?
(as well as 2005 database?)
thanks
0
Comment
Question by:COACHMAN99
10 Comments
 
LVL 22

Assisted Solution

by:Steve Wales
Steve Wales earned 150 total points
ID: 39934681
There certainly does appear to be.

Check out the download link:

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

There are options there for the engine with or without the tools.

If you already have the engine, there's a link to download the tools only.
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 39934689
Hi Steve,
I looked there before I placed the question, and still only see a link to MStudio 2008.
there doesn't appear to be a 2012 or 2014 Express management studio
Where is the link to tools?
thanks
0
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 50 total points
ID: 39934705
Click the "Download" button and you will be presented with a list of files to choose from. You want either ENU\x86\SQLManagementStudio_x86_ENU.exe or ENU\x86\SQLManagementStudio_x64_ENU.exe depending on your environment.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 7

Author Comment

by:COACHMAN99
ID: 39934717
there doesn't appear to be a 2012 or 2014 Express management studio,
Does anyone know if the 2008 version of management studio Express works on 2012 Express database?
(as well as 2005 database?)
0
 
LVL 18

Assisted Solution

by:Jerry Miller
Jerry Miller earned 50 total points
ID: 39934730
From what I have seen working across 2005, 2008, and 2012 SQL databases, each version is limited in what it can do when accessing another version.

For example, SSIS packages have to be created in the correct version or they will not work on the server. I can create stored procedures in a lower version (2005) using 2008 but cannot create tables. It may be the way that the SSMS was installed on this computer.

If you can download the latest version, I would use that on the newer databases. It seems to work a lot better.
0
 
LVL 22

Assisted Solution

by:Steve Wales
Steve Wales earned 150 total points
ID: 39934752
The version from the download link above is definitely SSMS for 2012.  I installed it a little while back.  Launching SSMS that I downloaded from that download site I get this:

SSMS 2012 Splash Screen
Definitely appears to be 2012 to me.

Haven't played with 2014, can't comment on that specifically.

Historically, the versions of SSMS do appear to be backwardly compatible to a point (see above response).  However, why not install the appropriate tool for the DB Version you're using and launch the one you need as you need it ?
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 39934755
I need to upgrade form 200 to 2012 Express. (via 2005) so I need both versions of the db on the box, and a management studio -
there doesn't appear to be a 2012 or 2014 Express management studio,
Does anyone know if the 2008 version of management studio Express works on 2012 Express database?
(as well as 2005 database?)
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 39934758
the above ssms appears to be for full not express?
0
 
LVL 22

Accepted Solution

by:
Steve Wales earned 150 total points
ID: 39934766
I downloaded it with SQL Server 2012 Express Edition when I installed it.  That's the only place it came from.
0
 
LVL 7

Author Closing Comment

by:COACHMAN99
ID: 39934772
I'll try and see, thanks all for input :-)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

777 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