Freigeben über

Difference between SQL Server Express and MSDE

  • Artikel

Hi, I'm attending Teched Europe where we announced the Express Products earlier this week. Several people here have asked me the difference between MSDE and SQL Server Express. I thought that that I'd include a quick high level summary here:

 

SQL Server Express 2005

MSDE 2000

DB Engine Features

· Stored Procedures, Triggers, Views, & Cursors

· Stored Procedures, Triggers, Views, & Cursors

Tools

· SQL Express Manager

· None

Database size

· 4 GB

· 2 GB

Programming

· CLR + T-SQL

· T-SQL

Workload support

· 1 CPU, 1 GB RAM

· Workload Governor

Replication support

· Transactional & Merge (Subscription only)

· Full Merge only

Setup/Install

· GUI, Command line, Silent

· Command line, Silent

Application XCopy

· Available

· Not Available

DTS Runtime

· Not Available

· Available

XML Support

· Native XML

· Non-native support

You can find more details here: https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

I hope that this helps

Many Thanks,

Corey Thomas, Product Manager SQL Server Express

Comments

  • Anonymous
    July 01, 2004
    SQL Server Express installation and blog

  • Anonymous
    July 01, 2004
    There doesn't seem to be alot of info regarding licensing and redistribution in commercial applications where previously we would have used MSDE for example

  • Anonymous
    July 01, 2004
    You forgot to mention SQL Service Broker, a new feature that was non existent in previous versions of SQL.

  • Anonymous
    July 01, 2004
    You forgot to mention SQL Express does not have the SQL Agent.

  • Anonymous
    July 02, 2004
    Is Workload Governor the thing in MSDE that limits the amount of work it does based on connections and such? Does this mean SQL Server Express 2005 will not have this limitation?

  • Anonymous
    July 02, 2004
    I noticed that the DTS Runtime will not be included. In Access, you get the DTS Runtime when you install MSDE. Does this mean that DTS will not be available in Access?

    Currently, I have customers that use DTS to interact with SQL Server databases hosted at ISPs. It is a quick and easy solution to use the DTS Wizard to upload data from the Access database to the SQL Server database using bulk insert. I would hate to see that go away.

    -Weston

  • Anonymous
    July 05, 2004
    Jim,
    Correct the workload governor limits the amount that can be done based on batchs(rather than connections). SQL Express does not have this limitation.

  • Anonymous
    July 06, 2004
    Report services?

  • Anonymous
    July 06, 2004
    What kind of connection limits does SQL Server Express have?

    Is it suitable for deployment for small, non-commercial websites, for example?

  • Anonymous
    July 06, 2004
    SQL Server Express does not have any connection limits.

    Thanks to those you reminded me that i left out a few things like SQL Agent. I'll go back through and take another pass and update this list.

    Thanks, Corey

  • Anonymous
    July 17, 2004
    Better "WITH ENCRYPTION" ... I saw utilities that allows users to decrypt.

  • Anonymous
    August 02, 2004
    Will SQL Server Express support Full Text Search?

  • Anonymous
    August 03, 2004
    SQL Server Express will not support full text serarch

  • Anonymous
    January 21, 2009
    PingBack from http://www.hilpers.it/1741063-data-base

  • Anonymous
    January 21, 2009
    PingBack from http://www.keyongtech.com/2095504-workload-govenor-also-in-sql

  • Anonymous
    June 15, 2009
    PingBack from http://edebtsettlementprogram.info/story.php?id=24181