473,903 Members | 4,199 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Why choose SQL Express over Access?

ljh
Why would you choose SQL Express (which requires an installed application to
work) over the simplicity of an Access database which has no dependencies?

May 30 '06
74 3822
ljh
"INETA Speaker" - at least you're unbiased.
"William (Bill) Vaughn" <bi************ **@nwlink.com> wrote in message
news:Om******** ******@TK2MSFTN GP04.phx.gbl...
Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
It's not designed to do so but SQL Express (still free) is.
Microsoft has done more for small business than any company I know. It now
offers three versions of its database technology for free. SQL Everywhere,
SQL Express and SQL Express Advanced Services that includes the Reporting
Services engine as well as Full Text Search.

If you just want to bash Microsoft, find some other forum.

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
_______________ _______________ ____

"ljh" <So**@where.els e> wrote in message
news:_J******** ***********@big news3.bellsouth .net...
Awesome!

It doesn't look like they'll let us use it to power webservices under IIS
though.

That would suck. Allowing its use under IIS would make hosted web
development so much easier!

It would let small companies with big ideas give those ideas a shot at
succeeding without spending several thousand dollars for SQL Server.

But, I don't think MS is all that interested in helping small businesses
grow. And, that's too bad. Doing so would actually fatten the bottom
line at MS as the little businesses need more MS licenses and maybe a
"grown up" version of SQL Server.

If they did, who knows, it might even unseat MySQL as the web db king.

Thanks for the great link!

"William Stacey [MVP]" <wi************ @gmail.com> wrote in message
news:Od******** ********@TK2MSF TNGP03.phx.gbl. ..
Another option for you may be SQL Everywhere. I think will be released
this
summer. 1.4mb with 7 dlls.
http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx

--
William Stacey [MVP]

"ljh" <So**@where.els e> wrote in message
news:Dm******** ***********@big news3.bellsouth .net...
|I mean that you can use Access databases simply by including the .mdb
files
| with your application, whereas using SQL Server Express requires that
you
| install SQL Server Express and have it running in the backgound.
|
| In the event that I use SQL Server Express and need to redistribute it
with
| my app, is there a silent install available?
|
| <ja**********@g mail.com> wrote in message
| news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
| > Well, I'm not sure what you mean by "requires an installed
application
| > to work". I just downloaded it, ran the setup & it worked. And,
since
| > your reluctance to do that is the *ONLY* requirement you specify for
| > your database needs, it's really hard to answer your question.
| >
| > So, the advantages of SQLExpress over Access, as I see them.
| > 1) It's free.
| > 2) It's directly compatible with Sql Server.
| >
|
|



May 31 '06 #31
ljh
The connector for VS 2005 (.Net 2.0) makes connecting to the SQLite db a
snap.

But, it lacks any means of database manipulation (i.e. adding/removing
tables or columns or anything) from within the IDE.

So, ease of use is definitely not up there with SQL Express.
"ljh" <So**@where.els e> wrote in message
news:Ue******** ***********@big news3.bellsouth .net...
oops! forgot the link to the page where I saw the quote......

http://sourceforge.net/forum/forum.php?forum_id=489095

"ljh" <So**@where.els e> wrote in message
news:7e******** ***********@big news3.bellsouth .net...
I was looking at the site () and came across "Version 1.0.14 of the SQLite
.Net Data Provider for ADO.NET 2.0/VS 2005 is out and includes design-time
support. You can now create databases, design queries, and drag-and-drop
tables to create typed datasets within Visual Studio 2005. "

Is this capability still in there? I didn't see any examples of this.
If SQLite is as easy to use as this quote seems to make it (i.e. as easy
to use in the ide as SQL Express) we may just have a winner here.
"JimD" <Ji*@keeliegirl .dyndns.org> wrote in message
news:yu******** *********@torna do.tampabay.rr. com...
JimD wrote:

<snip>

I forgot to mention about the connection string in the example. The
connection string is:

Data Source=database .db;Version=3;N ew=True;Compres s=True;

The New=True token says to create a new database. So every time you run
the test program, you are creating a new database, overwriting the old.
You probably don't want to do that with a real application. So you
would only use the New=True in a connection string when you want to
create a database for the first time. After that, you can either remove
New=True or change it to New=False.
Jim
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
There's no place like 127.0.0.1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
JimD
Central FL, USA, Earth, Sol



