Solved

Management Studio vs EnterPrise Manager?

Posted on 2007-03-30
9
383 Views
Last Modified: 2012-05-05
Following a "system event" here, our MS partners upgraded our SQL Server installation, a subject we/I know just a little about.

We previously had Enterprise Manager, which I was just getting familiar (and happy) with.  We no longer seem to have that program, instead we have Management Studio and Visual Studio.  I am a little familiar with Visual Studio, having previously downloaded it to "play" with.  I found however, that I could do most of my regular maintenance, table activities and query analyzer easier with Enterprise Manager.

1. Is Management Studio the "replacement" for EM or are they 2 different things?
2. Are Visual Studio and Management Studio different tools to do the same things?
3. Is it possible to get EM "back".  How?
0
Comment
Question by:Volibrawl
  • 4
  • 3
  • 2
9 Comments
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 250 total points
ID: 18822960
1. Is Management Studio the "replacement" for EM or are they 2 different things?
Yes, and also includes the Query execution process...there is no longer a separate "Query Analyzer" utility

2. Are Visual Studio and Management Studio different tools to do the same things?
Visual Studio is an Integrated Development Environment....a programmers tool (bery short version)

3. Is it possible to get EM "back".  How?
If they bumped you from SQl 2000 to 2005 (sounds like they did), then no.
0
 
LVL 8

Assisted Solution

by:drydenhogg
drydenhogg earned 250 total points
ID: 18822980
1. Yes, its a replacement, although I look it as more of an upgrade.
2. Visual Studio is a different tool, you might see it in terms of the BI aspects of SQL Server
3. Don't both going back to EM, Mgmt Studio will let you manage both 2005 and 2k databases, I have a vague memory that 2k wouldn't let you manage 2005 databases, but can't confirm, I uninstalled it some time back.

hth.
0
 
LVL 9

Author Comment

by:Volibrawl
ID: 18823021
Thank you  ... you are indeed accurate in that we "originally" had 2000, then upgraded to 2005.  EM was at that point probably a "legacy" remnant of the original 2000 installation (but worked).  In our new server this time around, they would (logically) only have installed 2005.

I would appreciate a little more blurb on what you DO with Visual Studio, in my context.

1. I create databases to be used with Access front ends via ODBC links.
2. I will soon probably need to create some stored procedures.
3. I will soon probably want to create some triggers, and more SQL specific actions.
4. I will be trying to develop a backup strategy and backup automation for my SQL tables.



0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 18823077
In terms of your context, you will not do any of those using the visual studio.

Actions 2,3 and 4 you will do using the management studio.
Action 1 you will do within Access still.

The visual studio with SQL server is for the BI tools, such as Integration services, Analysis services and reporting services.

hth.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18823082
You don't need VS for any of your listed items, as far as I know.  Only "if" you want to create the SPs and triggers in a .Net language such as C#, and I think you can do that completly within MS as well
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18823097
Also, for what its worth, if you have SQL Server specific questions, here is the link to the Zone for SQL 2005:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/#browseZones

That should save you the effort of finding the right checkbox to cross-post your questions.  I have never been to this one before :D
0
 
LVL 9

Author Comment

by:Volibrawl
ID: 18823227
Thanks for the link  .. I don't even know what TA's my questions are getting posted in these days.  Further, there are 10 different paths to the same TA, so a "tree" is useless in that regard as well.  I thought I selected SQL as my first TA, but who knows?

0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18823273
Your question went to Hardware>>Servers

I know, because these are the first points I've ever earned there :D
0
 
LVL 9

Author Comment

by:Volibrawl
ID: 18824016
Congratulations  ... broadening your horizons ... :)  Only 900 more TA's to go.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

929 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now