Volibrawl
asked on
Management Studio vs EnterPrise Manager?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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
Also, for what its worth, if you have SQL Server specific questions, here is the link to the Zone for SQL 2005:
https://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
https://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
ASKER
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?
Your question went to Hardware>>Servers
I know, because these are the first points I've ever earned there :D
I know, because these are the first points I've ever earned there :D
ASKER
Congratulations ... broadening your horizons ... :) Only 900 more TA's to go.
ASKER
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.