Knowledgebase
MSDE vs MS SQL
Posted by Dan Moses on 11 April 2006 08:59 PM
Essentially, MSDE (Microsoft Data Engine) is a version of SQL Server that you can distribute with applications. As such, it is slightly lighter weight, and has some notable restrictions. Other than the following list, however, MSDE and the other editions of SQL Server have very similar behavior and performance characteristics.

An MSDE database can be no larger than 2 GB (this includes MDF and NDF files only — log sizes are not included in the size limit);

Performance throttling occurs when there are more than five (5) concurrent workload batches in progress (this does *not* mean 5 concurrent *users* — with a properly build application, you can certainly support more. For more detailed information about the query governor, see this MSDN topic);

MSDE cannot be a publisher in transaction replication, and when acting as publisher in all other types of replication, must also be the distributor;

MSDE does not ship with GUI administrative tools such as Enterprise Manager or Query Analyzer

MSDE does not support SQL Mail

MSDE does not offer OLAP / data warehousing capabilities; and,

MSDE does not come with Books Online, but you can download it from Microsoft downloads (updated January, 2004).

-------------

Read more at:

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_9gz4.asp

http://www.microsoft.com/sql/prodinfo/overview/default.mspx

http://www.aspfaq.com/show.asp?id=2343
(1776 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).