Differences between versions released by SQL _server

Differences between versions released by SQL _server

By ben988211: versions --------------------------------------------------------------- In 1988, Microsoft and sysbase and Ashton-tate cooperated to port SQL Server to OS/2. 1989 Microsoft, sysbase, and Ashton-tate released SQL Server 1 for OS/2 1990 released SQL server that supports Windows 3 clients 1992 Microsoft and Sybase move SQL Server to Windows NT 1993 Microsoft and Sybase release SQL server4.2 on Windows NT 1995 Microsoft releases SQL server6.0 1996 SQL Server7.0 Standard Edition 1997 SQL Server Enterprise Edition 1998 Microsoft releases SQL Server 2000 Microsoft releases SQL Server ------------------------------------------------------------ Differences between supplemental versions: SQL Server version or component Operating System Requirements Enterprise Edition Microsoft Windows NT Server 4.0, Microsoft Windows NT Server 4.0 Enterprise Edition, Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 data center server. Note that some features of SQL Server 2000 require Microsoft Windows 2000 Server (any version ). Standard Edition Microsoft Windows NT Server 4.0, Windows 2000 Server, Microsoft Windows NT Server Enterprise Edition, Windows 2000 Advanced Server, and Windows 2000 data center server. Personal Edition Microsoft Windows ME, Windows 98, Windows NT Workstation 4.0, Windows 2000 Professional, Microsoft Windows NT Server 4.0, Windows 2000 Server, and all more advanced Windows operating systems. Development version Microsoft Windows NT Workstation 4.0, Windows 2000 Professional, and all other Windows NT and Windows 2000 operating systems. Client-only tools Microsoft Windows NT 4.0, Windows 2000 (all versions), Windows ME, and Windows 98. Connect only Microsoft Windows NT 4.0, Windows 2000 (all versions), Windows ME, Windows 98, and Windows 95 Maximum physical memory size supported by SQL Server 2000 The following table lists the maximum physical memory or RAM supported by data engines in SQL Server 2000. Operating System Enterprise Edition Personal Edition development edition Desktop Engine SQL Server ce Enterprise Evaluation Edition Windows 2000 datacenter 64 GB 2 GB 2 GB 64 GB 2 GB missing 64 GB Windows 2000 Advanced Server 8 GB 2 GB 2 GB 8 GB 2 GB missing 8 GB Windows 2000 Server 4 GB 2 GB 2 GB 4 GB 2 GB missing 4 GB Windows 2000 Professional: 2 GB, 2 GB, 2 GB Windows NT 4.0 Server Enterprise 3 GB 2 GB 2 GB 3 GB 2 GB missing 3 GB Windows NT 4.0 Server 2 GB 2 GB 2 GB 2 GB 2 GB missing 2 GB Windows NT 4.0 Workstation: 2 GB, 2 GB, 2 GB ------------------------------------------------------------ Supplement the data service Directions applicable to each version: SQL Server 2000 Enterprise Edition Used as a production database server. Supports all available functions of SQL Server 2000, and supports scaling based on the performance levels required by the largest web site and enterprise online transaction processing (OLTP) and data warehouse systems. SQL Server 2000 Standard Edition Used as a database server of a small working group or department. SQL Server 2000 Personal Edition For mobile users, these users are sometimes disconnected from the network, but the applications running Program SQL Server data storage is required. The Personal Edition is also used to run independent applications that require local SQL server data storage on the client computer. SQL Server 2000 Development Edition For programmers to develop applications that use SQL Server 2000 as data storage. Although the development edition supports all the features of the Enterprise Edition, developers can write and test applications that can use these features, the development edition can only be used as a development and testing system, cannot be used as a production server. SQL Server 2000 for Windows CE Use Microsoft & reg; SQL Server 2000 Windows & reg; Ce (SQL Server CE) to store data on Windows CE devices. You can use any version of SQL Server 2000 to copy data so that Windows CE data can be synchronized with the master database. SQL Server 2000 Enterprise Evaluation Edition A complete version of the free download function from the web. It is only used to evaluate the SQL server function. The version will stop running after 120 days of download. The above content from: http://www.txcms.org/show.php? Id = 37024 Versions and components of SQL Server 2005  All versions of SQL Server 2005 can be used in the production environment, except SQL Server 2005 Developer Edition and SQL Server 2005 evaluation edition. The following section describes multiple versions of SQL Server 2005. SQL Server 2005 Enterprise Edition (32-bit and 64-bit) Enterprise Edition delivers the performance required to support ultra-large enterprises for online transaction processing (OLTP), highly complex data analysis, data warehouse systems, and websites. Enterprise Edition's comprehensive business intelligence and analysis capabilities and high availability features (such as failover clusters) enable it to handle the workloads of most critical businesses. Enterprise Edition is the most comprehensive SQL Server version. It is an ideal choice for super-large enterprises and can meet the most complex requirements. SQL Server 2005 evaluation edition (32-bit and 64-bit) SQL Server 2005 also introduces the 180-day evaluation edition for 32-bit or 64-bit platforms. SQL Server evaluation edition supports the same feature set as SQL Server 2005 Enterprise Edition. You can upgrade SQL Server evaluation edition according to production needs. SQL Server 2005 Standard Edition (32-bit and 64-bit) SQL Server 2005 Standard Edition is a data management and analysis platform suitable for small and medium-sized enterprises. It includes the basic functions required for e-commerce, data warehouse, and Business Flow Solutions. The integrated business intelligence and high availability functions of Standard Edition provide enterprises with the basic functions required to support their operations. SQL Server 2005 Standard Edition is an ideal choice for small and medium enterprises that require comprehensive data management and analysis platforms. SQL Server 2005 workgroup edition (32-bit only) SQL Server 2005 workgroup edition is an ideal data management solution for small businesses that require no limit on the 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. It includes core database functions of the SQL Server product series and can be easily upgraded to SQL Server 2005 Standard Edition or SQL Server 2005 Enterprise Edition. SQL Server 2005 workgroup edition is an ideal entry-level database with reliable, powerful, and easy to manage features. SQL Server 2005 Developer Edition (32-bit and 64-bit) SQL Server 2005 Developer Edition allows developers to generate any type of applications at the top of SQL Server. This application includes all functions of SQL Server 2005 Enterprise Edition, but is licensed to be used as a development and testing system without being used as a production server. SQL Server 2005 Developer Edition is an ideal choice for independent software vendors (ISVs), consultants, system integrators, solution providers, and enterprise developers who generate and test applications. You can upgrade SQL Server 2005 Developer Edition according to production needs. SQL Server 2005 express edition (32-bit only) the 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 process of data-driven applications with rich features, secure storage, and Fast deployment. SQL Server Express is free of charge and can be redistributed (subject to protocols). It can also act as a client database and a basic Server database. SQL Server Express is an ideal choice for programmers who are independent software vendors such as isV, server users, non-professional developers, web application developers, website hosts, and client application creation. If you need more advanced database functions, You can seamlessly upgrade SQL Server express to a more complex SQL Server version. SQL Server express also provides additional components that are provided as part of Microsoft SQL Server 2005 express edition (SQL Server express) with advanced services. In addition to SQL Server Express, SQL Server express with advanced services also provides the following features: SQL Server Management studio Express (ssmse), a subset of SQL Server Management studio. supports full-text directories. you can view reports through reporting services. SQL Server 2005 mobile edition (32-bit only) SQL Server mobile is a simplified database that extends enterprise data management to small devices. SQL Server mobile can copy data from Microsoft SQL Server 2005 and Microsoft SQL Server 2000, and allows users to maintain mobile data storage synchronized with the primary database. SQL Server Mobile is the only SQL Server version that provides Relational Database Management for smart devices. SQL Server 2005 runtime edition (32-bit and 64-bit) SQL Server 2005 runtime edition is provided with Microsoft isV royalty program. According to the End User License Agreement of SQL Server 2005 runtime edition, if you do not use SQL ServerCodeWhen running any other application or using SQL Server code in any other context, independent software vendors (ISVs) may embed SQL server code into their solutions. For more information about SQL Server Runtime edition, seeArticleHow to obtain the SQL Server Runtime license (http://support.microsoft.com/kb/917400 ). Use SQL Server 2005 on an Internet Server SQL Server 2005 client tools are usually installed on Internet servers (such as servers running Internet Information Services (IIS. Client tools include client connection components used by applications connected to SQL Server instances. Note: Although you can install an SQL server instance on a computer running IIS, this method is generally used only for a small website with a single server. Most websites install their intermediate IIS system on one server or server cluster, and install the database on another server or server consortium. SQL Server 2005 reporting services are usually installed on the intermediate layer. For more information about reporting services software requirements, see hardware and software requirements for installing SQL Server 2005. For more information about the consortium, see the consortium Database Server topic in SQL Server 2005 books online.     Use SQL Server 2005 in client/server applications You can only install the SQL Server 2005 client component on the computer that runs the Client/Server application that directly connects to the SQL server instance. If you want to manage SQL Server instances on the database server or develop SQL server applications, installing client components is also a good choice. Client component options install the following SQL Server Functions: Command Prompt tools, reporting services tools, connection components, programming models, management tools, development tools, books online, sample databases, and sample applications. For more information, see How To Install SQL Server 2005 (installer ). Components and other details, see: http://msdn2.microsoft.com/zh-cn/library/ms144275.aspx