Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Difference between SQL2k Enterprise & Developer editions?

    What are the Differences between those two SQL versions
    i mean except that with in the developer edition only 1 user can login

    on what version is it better to develop ?
    does the developer ver. include something that the entprise does not ? (or vice versa)
    (say in theory i can choose on which version to work ;-))

    thanx, max.

  2. #2
    Join Date
    Oct 2003
    Posts
    12
    Directly from Microsoft's site:

    Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment. It is the ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.

    It is the only edition of SQL Server 2000 that gives the licensee the right to download and install SQL Server 2000 Windows CE Edition (SQL Server CE). The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition.

  3. #3
    Join Date
    Oct 2003
    Location
    Pune, India
    Posts
    14
    SQL Server 2000 has the following editions:

    Personal Edition
    Standard Edition
    Enterprise Edition
    Developer Edition
    Desktop Engine
    SQL Server CE
    Evaluation Edition

    Personal Edition can work on the Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and on the all editions of Windows 2000. This edition is related to SQL Server 7.0 Desktop Edition.

    This edition has some restrictions:

    maximum 2 CPU
    no Distributed Partitioned Views
    no Log Shipping
    no Parallel DBCC
    no Parallel index creation
    no Failover clustering
    no publishing for transaction replication
    maximum 2Gb RAM

    Standard Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.

    This edition has the following restrictions:

    maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)
    no Distributed Partitioned Views
    no Log Shipping
    no Parallel index creation
    no Failover clustering
    maximum 2Gb RAM

    Enterprise Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.

    This edition can use:

    up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
    up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
    Distributed Partitioned Views
    Log Shipping
    Parallel index creation
    Failover clustering
    The Developer Edition can be used by developers to create and debug stored procedures and triggers. This edition comes with its own compact disc and can be upgraded to SQL Server 2000 Enterprise Edition.

    The Desktop Engine has no graphical user interface and is related to the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can use maximum 2 CPU.

    The SQL Server CE edition can work only on the Microsoft Windows CE, so it has all restrictions of this operation system (can use only 1 CPU, no Parallel index creation, no Full-Text Search and so on).

    The Evaluation Edition can be used only for the test purposes to learn more about the new features and enhancements and should be uninstalled after a 120-day evaluation period.
    Thanks & Regards,
    Dipayan Sarkar
    (dipayan@covisible.com)
    (CoVisible Solutions - A Knowledge Management Software company)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •