SQL Management Studio comes in two flavours:
1. SQL Management Studio
This edition comes with all versions of SQL Server 2005 except SQL Server 2005 Express Edition. This edition has various advanced features like import data from other database systems, export data to other databases etc.
2. SQL Management Studio Express
SQL Management Studio Express is part of SQL Server 2005 Express Advanced edition. You can download Management Studio Express as a separate tool also. Some of the key features like Import data, export data etc are missing in the Express edition of Management Studio.
For learning purposes and development purposes, the express edition serves the purpose. After all, it is FREE !
The non express edition of the management studio is also free when you purchase non express editions of SQL Server 2005, but you have to pay several thousand dollars for the SQL Server license.
Popular Posts
-
Differences Between Java and C/C++ It is no secret that the Java language is highly derived from the C and C++ languages. Because C++ is cur...
-
In previous chapters, you learned to how to connect to SQL Server 2005 using management studio. In this chapter, you will learn how to creat... -
Structure of a program Probably the best way to start learning a programming language is by writing a program. Therefore, here is our first ...
-
Please do this exercise at the command line instead of using NetBeans. This is to learn the concept of packaging without the help of NetBean...
-
Setting Properties At Run-Time (Continue) Not all the properties get text values. For example, Visible property can be "True" or ...
-
A program is usually not limited to a linear sequence of instructions. During its process it may bifurcate, repeat code or take decisions. F...
-
Learning about Properties Every component (form is component for example) has properties, that determine its look and its functioning. Prope... -
Getting Started Note that all the images in this tutorial taken from Visual Basic version 6.0. If you using other version of Visual Basic, t... -
Setting Properties At Run-Time By now you know how to set a component property before running your program (=at "Design Time"), No...
-
Tutorials Chapter 1 : What is SQL Server? Chapter 2 : Compare SQL Server and MS Access Chapter 3 : What is MSDE ? Chapter 4 : SQL Server Edi...
No comments:
Post a Comment