Comparing SQL Server Express with MSDE

Early this month, I have delivered a number of START.NET program workshops (.NET Framework 3.0- Windows Workflow Foundation, .NET Framework 3.0- Windows Communication Foundation, and .NET Framework 3.0- Windows Presentation Foundation). There are some participants who asked me to compare SQL Server Express with MSDE. I’ll do a more thorough comparisons on the two products over here as I have promised.
 
SQL Server 2000 MSDE is the predecessor to Microsoft SQL Server 2005 Express Edition (SQL Server Express), and is based on SQL Server 2000. If you are updating your applications to use SQL Server Express, you must consider the changes in feature support from MSDE to SQL Server Express.
 
SQL Server Express and MSDE Limitations
 
The following table lists the limits that have been set for MSDE and SQL Server Express databases.

————————————————————————————————-
Limitation                              MSDE Limit                 SQL Server Express Limit
————————————————————————————————-
Concurrent workload governor (throttle) Yes                        No
 
Database size limitation                2 GB                       4 GB
 
RAM support                             2 GB                       1 GB
 
SMP support                             2 (or 1 if MSDE is run on  1
                                        Windows 98 or Windows
                                        Millennium Edition)
————————————————————————————————-
 
MSDE and SQL Server Express Feature Support
 
The following table lists the changes in feature support between the products.
————————————————————————————————-
Feature Area                  Supported in MSDE?        Supported in SQL Server Express?
————————————————————————————————-
Merge Replication             Yes                       Yes, as a Subscriber only
Transactional Replication     Yes, as a Subscriber only Yes, as a Subscriber only
Snapshot Replication          Yes                       Yes, as a Subscriber only
SQL Server Profiler           No                        Yes only if another edition of SQL Server
                                                        2005 is installed on the same machine as
                                                        SQL Server Express.
Database Engine Tuning Wizard No                        No
SQL Server Agent              Yes                       No
 
Active Directory registration No                        Yes
————————————————————————————————-
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: