Click here to Skip to main content
15,175,838 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello There!

Im new in MS SQL Server 2008. Im currently downloading SQL Server R2 Developers Edition. Do I need to download the SQL Server 2008 Management Studio?? Is that Managements Studio is just the same as MySQL GUI Tools?? I really want to learn SQL Server coz since I started Programming in VB.NET 2010 I used MySQL as my database now this is my first time to use SQL Server 2008. Can somebody help me or somebody explain it to me what is the use of that Management Studio. Im confuse right now.

Another thing please. Im using Visual Studio 2010 Ultimate. I found on my programs that there is SQL Server 2008... Is there already an SQL Server once I install the VS 2010 Ultimate or its just something.

Thanks!
So many questions... hehe
Posted

1 solution

Let's take it one by one.

Microsoft SQL Server Management Studio is a gui tool to manage most of the functionality included with SQL Server any edition. Have a look here: http://technet.microsoft.com/en-us/library/ms174173.aspx[^]. Well, have a really deep look, by reading most if it, if possible.

This should be included in the Developer edition, and you should be able to select it when installing. But I encountered people saying that they could not manage to install the tool directly. But no problem, you can install Management Studio Express separately. I suggest you install the 2012 version which can be downloaded from here: http://www.microsoft.com/en-us/download/details.aspx?id=29062[^] (click on download and check only the Management Studio x86 or x64 in the list)

And finally: no, SQL server is not included in Visual Studio.
   
Comments
Member 9529406 8-Dec-13 9:01am
   
oh i see.. thank you for the reply... can i use the Management Studio Express 2012 even if im using SQL Server 2008 R2 developers edition?
Zoltán Zörgő 8-Dec-13 14:16pm
   
Yes. They are compatible.
Member 9529406 8-Dec-13 19:36pm
   
oh thank you i will try it when i finish my download..
Zoltán Zörgő 13-Dec-13 11:38am
   
Any progress?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900