Say Bye Bye to MSDE SQL

By Eric Jones

Ok all! I just found this, so forgive me if you’ve found it already.

Apparently Microsoft has decided to get rid of the MSDE version of SQL Server. MSDE is the Microsoft Developers Edition, this is a free version of SQL Server which is intended for development purposes and some stand alone applications.

Now before you get upset (or get all excited that MS is dropping something), I have to tell you WHY they are dropping the MSDE. Apparently the next version of SQL will have a SQL Express version. It’s this version which will replace the MSDE Version AND it will also be more friendly with distribution and usage.

I see this as Microsoft attempt to break into the free market that MySQL and PostGreSQL have had for so long. Funny isn’t it, MySQL start charging for a version, and Microsoft gives a version away!

You can learn all about it, and even download a beta 2 release here.

  • Matt Liotta

    Actually, MSDE stands for Microsoft SQL Server Desktop Engine, which according to the following link is the free, redistributable version of SQL Server that

  • Dave Ross

    yes, MSDE is pretty flexible. It’s basically SQL server, except db’s are limited to 2GB and there is a performance throttle for a certain number of simultaneous operations. It’s actually very effective for small size network applications or standalone software. SQL Express looks like it will be MSDE with a different name and some tweaks to the limitations.

  • Moardib

    MSDE is a fine product also for development. It has all the SQL 2000 features, like stored procedures, views, etc. The footprint is minimal and you can even test across a network. Although MSDE does not come with any client tools, it does have OSQL (command line).

    If you do not dig into typing commands, MS also gives away for free the Web Data Administrator. You must have .Net Framework installed and it’s a small 739kb download.
    Grab @ http://www.microsoft.com/downloads/details.aspx?familyid=f0d03472-5e6c-459e-a6d8-6745a729c3c9&displaylang=en

  • Mike

    I’m currently using MSDE, but plan on installing SQL Server Developer’s Edition. When I do this will I loose my databases?

  • jonese

    from what i’ve read no. your DB’s will still work and can even be attached in MS SQL Standard & Enterprise versions.



Learn Coding Online
Learn Web Development

Start learning web development and design for free with SitePoint Premium!

Instant Website Review

Use Woorank to analyze and optimize your website to improve your website to improve your ranking!

Run a review to see how your site can improve across 70+ metrics!

Get the latest in Front-end, once a week, for free.