473,378 Members | 1,478 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 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 2058
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Mitchell S. Honnert | last post by:
In the early days of .NET development, I could react to user's hesitancy to download the Framework with reassurance that it would eventually be included in a future service pack. I also pointed...
13
by: Miro | last post by:
Ok I have been slowely - and ever so slowely teaching myself VB.net Currently I have created an MDB file by code, and added fields to the MDB file by code. I like this solution because, ( im...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.