View source for MSDE

{{for|[[Maryland]]'s state department of education|Maryland State Department of Education}}
{{More citations needed|date=March 2009}}
'''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,<ref>{{cite web
|date=1999-05-24 |df=dmy
|title=Microsoft Announces Availability of MSDE For Developers Using Visual Studio
|work=news.microsoft.com
|url=https://news.microsoft.com/1999/05/24/microsoft-announces-availability-of-msde-for-developers-using-visual-studio/
|access-date=2022-04-16
}}</ref> and was included as part of [[Microsoft Office]] 2000 Developer Edition. Its successor, [[SQL Server Express]] was released in November 2005.<ref>{{cite web
|url=http://www.databasedir.com/sql-server-2005-released/
|title=MS SQL Server 2005 Released
|publisher=databasedir.com
}}</ref> Vendor support of MSDE ended on April 8, 2008.<ref name = "Upgrade">[http://www.microsoft.com/sql/editions/express/upgrade.mspx MSDE Upgrade].</ref>

==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.<ref>{{US patent reference | number = 6442559 | y = 2002 | m = 8 | d = 27 | inventor = Ronald R. Martinsen, Jeffrey Alger | title = Dynamic SKU management}}</ref>

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.<ref>{{Cite web|url=http://msdn.microsoft.com/en-us/library/aa190082.aspx|title=Using Microsoft Data Engine|accessdate=2008-11-29|work=Microsoft Office 2000/Visual Basic Programmer's Guide|publisher=Microsoft}}</ref> 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.<ref>{{Cite web|url=http://msdn.microsoft.com/en-us/library/aa190124(office.10).aspx|title=When to Use MSDE|accessdate=2008-11-29|work=Microsoft Office 2000/Visual Basic Programmer's Guide|publisher=Microsoft}}</ref> 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 [[DEC Alpha|Alpha]] architectures.<ref>{{Cite web|url=http://support.microsoft.com/kb/238232/|title=PRB: MSDE unattended installation needs full path name of the .iss file (MSKB238232)|accessdate=2008-11-19|work=Knowledge Base|publisher=Microsoft}}</ref>

Microsoft Data Engine can be found in Microsoft Access 2000 and other Microsoft products.<ref>[https://web.archive.org/web/20000818085741/http://microsoft.com/sql/productinfo/pricing.htm Product Information -> Pricing & Licensing (SQL Server 7.0)]</ref>

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.,<ref>[http://msdn.microsoft.com/subscriptions/index/DVDtable.asp Table of Contents for October 2000 Monthly (DVD)]</ref> or in October 2000 MSDN CD ''Office Test Platform and Development Tools'' (English Pack, European Pack I, Japanese Pack, Latin American pack).<ref>[https://web.archive.org/web/20010603042836/http://msdn.microsoft.com/subscriptions/index/cdtable.asp Table of Contents for August 2000 Monthly (CD)]</ref>

===Microsoft SQL Server Data Engine===
It is based on SQL Server 2000. System requirement was changed to Windows 98.<ref>[https://web.archive.org/web/20090317090217/http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx SQL Server 2000 System Requirements]</ref><ref>[https://web.archive.org/web/20060111214425/http://www.microsoft.com/sql/evaluation/overview/2000/2000Datasheet.doc Microsoft SQL Server 2000 Enterprise Edition datasheet]</ref>

MSDE could be distributed with commercial products by registering with Microsoft — in most cases this distribution is also free of charge.{{Citation needed|date=March 2009}} SQL Server's server licence includes right to distribute MSDE.<ref>[http://download.microsoft.com/documents/useterms/SQL%20Server%20Standard_2000_English_330ff319-b1fc-47d1-862e-53a64ca2a568.pdf END-USER LICENSE AGREEMENT SERVER LICENSE FOR MICROSOFT SQL SERVER PRODUCTS (SQL Server 2000)] 1.c. Use of Redistributable Code.</ref>

MSDE 2000 includes following resource kits: MSDE 2000 Deployment Resource Kit, MSDE 2000 Web Resource Kit.<ref>[https://web.archive.org/web/20050420001104/http://www.microsoft.com/sql/msde/techinfo/reskit/default.asp Resource Kits for MSDE 2000]</ref>

MSDE 2000 is also found in various products, such as Microsoft Office XP (Professional, Developer), Visual Studio .NET 2002-2003.<ref>[https://web.archive.org/web/20070228035943/http://www.microsoft.com/technet/security/bulletin/msdeapps.mspx Microsoft Products that include MSDE 2000]</ref>

==Features==
Compared with the full server editions of SQL Server 7.0 and 2000, MSDE has some restrictions: a limit of 2 [[Gigabyte|GB]] databases, and has a workload governor which reduces its speed when eight or more [[parallel programming|concurrent]] workloads are running.<ref>[http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx The SQL Server 2000 Workload Governor]</ref> Microsoft has also stated that MSDE is not supported in Windows NT 6.0 operating systems such as [[Windows Vista]].<ref name="Vista">[http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx  MS SQL Server on Vista].</ref> No [[graphical user interface]] management tools were released for MSDE, but Micrsoft Access or SQL Server 2000's [[Enterprise Manager]] (as well as later versions such as [[SQL Server Management Studio]]) can be used to connect to it and manage it.<ref>{{cite web |url=http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html |title=SQL Server & MSDE |url-status=dead |archiveurl=https://web.archive.org/web/20100724165221/http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html |archivedate=2010-07-24 }}</ref>

==See also==
* [[SQL Server Compact]]
* {{slink|SQL Server Express#LocalDB}}

==References==
{{Reflist|30em}}

==External links==
*Microsoft page: [https://web.archive.org/web/20080501031512/http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx MSDE 2000]
*[http://www.microsoft.com/sql/editions/express/default.mspx SQL Server Express Edition]

{{MS DevTools}}

{{DEFAULTSORT:Msde}}
[[Category:Proprietary database management systems]]
[[Category:Microsoft server technology]]
[[Category:Discontinued Microsoft software]]

[[ja:Microsoft SQL Server#MSDE]]