The SQL Server, Express Edition version is a free version of SQL Sever, which is included in several Microsoft products. This article describes 3 scenarios for using the SQL Server Edition Express.
The SQL Server, Express Edition version is a free version of SQL Sever, which is included in several Microsoft products. However, this version of the product bundled with Visual Studio 2005 lacks a critical build: Management Studio (equivalent to Enterprise Manager).
Microsoft offers a solution: Allow users to download the extended version of Express Edition. On the download page, you can download the 64-bit version. All two versions contain components equivalent to Management Studio.
However, express Edition are not required on many occasions. So you may be hesitant about whether you need this product. Below I give 3 kinds of occasions using Express Edition.
Occasion 1: Your employer is selling database applications and will need to publish a free download of the experience version. You cannot expect the expected client program to have a ready-made SQL Sever. This is the biggest reason for the need for Express Edition copies. You can record the CD containing the Express Edition experience software and release it for free.
Occasion 2: If your software has a maximum of 12 users, SQL Sever will overcharge your application, and the alternative is to use back-end access or MySQL. Microsoft obviously does not want this. The free version of the software, which is subject to built-in management restrictions, is wary of large companies thinking they can get these features for free.
In both cases, the Standard Edition lacks management Studio. This is the reason why your client program needs this tool.
Occasion 3: You are a student who is interested in database development, with Express Edition version free software can use and learn SQL Server 2005 completely.
If you find Express Edition useful, be sure to download the extended version.