MSDE

Last updated

Microsoft SQL Server Data Engine (MSDE, also Microsoft Data Engine or Microsoft Desktop Engine) is a relational database management system developed by Microsoft. It is a scaled-down version of Microsoft SQL Server 7.0 or 2000 which is free for non-commercial use as well as certain limited commercial use. It was introduced at Microsoft TechEd in May 1999, [1] and was included as part of Microsoft Office 2000 Developer Edition. Its successor, SQL Server Express was released in November 2005. [2] Vendor support of MSDE ended on April 8, 2008. [3]

Contents

Overview

Microsoft Desktop Engine

MSDE was initially designed by (then) Microsoft Program Manager Jeff Alger and later implemented by Peter Byrne (core), Ronald Martinsen (core/setup), and Mike Maringas (setup). Alger and Martinsen are the co-inventors who hold the patent. [4]

The initial release of MSDE is called the "Microsoft Desktop Engine", which is based on SQL Server 7.0 and was positioned as an alternative to using the Jet Database Engine used by Microsoft Access with a focus on its ability to operate as a client–server application instead of requiring direct access to the file system which the Jet database resided on. [5] Microsoft Access, the company's most popular database tool at the time, was expanded for its Office 2000 release to incorporate using Microsoft Desktop Engine as its back-end data store. This design was promoted by Microsoft as a solution for small workgroups that may eventually grow to require the full SQL Server product. [6] This initial release of MSDE also included the Data Transformation Services Wizard, which provided the ability to use OLE DB and ODBC data sources to transfer data between SQL Server 7.0 and MSDE. Supported operating systems at the time of its release included Windows 95, Windows 98, and Windows NT 4.0 Service Pack 4, and was available for both x86 and Alpha architectures. [7]

Microsoft Data Engine can be found in Microsoft Access 2000 and other Microsoft products. [8]

MSDE toolkit for Visual Studio 6.0 can be found in October 2000 MSDN DVD Office Test Platform and Development Tools, English Pack as MSDE for Visual Studio. [9] , or in October 2000 MSDN CD Office Test Platform and Development Tools (English Pack, European Pack I, Japanese Pack, Latin American pack). [10]

Microsoft SQL Server Data Engine

It is based on SQL Server 2000. System requirement was changed to Windows 98. [11] [12]

MSDE could be distributed with commercial products by registering with Microsoft — in most cases this distribution is also free of charge.[ citation needed ] SQL Server's server licence includes right to distribute MSDE. [13]

MSDE 2000 includes following resource kits: MSDE 2000 Deployment Resource Kit, MSDE 2000 Web Resource Kit. [14]

MSDE 2000 is also found in various products, such as Microsoft Office XP (Professional, Developer), Visual Studio .NET 2002-2003. [15]

Features

Compared with the full server editions of SQL Server 7.0 and 2000, MSDE has some restrictions: a limit of 2 GB databases, and has a workload governor which reduces its speed when eight or more concurrent workloads are running. [16] Microsoft has also stated that MSDE is not supported in Windows NT 6.0 operating systems such as Windows Vista. [17] No graphical user interface management tools were released for MSDE, but SQL Server 2000's Enterprise Manager (as well as later versions such as SQL Server Management Studio) can be used to connect to it. [18]

See also

Related Research Articles

<span class="mw-page-title-main">Microsoft Access</span> Database manager part of the Microsoft Office package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

<span class="mw-page-title-main">Windows 2000</span> Personal computer operating system by Microsoft released in 2000

Windows 2000 is a major release of the Windows NT operating system developed by Microsoft and oriented towards businesses. It was the direct successor to Windows NT 4.0, and was released to manufacturing on December 15, 1999, and was officially released to retail on February 17, 2000. It was Microsoft's business operating system until the introduction of Windows XP Professional in 2001.

<span class="mw-page-title-main">Windows Script Host</span> Automation Technology for Windows

The Microsoft Windows Script Host (WSH) is an automation technology for Microsoft Windows operating systems that provides scripting abilities comparable to batch files, but with a wider range of supported features. This tool was first provided on Windows 95 after Build 950a on the installation discs as an optional installation configurable and installable by means of the Control Panel, and then a standard component of Windows 98 and subsequent and Windows NT 4.0 Build 1381 and by means of Service Pack 4. The WSH is also a means of automation for Internet Explorer via the installed WSH engines from IE Version 3.0 onwards; at this time VBScript became means of automation for Microsoft Outlook 97. The WSH is also an optional install provided with a VBScript and JScript engine for Windows CE 3.0 and following and some third-party engines including Rexx and other forms of Basic are also available.

<span class="mw-page-title-main">Microsoft Visual Studio Express</span> Integrated development environment

Microsoft Visual Studio Express is a set of integrated development environments (IDEs) that Microsoft developed and released free of charge. They are function-limited version of the non-free Visual Studio and require mandatory registration. Express editions started with Visual Studio 2005.

