Re: about MSDE

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 11:51:33 +0100

hi Tarek,
"Tarek" <analystprog@hotmail.com> ha scritto nel messaggio
news:Oooo6%23kEEHA.3408@tk2msftngp13.phx.gbl...
> Hi,
>
> We need to have a clarification and a full technical explanation about the
> folowing issue:
>
> A Year ago Microsoft had announced and released MSDE, Microsoft desktop
> engine,
>
> where we can download it from the internet at the Microsoft website, (it
> comes also free with Microsoft office 2003), which is the engine of SQL
> server database without the enterprise manager service, so what is the
> difference if we use MSDE or the complete SQL server package from a client
> view and application working propery view, and what is the Most suitable
> solution
>
> and why?

you can download the free version MSDE release A from
http://www.microsoft.com/sql/msde/downloads/download.asp and/or the original
version of MSDE from http://www.microsoft.com/sql/downloads/2000/sp3.asp.
they share the same code base and are identical from a technical view
point...
but they are different from a License point of view...
the Release A is free to use for everyone but requires to freely register
for distribution to other end users
(http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp ), while the
latter is free to use and redistribute for all licensed owner of products
such as MSDN universal, VS.Net, Fox Pro, SQL Server and so on....

the main differences between MSDE and the full blown SQL Server are listed
in http://www.microsoft.com/sql/msde/productinfo/features.asp and a
comparative *** of all SQL server edition can be found at
http://www.microsoft.com/sql/evaluation/overview/default.asp

IMHO the main limitations are the 2gb database size and the workload query
governor, which is better described at
http://www.microsoft.com/sql/evaluation/overview/default.asp
it is a powerfull solution for limited (number of clients) requirements and,
in the very small business, has the advantage to be free for the end users.. 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.6.0  -  DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Quantcast