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]
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 Engineedit
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]
Featuresedit
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]
msde, maryland, state, department, education, maryland, state, department, education, this, article, needs, additional, citations, verification, please, help, improve, this, article, adding, citations, reliable, sources, unsourced, material, challenged, remove. For Maryland s state department of education see Maryland State Department of Education This article needs additional citations for verification Please help improve this article by adding citations to reliable sources Unsourced material may be challenged and removed Find sources MSDE news newspapers books scholar JSTOR March 2009 Learn how and when to remove this template message 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 1 Overview 1 1 Microsoft Desktop Engine 1 2 Microsoft SQL Server Data Engine 2 Features 3 See also 4 References 5 External linksOverview editMicrosoft Desktop Engine edit 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 edit 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 editCompared 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 editSQL Server Compact SQL Server Express LocalDBReferences edit Microsoft Announces Availability of MSDE For Developers Using Visual Studio news microsoft com 24 May 1999 Retrieved 2022 04 16 MS SQL Server 2005 Released databasedir com MSDE Upgrade US patent 6442559 Ronald R Martinsen Jeffrey Alger Dynamic SKU management issued 2002 8 27 Using Microsoft Data Engine Microsoft Office 2000 Visual Basic Programmer s Guide Microsoft Retrieved 2008 11 29 When to Use MSDE Microsoft Office 2000 Visual Basic Programmer s Guide Microsoft Retrieved 2008 11 29 PRB MSDE unattended installation needs full path name of the iss file MSKB238232 Knowledge Base Microsoft Retrieved 2008 11 19 Product Information gt Pricing amp Licensing SQL Server 7 0 Table of Contents for October 2000 Monthly DVD Table of Contents for August 2000 Monthly CD SQL Server 2000 System Requirements Microsoft SQL Server 2000 Enterprise Edition datasheet END USER LICENSE AGREEMENT SERVER LICENSE FOR MICROSOFT SQL SERVER PRODUCTS SQL Server 2000 1 c Use of Redistributable Code Resource Kits for MSDE 2000 Microsoft Products that include MSDE 2000 The SQL Server 2000 Workload Governor MS SQL Server on Vista SQL Server amp MSDE Archived from the original on 2010 07 24 External links editMicrosoft page MSDE 2000 SQL Server Express Edition Retrieved from https en wikipedia org w index php title MSDE amp oldid 1153556790, wikipedia, wiki, book, books, library,