<span class="mw-page-title-main">Microsoft Project</span> Project management software

Microsoft Project is a project management software product, developed and sold by Microsoft. It is designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.

The Access Database Engine is a database engine on which several Microsoft products have been built. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database.

Microsoft BizTalk Server is an inter-organizational middleware system (IOMS) that automates business processes through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.

<span class="mw-page-title-main">Microsoft Data Access Components</span> Framework

Microsoft Data Access Components is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store. Its components include: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC). There have been several deprecated components as well, such as the Jet Database Engine, MSDASQL, and Remote Data Services (RDS). Some components have also become obsolete, such as the former Data Access Objects API and Remote Data Objects.

An IFilter is a plugin that allows Microsoft's search engines to index various file formats so that they become searchable. Without an appropriate IFilter, contents of a file cannot be parsed and indexed by the search engine.

Microsoft XML Core Services (MSXML) are set of services that allow applications written in JScript, VBScript, and Microsoft development tools to build Windows-native XML-based applications. It supports XML 1.0, DOM, SAX, an XSLT 1.0 processor, XML schema support including XSD and XDR, as well as other XML-related technologies.

Microsoft SQL Server Express is a version of Microsoft's SQL Server relational database management system that is free to download, distribute and use. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The "Express" branding has been used since the release of SQL Server 2005.

Resource Kit is a term used by Microsoft for a set of software resources and documentation released for their software products, but which is not part of that product. Resource kits offer supplementary resources such as technical guidance, compatibility and troubleshooting information, management, support, maintenance and deployment guides and multipurpose useful administrative utilities, which are available separately.

Microsoft SQL Server Compact is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.

<span class="mw-page-title-main">Visual Studio</span> Code editor and IDE

Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs, as well as websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

<span class="mw-page-title-main">Microsoft Azure SQL Database</span> Managed cloud database

Microsoft Azure SQL Database is a managed cloud database (PaaS) provided as part of Microsoft Azure.

<span class="mw-page-title-main">Windows Search</span> Desktop search platform by Microsoft

Windows Search is a content index desktop search platform by Microsoft introduced in Windows Vista as a replacement for both the previous Indexing Service of Windows 2000 and the optional MSN Desktop Search for Windows XP and Windows Server 2003, designed to facilitate local and remote queries for files and non-file items in compatible applications including Windows Explorer. It was developed after the postponement of WinFS and introduced to Windows constituents originally touted as benefits of that platform.

<span class="mw-page-title-main">.NET Framework version history</span> Wikimedia list article

Microsoft started development on the .NET Framework in the late 1990s originally under the name of Next Generation Windows Services (NGWS). By late 2001 the first beta versions of .NET 1.0 were released. The first version of .NET Framework was released on 13 February 2002, bringing managed code to Windows NT 4.0, 98, 2000, ME and XP.

Embedded Visual Basic or eVB, is an implementation of Microsoft Visual Basic which is geared towards generating programmes for embedded systems such as PDAs, cellular telephones, pocket computers and other programmable electronic systems and devices, generally for use under Windows CE. The tools themselves run on desktop operating systems such as Windows 98, Windows NT, Windows XP and subsequent. The tools are also capable of compiling executables for Windows NT Embedded as well.

The history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the OS/2 operating system, released in 1989.

References

  1. "Microsoft Announces Availability of MSDE For Developers Using Visual Studio". news.microsoft.com. 24 May 1999. Retrieved 2022-04-16.
  2. "MS SQL Server 2005 Released". databasedir.com.
  3. MSDE Upgrade.
  4. USpatent 6442559,Ronald R. Martinsen, Jeffrey Alger,"Dynamic SKU management",issued 2002-8-27
  5. "Using Microsoft Data Engine". Microsoft Office 2000/Visual Basic Programmer's Guide. Microsoft. Retrieved 2008-11-29.
  6. "When to Use MSDE". Microsoft Office 2000/Visual Basic Programmer's Guide. Microsoft. Retrieved 2008-11-29.
  7. "PRB: MSDE unattended installation needs full path name of the .iss file (MSKB238232)". Knowledge Base. Microsoft. Retrieved 2008-11-19.
  8. Product Information -> Pricing & Licensing (SQL Server 7.0)
  9. Table of Contents for October 2000 Monthly (DVD)
  10. Table of Contents for August 2000 Monthly (CD)
  11. SQL Server 2000 System Requirements
  12. Microsoft SQL Server 2000 Enterprise Edition datasheet
  13. END-USER LICENSE AGREEMENT SERVER LICENSE FOR MICROSOFT SQL SERVER PRODUCTS (SQL Server 2000) 1.c. Use of Redistributable Code.
  14. Resource Kits for MSDE 2000
  15. Microsoft Products that include MSDE 2000
  16. The SQL Server 2000 Workload Governor
  17. MS SQL Server on Vista.
  18. "SQL Server & MSDE". Archived from the original on 2010-07-24.