May 31 '06 #32
I use the SQLiteQA application, which does a very nice job and acts much like
Query Analyzer.

A copy is included in the download for this article:

http://www.eggheadcafe.com/articles/20051119.asp
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"ljh" wrote:
The connector for VS 2005 (.Net 2.0) makes connecting to the SQLite db a
snap.

But, it lacks any means of database manipulation (i.e. adding/removing
tables or columns or anything) from within the IDE.

So, ease of use is definitely not up there with SQL Express.
"ljh" <So**@where.els e> wrote in message
news:Ue******** ***********@big news3.bellsouth .net...
oops! forgot the link to the page where I saw the quote......

http://sourceforge.net/forum/forum.php?forum_id=489095

"ljh" <So**@where.els e> wrote in message
news:7e******** ***********@big news3.bellsouth .net...
I was looking at the site () and came across "Version 1.0.14 of the SQLite
.Net Data Provider for ADO.NET 2.0/VS 2005 is out and includes design-time
support. You can now create databases, design queries, and drag-and-drop
tables to create typed datasets within Visual Studio 2005. "

Is this capability still in there? I didn't see any examples of this.
If SQLite is as easy to use as this quote seems to make it (i.e. as easy
to use in the ide as SQL Express) we may just have a winner here.
"JimD" <Ji*@keeliegirl .dyndns.org> wrote in message
news:yu******** *********@torna do.tampabay.rr. com...
JimD wrote:

<snip>

I forgot to mention about the connection string in the example. The
connection string is:

Data Source=database .db;Version=3;N ew=True;Compres s=True;

The New=True token says to create a new database. So every time you run
the test program, you are creating a new database, overwriting the old.
You probably don't want to do that with a real application. So you
would only use the New=True in a connection string when you want to
create a database for the first time. After that, you can either remove
New=True or change it to New=False.
Jim
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
There's no place like 127.0.0.1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
JimD
Central FL, USA, Earth, Sol



May 31 '06 #33
Let's see:

Ability to do asynch apps (Service Broker)
Server model instead of file system model
Complete support for stored procedures
Full SQL Server security model
Ability to run queries as another user, completely isolating the database
from the user
Better support for types in SQL Server than Access (in .NET)
Ability to schedule backups within the engine
Support for more types than Access
Ability to use XML as a datatype with querying capabilities

Is that enough, or should I go on?

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"ljh" <So**@where.els e> wrote in message
news:kP******** ***********@big news3.bellsouth .net...
Why would you choose SQL Express (which requires an installed application
to work) over the simplicity of an Access database which has no
dependencies?

May 31 '06 #34
> The fact that Micrsoft added code to SQL Everywhere to PREVENT it from
being used in an IIS process sucks! What about that don't you get?
First of all "CALM DOWN".
The fact that you can't control SQL Express (due to the fact that you
usually don't control the HOSTED servers) and that you could get more data
into SQL Everywhere (or SQLite for that matter) simply by using the
available disk space than you do with most hosted website's db plans
(which will include hosted SQL Express servers) sucks!
Moving SQL Express to SQL Server is a peice of cake. I don't see what the
big unsolvable problem here is.

- Sahil Malik [MVP]
http://blah.winsmarts.com

"ljh" <So**@where.els e> wrote in message
news:og******** ********@bignew s5.bellsouth.ne t... The fact that you can't control SQL Express (due to the fact that you
usually don't control the HOSTED servers) and that you could get more data
into SQL Everywhere (or SQLite for that matter) simply by using the
available disk space than you do with most hosted website's db plans
(which will include hosted SQL Express servers) sucks!

The fact that MS has an edition of Mobile SQL that they are making
available for everything except IIS use sucks!

The fact that Micrsoft added code to SQL Everywhere to PREVENT it from
being used in an IIS process sucks! What about that don't you get?

Microsoft again makes a valiant run downfield with the ball.....only to
stop and sit on the 1 yard line.
"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:Or******** ******@TK2MSFTN GP03.phx.gbl...
Okay .. why does SQL express suck? It doesn't suck .. !!! It runs on a
full fledged SQL engine, sure deployment is a pain, but migrating to a
fullblown SQL Server is relatively painless.
Also, can you elaborate -
| Got confirmation from MS that they're deliberately breaking
compatabili ty
| with SQL\e running under IIS - they call it "soft-blocking".

?

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com


