Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applicat
ions but don't do the SQL maintenance but do build db (my dba checks everyth
ing and sets all the permissions, etc). Anyway, a nonprofit has asked me to
build them a web applicati
on to collect and display information nothing too fancy but lots of data and
lot of users.
What are my options? Do I have to buy the server version if I just want to
build a database but it is going to be collecting and serving the informatio
n from our web host (they've agreed to the extra cost for a web host providi
ng SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and uplo
ad it to our web host. My dba said try access but it only allows 5 concurr
ent connections. I've heard of mysql or something but since I am somewhat f
amiliar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis
or use the info other than to display it on web pages. They estimate they
have 5,000 - 10,000 users who will enter 10 to 20 records each including pho
tos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database
and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I
go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba chec
ks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display informatio
n
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So
I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MyS
ql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or us
e
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos
.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/d...ds/download.asp
David