470,593 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,593 developers. It's quick & easy.

SQL Server 2005 Express Edition Overview


[... big long snip ...]

SQL Server Express was developed with two distinct uses in mind. The first
is as a server product, especially as a Web server or a database server.
The second is as a local client data store where the application data
access does not depend on the network. Ease of use and simplicity are key
design goals.

The three main usage scenarios for SQL Server Express are:
Non-professional developers building Web applications
ISVs redistributing SQL Server Express as a low-end server or client data
Hobbyists building basic client/server applications

[... more snipping ...]

Visual Studio Integration

SQL Server Express is installed with all the 32-bit editions of Visual
Studio. Visual Studio installs SQL Server Express using the instance name
SQLEXPRESS. In SQL Server Express Technical Preview, the applications rely
on the SQLEXPRESS instance name, but this could change in future. The goal
of Visual Studio and SQL Server Express integration is to make database
access with SQL Server Express as simple and easy as working with Jet.

[... more snipping ...]

Comparison with Jet

SQL Server Express is based on the latest SQL Server 2005 technology,
while Jet has been in service pack and maintenance stage for quite some
time. All the latest and greatest features, such as CLR integration and
XML support, are available only in SQL Server Express. The reliability and
scalability story of SQL Server Express is also great. Applications
written to SQL Server Express can easily move to SQL Server Standard or
Enterprise editions, while Jet is more difficult to scale up. SQL Server
Express also provides finer-grained security control over its database
files. With the Visual Studio 2005 integration and the Application XCopy
feature, we are bringing the ease of use of Jet to SQL ServeR.

Darryl Kerkeslager
Nov 13 '05 #1
1 1816

"Darryl Kerkeslager" <ke*********@comcast.net> wrote in message
news:op**************@tigger.cnorth01.va.comcast.n et...
[... big long snip ...]

<another snip>


Simple Pricing and Licensing

Always free to obtain and use
Royalty free redistribution (registration required)

That's pretty interesting.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by NetIdiot | last post: by
14 posts views Thread by Developer | last post: by
2 posts views Thread by kress1963nov22 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.