What's SQL Server express got over Access?

matthew stuart wrote:
> Ah, that's interesting.
>
> So, this may be a stupid question, but I need to ask! Can I create more than one database with SQL Server Express?
>
> And, does it have a GUI?
>
> Thanks

Yes you can create many databases, but I think they have an individual
database size restriction of 4Gb.

the GUI is the Studio Management software, you have it on your desktop
and providing you have the server and your firewall setup correctly you
can connect and control it. This used to be called the Enterprise Manager.

Steve

Ah, that's interesting.

So, this may be a stupid question, but I need to ask! Can I create more than one database with SQL Server Express?

And, does it have a GUI?

Thanks

matthew stuart wrote:
> I have recently found out that there is a free version of SQL server called SQL
> Server Express, and I wondered if anybody here uses the express version. What
> has it got that beats Access? What benefit can I get from using it over Access?
> Does it have any benefits over MySQL? Also, does it have a user interface or
> is it command line based? Any help and advice would be greatly appreciated.
> Thanks. Mat
>

The main difference is that it's a server, unlike Access which is file
that the webserver connects to. It comes with Management Studio software
that allows you to connect to the sql server.

If you own your own or rent a Windows webserver then you can happily
install SQL express, but if you don't, your host will have to offer it
to you as an add on, just like they have to offer MySQL as part of your
hosting package.

Access is really a desktop application that can work on a website, but
its not a "proper" sql server like MS SQL or Oracle or any other other
big boys out there.

You don't need to know SQL to use it, but if you opt to learn SQL, even
just the basics, then it will all make sense and will be beneficial to you.

Steve

Between Access and SQL Express I would chosse SQL Express every time.

It is more scalable, robust and quite simply is not a 'pretent' database. It
uses the same database engine as the full-blown SQL Server product and not
the lightweight Jet engine that Access uses. But hey, that's just my
opinion. It all boils down to what you are actually going to be using it
for. Take a look at the below:

http://www.sqlmag.com/Article/ArticleID/49623/sql_server_49623.html


"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:fo9dqr$1qh$1@forums.macromedia.com...
>I have recently found out that there is a free version of SQL server called
>SQL
> Server Express, and I wondered if anybody here uses the express version.
> What
> has it got that beats Access? What benefit can I get from using it over
> Access?
> Does it have any benefits over MySQL? Also, does it have a user interface
> or
> is it command line based? Any help and advice would be greatly
> appreciated.
> Thanks. Mat
>