"ljh" <So**@where.els e> wrote in message
news:mo******** ***********@big news3.bellsouth .net...

"William Stacey [MVP]" <wi************ @gmail.com> wrote in message
news:eE******** ******@TK2MSFTN GP03.phx.gbl...
| Got confirmation from MS that they're deliberately breaking
compatabili ty
| with SQL\e running under IIS - they call it "soft-blocking".

Not sure how they would do that other then via license. I mean a sql
query
is not going to look any different coming from asp.net page or from
your own
host?

Not sure.....that's the word I got back from Steve Lasker when I emailed
him earlier today.
| Sounds all fluffy and sweet....but what it means is that you won't be
able
| to use SQL\e to easily deploy webservices (actually you can;t use it
to
| deploy them at all - easy or not).

Again, I think you should at least be able to use SQL Express and it is
free. IMHO, that product is a sweet and generous gift from MS.

It is....for machines where you can install anything you want. For
ASP.Net hosted webservers, it sucks.



May 31 '06 #35
http://msdn.microsoft.com/library/en...seoverview.asp

"ljh" <So**@where.els e> wrote in message
news:kP******** ***********@big news3.bellsouth .net...
Why would you choose SQL Express (which requires an installed application to
work) over the simplicity of an Access database which has no dependencies?

May 31 '06 #36
ljh
Just curious......ca n you tell me a situation where using XML as a datatype
would come into play in a database application?

Why would you store XML in its native format instead of breaking it down
into its component fields for storage and seaarch?
"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM> wrote in
message news:O6******** ******@TK2MSFTN GP02.phx.gbl...
Let's see:

Ability to do asynch apps (Service Broker)
Server model instead of file system model
Complete support for stored procedures
Full SQL Server security model
Ability to run queries as another user, completely isolating the database
from the user
Better support for types in SQL Server than Access (in .NET)
Ability to schedule backups within the engine
Support for more types than Access
Ability to use XML as a datatype with querying capabilities

Is that enough, or should I go on?

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"ljh" <So**@where.els e> wrote in message
news:kP******** ***********@big news3.bellsouth .net...
Why would you choose SQL Express (which requires an installed application
to work) over the simplicity of an Access database which has no
dependencies?


May 31 '06 #37
> Sahil Malik [MVP C#] wrote:

There is one more Access advantage: it'll run on Windows XP Home
Edition, while SQL Express will not (requires XP Pro). So if you are
targeting mom&pop shops or the home market, either do Access or stick
to MSDE.

Regards


This is not true. SQL Express runs under XP Home as well (at least it does
on my machine). However, it does not support remote connections by default.
May 31 '06 #38
Thanks Sahil. I thought it did but did not have a rig here to test it with.
Of course even the home system could host SQL Server as a service if you
throw the right switches.

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
_______________ _______________ ____

"Jos Roijakkers" <j.**********@q red-it.nl> wrote in message
news:5d******** *************** **@news.microso ft.com...
Sahil Malik [MVP C#] wrote:

There is one more Access advantage: it'll run on Windows XP Home
Edition, while SQL Express will not (requires XP Pro). So if you are
targeting mom&pop shops or the home market, either do Access or stick
to MSDE.

Regards


This is not true. SQL Express runs under XP Home as well (at least it does
on my machine). However, it does not support remote connections by
default.

May 31 '06 #39
_DD
On Tue, 30 May 2006 15:49:50 -0700, Frank Rizzo <no**@none.co m> wrote:
Sahil Malik [MVP C#] wrote:
The only advantage Access gives you is "File based deployment". And frankly
SQL Anywhere (or was it everywhere - I loose track in all these name
changes) should be a better choice for desktop-ish applications anyway.


There is one more Access advantage: it'll run on Windows XP Home
Edition, while SQL Express will not (requires XP Pro). So if you are
targeting mom&pop shops or the home market, either do Access or stick to
MSDE.


There are lots of places where an app that normally runs on high-end
XP Pro machines would have to run on XP Home as well. Does this mean
that applications must fit the common denominator: MSDE? I didn't
think MSDE was still supported.

And what about XP Media Center? I'd love to find out about future
plans to adapt to MC and Home editions, assuming there is no way to
target them now.

May 31 '06 #40

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

72
3343
by: ljh | last post by:
Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies?
0
9845
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11279
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10872
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8047
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7205
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5893
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6085
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4725
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4307
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.