none
請問MS SQL 2003 與MS SQL 2005 的功能比較表嗎?? RRS feed

  • 問題

  • 不好意思~~可以給我下列版本之間功能的比較表

    MS SQL 2003 standrad,enterpeise,personal版本

    MS SQL 2005 Express,Workgroup,Standard,Enterprise,Comments 版本



    2008年3月14日 上午 03:33

解答

  • SQL 沒有2003喔!!

     

    SQL 2000升級至2005有很多資訊 請參考!!

    http://www.microsoft.com/taiwan/sql/solutions/upgrade/default.mspx

     

    2005各版本比較

    http://www.microsoft.com/taiwan/sql/prodinfo/features/compare-features.mspx

     

     

    希望對您有幫助

    2008年3月14日 上午 06:03
  • 我想您所指的 MS SQL 2003 是指 SQL Server 2000,這三種版本的比較如下:

     

    Edition


    Feature

    Enterprise (64-bit) Edition Enterprise Edition Standard Edition Personal Edition

    Overview

    Enterprise Edition (64-bit) provide the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 (64-bit) provides a high level of reliability and availability for your mission-critical applications.

    Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition.

    There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident:

    Scalability

    Availability/uptime

    Performance

    Advanced analysis

    Standard edition is an affordable option for small and medium-sized organizations. It includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition.

    Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:

    Data Transformation Services (DTS)

    Replication (snapshot, transactional, and merge)

    Full-Text Search

    English Query

    Stored procedure development and debugging tools

    SQL Profiling and performance analysis tools

    Personal Edition is ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer. This edition is functionally equivalent to Standard Edition, with the following exceptions:

    It includes a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently.

    It cannot act as a transactional replication publisher (subscriber only).

    Operating Systems

    Windows Server 2003 Enterprise Edition
    Windows Server 2003 Datacenter Edition

    Windows Server 2003, Standard Edition*
    Windows Server 2003, Enterprise Edition*
    Windows Server 2003, Datacenter Edition*
    Windows 2000 Server
    Windows 2000 Advanced Server
    Windows 2000 Datacenter Server

    Windows NT Server 4.0
    Windows NTServer 4.0 Enterprise Edition

    Windows Server 2003, Standard Edition*
    Windows Server 2003, Enterprise Edition*
    Windows Server 2003, Datacenter Edition*
    Windows 2000 Server
    Windows 2000 Advanced Server
    Windows 2000 Datacenter Server

    Windows NT Server 4.0
    Windows NT Server 4.0 Enterprise Edition

    Windows Server 2003, Standard Edition*
    Windows Server 2003, Enterprise Edition*
    Windows Server 2003, Datacenter Edition*
    Windows XP Professional
    Windows 2000 Professional
    Windows 2000 Server
    Windows 2000 Advanced Server
    Windows 2000 Datacenter Server
    Windows NT Workstation
    Windows NT Server 4.0
    Windows NT Server 4.0 Enterprise Edition

    Scalability

    Up to 64 Processors
    Up to 512 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Up to 32 Processors
    Up to 64 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Up to 4 Processors
    Up to 2 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Up to 2 Processors
    Up to 2 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Purchasing and Licensing

    How To Buy

    How To Buy

    How To Buy

    Not available separately.
    Personal Edition is included with:

    SQL Server Enterprise Edition

    SQL Server Standard Edition

    * Requires SQL Server 2000 Service Pack 3 or later to be applied.




    而 SQL 2005 Express,Workgroup,Standard,Enterprise,Comments 樓上的已經連結應該已經說明了一切。

     

    2008年3月14日 上午 11:45
    版主

所有回覆

  • SQL 沒有2003喔!!

     

    SQL 2000升級至2005有很多資訊 請參考!!

    http://www.microsoft.com/taiwan/sql/solutions/upgrade/default.mspx

     

    2005各版本比較

    http://www.microsoft.com/taiwan/sql/prodinfo/features/compare-features.mspx

     

     

    希望對您有幫助

    2008年3月14日 上午 06:03
  • 我想您所指的 MS SQL 2003 是指 SQL Server 2000,這三種版本的比較如下:

     

    Edition


    Feature

    Enterprise (64-bit) Edition Enterprise Edition Standard Edition Personal Edition

    Overview

    Enterprise Edition (64-bit) provide the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 (64-bit) provides a high level of reliability and availability for your mission-critical applications.

    Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition.

    There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident:

    Scalability

    Availability/uptime

    Performance

    Advanced analysis

    Standard edition is an affordable option for small and medium-sized organizations. It includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition.

    Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:

    Data Transformation Services (DTS)

    Replication (snapshot, transactional, and merge)

    Full-Text Search

    English Query

    Stored procedure development and debugging tools

    SQL Profiling and performance analysis tools

    Personal Edition is ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer. This edition is functionally equivalent to Standard Edition, with the following exceptions:

    It includes a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently.

    It cannot act as a transactional replication publisher (subscriber only).

    Operating Systems

    Windows Server 2003 Enterprise Edition
    Windows Server 2003 Datacenter Edition

    Windows Server 2003, Standard Edition*
    Windows Server 2003, Enterprise Edition*
    Windows Server 2003, Datacenter Edition*
    Windows 2000 Server
    Windows 2000 Advanced Server
    Windows 2000 Datacenter Server

    Windows NT Server 4.0
    Windows NTServer 4.0 Enterprise Edition

    Windows Server 2003, Standard Edition*
    Windows Server 2003, Enterprise Edition*
    Windows Server 2003, Datacenter Edition*
    Windows 2000 Server
    Windows 2000 Advanced Server
    Windows 2000 Datacenter Server

    Windows NT Server 4.0
    Windows NT Server 4.0 Enterprise Edition

    Windows Server 2003, Standard Edition*
    Windows Server 2003, Enterprise Edition*
    Windows Server 2003, Datacenter Edition*
    Windows XP Professional
    Windows 2000 Professional
    Windows 2000 Server
    Windows 2000 Advanced Server
    Windows 2000 Datacenter Server
    Windows NT Workstation
    Windows NT Server 4.0
    Windows NT Server 4.0 Enterprise Edition

    Scalability

    Up to 64 Processors
    Up to 512 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Up to 32 Processors
    Up to 64 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Up to 4 Processors
    Up to 2 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Up to 2 Processors
    Up to 2 GB of Memory
    Maximum Database Size 1,048,516 terabytes

    Purchasing and Licensing

    How To Buy

    How To Buy

    How To Buy

    Not available separately.
    Personal Edition is included with:

    SQL Server Enterprise Edition

    SQL Server Standard Edition

    * Requires SQL Server 2000 Service Pack 3 or later to be applied.




    而 SQL 2005 Express,Workgroup,Standard,Enterprise,Comments 樓上的已經連結應該已經說明了一切。

     

    2008年3月14日 上午 11:45
    版主
  • 非常感謝二位的回答

    筆誤MS SQL 2003 應為 MS SQL 2000才對

    以上的文章,非常有幫助,謝謝
    2008年3月17日 上午 02:42