New db?

I am going to design a new db that will be accessed thru web pages on my
intranet and the internet. Currently I am using a MS Access db and I have
been told that this is not the best, most efficient "core" for a db. Will
the "Express" edition of MS SQL give me what I am looking for or do I need
to look at the Workgroup Edition? I want to make sure that what ever I use,
it will be robust enough to handle growth.
Hello,
Express edition has a limitation 4 GB database size, So it may not be a good
oprion for you. COnsidering the features available in SQL Server standard
edition
I will recommend you for standard edition over workgroup edition. Take a
look into the below URL:-
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Thanks
Hari
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
|||Since you're coming from Access/JET, SQL Server Express would be the best
first step. Yes, it has a 4GB database limit but unless you're storing BLOBs
in the database, this would be more than enough for a seriously large
database. Yes, there are features in the Workgroup and Standard that might
prove useful (eventually), but (again), given that you're coming from JET, I
don't expect you'll need them.
____________________________________
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.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>