Resumen Versiones de SQL Server 7 y MSDE

Mensaje enviado por AVernieri@juncalnet.com.ar


Hola!

Te paso parte de un artículo de MSDN... Lamentablemente lo tengo sólo en Inglés...

Lo podés encontrar completo en la MSDN, en el path...
MSDN
     Technical Articles
          Database and Messaging Services
               Microsoft SQL Server
                    Deploying Value-Added Business Solutions...
                         Sql Server 7.0 Developer's Overview
Espero que te sirva
Saludos
Alberto


Scalable Database Platform
SQL Server 7.0 and MSDE 1.0 support all 32-bit Microsoft Windows platforms (except Win32s®) with a single, compatible code base that dynamically adapts to the hardware capabilities available on the system on which it is installed. This means that developers can write a single set of application source code and run it on a database that scales from a Windows 98 desktop, to a Windows NT Server, to a Windows NT Server Enterprise Edition cluster.
Database files are also compatible across all SQL Server 7.0 editions. SQL Server 7.0 is available in several different editions that will be briefly introduced here.

SQL Server Standard, Developer, and Enterprise Editions
SQL Server 7.0, Standard Edition is designed for installation on servers running Windows NT Server, and is limited to 4 CPUs and 32-bit memory addressing. A special variant of SQL Server 7.0, Standard Edition, called SQL Server Developer's Edition, ships with Microsoft® Visual Studio® and is licensed for application development usage with Visual Studio only.

SQL Server 7.0, Enterprise Edition is designed for installation on servers running Windows NT Server, Enterprise Edition, supports 8 CPUs and 64-bit memory addressing, and supports Active/Active clustering for environments requiring advanced fault tolerance.

SQL Server Desktop Edition
SQL Server 7.0, Desktop Edition ships on the same compact disc with SQL Server Standard, Developer, and Enterprise editions. It is not available as a stand-alone product. It is designed for installation on workstations running Windows 95, Windows 98, or Windows NT Workstation. SQL Server 7.0
Desktop Edition has no disk space limitations, is limited to two processors and five concurrent queries, and ships with a full complement of graphical administration tools. A SQL Server Client Access License is required for each workstation on which a copy of SQL Server 7.0, Desktop Edition is installed.

SQL Server Small Business Server Edition
SQL Server 7.0, Small Business Server Edition ships on the same compact disk with Microsoft Small Business Server version 4.5. It is not available as a stand-alone product. It is designed for installation on servers running Small Business Server 4.5. SQL Server 7.0 Small Business Server Edition is limited to 10 GB of storage per database, a single processor, fifty concurrent queries, and ships with a full complement of graphical administration tools.

Microsoft Data Engine
The Microsoft Data Engine (MSDE) is a royalty free, redistributable database engine that is fully compatible with SQL Server 7.0. MSDE is designed to run as an embedded database for custom applications that require a local database engine on Windows 95, Windows 98, or Windows NT Workstation. MSDE is limited to 2 GB of storage per database, a single processor, and five concurrent queries.

MSDE is an attractive alternative to using the Microsoft Jet database, and is designed primarily to provide a low cost option for developers who need a database server that can be easily distributed and installed with a value-added business solution. Because it is fully compatible with other editions of SQL Server, developers can easily target both SQL Server and MSDE with the same core code base. This provides a seamless upgrade path from MSDE to SQL Server if the application grows beyond the storage and scalability limits of MSDE.

MSDE ships with Microsoft Office 2000 Developer Edition, and Microsoft Visual Studio. MSDE is not available as a stand-alone product. MSDE requires a SQL Server Client Access License to participate in replication with SQL Server Standard or Enterprise editions. Developers must obtain a Visual Studio or Microsoft Office 2000 Developers Edition license in order to redistribute MSDE with a custom application.

A special release of MSDE 1.0 ships with Microsoft Office 2000 for use with Microsoft Access as an alternative to the Microsoft Jet database, and is not licensed for redistribution. This document refers to this version of MSDE as the "MSDE 1.0 Office 2000 Release." It differs from MSDE 1.0 in the following ways:

Either Microsoft Access 2000 or the Office 2000 Server Extensions must be installed in order to install MSDE 1.0 Office 2000 Release.


A full complement of graphical administration tools is included. These tools are required by Microsoft Access 2000 to perform database administration.


Installation is performed by way of Setupsql.Exe, not by way of the PackageForTheWeb installation executable.



Resumen Resumen

Visual Basic Página de Visual Basic

Página principal Página principal

www.jrubi.com