Enterprise DVD SQL Server 2005 Enterprise Edition (support for very large enterprises)
Standard Edition CD SQL Server 2005 Edition (for small and midsize businesses)
Development DVD SQL Server 2005 Developer Edition (developer for 32-bit and 64-bit)
SQL2005 is divided into five versions, as listed below,
1.Enterprise (Enterprise Edition),
2.Development (development version),
3.Workgroup, (Working Group edition)
4.Standard, (Standard Edition)
5.Express. (Well, estimate and call it a starter version)
Which version should we use in these editions?
This is one of the most frequently asked questions of many beginners SQL2005.
I simply compare enterprise, development and Express three versions: function, Enterprise Edition and development version of the function is identical. The difference between the two, in addition to licensing differences, the main difference is:
The enterprise version of the database engine can only be installed on Win2003server (or other servers).
If you want to install on the WindowsXP Pro system, you should install the Sql2005development version (Dev version).
Note: Someone asked, what is "Database Engine". Well, the database engine is the core of SQL2005 and is the most important database management function module. Without it, it is not a database management system.
Many people download the sql2005express version as it is free and can be downloaded directly from the Microsoft website. However, in addition to supporting less memory, the main thing is
It lacks the equivalent of "Enterprise Manager" and "Query Analyzer" under SQL2000.
Note: "Enterprise Manager" and "Query Analyzer" under SQL2000 are already in SQL2005, called Management Studio.
So if you are a beginner and if you just want to learn at home, if your environment is windowsxp Pro, then you should choose sql2005development (dev) instead of Sql2005enterprise (Enterprise Edition) or sql2005express (simple version).
All versions of SQL Server 2005 can be used in a production environment, except for SQL Server 2005 Developer Edition and SQL Server 2005 Evaluation Edition. The following paragraphs describe multiple versions of SQL Server 2005.
Enterprise Edition achieves the level of performance required to support ultra-large enterprises for online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. Enterprise Edition's comprehensive business intelligence and analytics capabilities and its high availability features, such as failover clustering, enable it to handle most business-critical corporate workloads. Enterprise Edition is the most comprehensive version of SQL Server and is the ideal choice for ultra-large enterprises to meet the most complex requirements.
SQL Server 2005 also introduces a 180-day Evaluation Edition for 32-bit or 64-bit platforms. SQL Server Evaluation Edition supports the same set of features as SQL Server 2005 Enterprise Edition. SQL Server Evaluation Edition can be upgraded according to production needs.
SQL Server 2005 Standard Edition is a data management and analytics platform for small and midsize businesses. It includes the basic functionality required for e-commerce, data warehousing, and business flow solutions. Standard Edition's integrated business intelligence and high availability capabilities provide organizations with the basic capabilities they need to support their operations. SQL Server 2005 Standard Edition is the ideal choice for small and midsize businesses that require a comprehensive data management and analytics platform.
SQL Server 2005 Workgroup Edition is the ideal data management solution for small businesses that need to have no limits on size and number of users. SQL Server 2005 Workgroup Edition can be used as a front-end WEB server or as a department or branch office operation. It includes core database functionality for the SQL Server product family and can be easily upgraded to SQL Server 2005 standard Edition or SQL Server 2005 Enterprise Edition. The SQL Server 2005 Workgroup Edition is the ideal entry-level database for reliable, powerful, and manageable features.
SQL Server 2005 Developer Edition allows developers to generate any type of application at the top of SQL Server. The application includes all the features of SQL Server 2005 Enterprise Edition, but is licensed as a development and test system and not as a production server. SQL Server 2005 Developer Edition is an ideal choice for independent software vendors (ISVs), consultants, system integrators, solution vendors, and enterprise developers who build and test applications. SQL Server 2005 Developer Edition can be upgraded according to production needs.
SQL Server Express database platform is based on Microsoft SQL Server 2005. It can also replace Microsoft Desktop Engine (MSDE). Integrated with Microsoft Visual Studio 2005, SQL Server Express simplifies the development of rich, secure, and rapidly deployable data-driven applications.
SQL Server Express is free, can be redistributed (subject to protocol), and can act as a client database as well as a base server database. SQL Server Express is an ideal choice for ISVs, server users, non-professional developers, Web application developers, site hosts, and programming enthusiasts to create client applications for independent software vendors. If you need more advanced database features, you can seamlessly upgrade SQL Server Express to a more complex version of SQL Server.
SQL Server Express also provides additional components that are available as part of Microsoft SQL Server 2005 Express Edition (SQL Server Express) with Advanced services. In addition to the features of SQL Server Express, SQL Server Express with Advanced Services also includes the following features:
SQL Server Mobile is a simple database that extends enterprise data management capabilities to small devices. SQL Server Mobile is capable of replicating data from Microsoft SQL Server 2005 and Microsoft SQL Server 2000, and allows users to maintain a mobile data store that synchronizes with the primary database. SQL Server Mobile is the only version of SQL Server that provides relational database management functionality for smart devices.
SQL Server 2005 Runtime Edition is available with the Microsoft ISV royalty program. Depending on the end-User License Agreement of SQL Server 2005 Runtime Edition, if a user does not run any other application using SQL Server code or uses SQL Server code in any other context, an independent software vendor (ISV) may SQL Server code is embedded in the solution that they provide. For more information about SQL Server Runtime Edition, see the article in the Microsoft Knowledge Base
The Enterprise version cannot be installed on XP,
The express version can only be accessed locally and cannot be accessed remotely.
Express version connection requires writing ***\sqlexpress in the connection string
Developer version can be accessed remotely, remember to enable TCP/IP connection, and to set up a firewall
The main features of sql2008 include:
A reliable and scalable platform with high availability, master Data Services support data reconciliation across heterogeneous systems, streaminsight enables processing of large-scale complex events, and supports large applications with up to 256 logical processors.
Improve the efficiency of your IT and developers by centralizing management of multiple database applications, instances, or servers, accelerate application development and deployment, and improve support for virtualization and live migration through Hyper-V in Windows Server R2.
Managed self-service BI (self-service business intelligence) gives enterprise users the ability to create and share powerful business intelligence (BI) scenarios without IT support, while also using Excel and The latest PowerPivot technology in SharePoint monitors and manages end-user-generated BI scenarios.
Customers with Software Assurance (Software Assurance) can upgrade to SQL Server R2 and use their new features without any additional licensing fees.
Microsoft SQL Server R2 official Chinese version (32-bit Simplified Chinese version)
File Size: 1.46GB
Microsoft SQL Server R2 official Chinese version (64-bit Simplified Chinese version)
File Size: 1.64GB
Data Center Edition:
PTTFM-X467G-P7RH2-3Q6CG-4DMYB (available, verified)
DDT3B-8W62X-P9JD6-8MX7M-HWK38 (pending test)
MC46H-JQR3C-2JRHY-XYRKY-QWPVM (available, verified)
FTMGC-B2J97-PJ4QG-V84YB-MTXX8 (pending test)
R88PF-GMCFT-KM2KR-4R7GB-43K4B (available, verified)
Gyf3t-h2v88-grpph-hwrjp-qrtyb (pending test)
B68Q6-KK2R7-89WGB-6Q9KR-QHFDW (pending test)
Cxtft-74v4y-9d48t-2dmfw-tx7cy (pending test)
Working Group version:
Xq4cb-vk9p3-4wyyh-4hqx3-k2r6q (pending test)
FP4P7-YKG22-WGRVK-MKGMX-V9MTM (pending test)
Supported Operating systems: Windows 7, Windows Server 2003, Windows Server, Windows Server R2, Windows Vista, Windows XP
Note: This activation version is for testing purposes only, such as for commercial production environments, with all consequences at your own risk.
sql2005 Database Daquan