471,311 Members | 1,731 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,311 software developers and data experts.

SQL Express and MSDE

Hello!

Visual Studio 2005 includes a copy of SQL Express which is a lightweight
desktop engine version of SQL Server 2005.

Now to my question what is MSDE(Desktop Engine) is that the same as SQL
Express ?

//Tony
Aug 18 '08 #1
5 1950
MSDE is obsolete (support ended in April); SQL Server Express is the
replacement. Note that SQL Server 2008 Express is now available.

Marc
Aug 18 '08 #2
On Aug 18, 2:57*pm, "Tony Johansson" <johansson.anders...@telia.com>
wrote:
Hello!

Visual Studio 2005 includes a copy of SQL Express which is a lightweight
desktop engine version of SQL Server 2005.

Now to my question what is MSDE(Desktop Engine) is that the same as SQL
Express ?
MSDE was essentially a cut-down version of SQL Server 2000; SQL
Express fills roughly the same role for SQL Server 2005 & 2008 (though
somewhat expanded, since it does allow remote connections, which MSDE
did not).

There's also SQL Server CE, which is yet another thing (but also
something worth a look at if you need a lightweight local database for
a desktop application).
Aug 18 '08 #3
"Pavel Minaev" <in****@gmail.comwrote in message
news:06**********************************@2g2000hs n.googlegroups.com...
[...] SQL Express fills roughly the same role for SQL Server
2005 & 2008 (though somewhat expanded, since it does allow
remote connections, which MSDE did not).
This is not entirely accurate. MSDE *did* allow remote connections. The
main limitation in MSDE was that it only worked well with a maximum of 5
remote connections; if you opened more connections then it purposely
degraded its performance to discourage people from using it in this way (and
encourage upgrading to a "full" Sql Server). Sql Express does not have this
limitation and can accept an unrestricted number of remote connections.

Aug 18 '08 #4
On Aug 18, 1:06*pm, "Alberto Poblacion" <earthling-
quitaestoparacontes...@poblacion.orgwrote:
[...] SQL Express fills roughly the same role for SQL Server
2005 & 2008 (though somewhat expanded, since it does allow
remote connections, which MSDE did not).

* *This is not entirely accurate. MSDE *did* allow remote connections.. The
main limitation in MSDE was that it only worked well with a maximum of 5
remote connections; if you opened more connections then it purposely
degraded its performance to discourage people from using it in this way (and
encourage upgrading to a "full" Sql Server). Sql Express does not have this
limitation and can accept an unrestricted number of remote connections.
The other major limitation of MSDE was the size of database it would
cope with. While it looks like there's still a restriction, it's
bigger than it was before (4GB instead of 2GB).

Jon
Aug 18 '08 #5
On Aug 18, 7:15*am, Pavel Minaev <int...@gmail.comwrote:
On Aug 18, 2:57*pm, "Tony Johansson" <johansson.anders...@telia.com>
wrote:
Hello!
Visual Studio 2005 includes a copy of SQL Express which is a lightweight
desktop engine version of SQL Server 2005.
Now to my question what is MSDE(Desktop Engine) is that the same as SQL
Express ?

MSDE was essentially a cut-down version of SQL Server 2000; SQL
Express fills roughly the same role for SQL Server 2005 & 2008 (though
somewhat expanded, since it does allow remote connections, which MSDE
did not).
MSDE does support remote connections. You can manage a remote MSDE
from "Enterprise manager" or "Management Console"

IIRC MSDE did support DTS and the express version does not.
Aug 18 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Mitchell S. Honnert | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.