asp & ms-sql vs msde

for some small websites we still have access db's running. i want to convert
them to a true sql db. now i wonder if there is any impact of putting the
dbs into a msde when accessing the data from asp websites.

as far as i found out, the limitations of a msde database shouldn't be of
any matters when using as db backend for small to midsize websites. still i
might be missing something, as most docus try to sell the expensive ms-sql
server, of course ;-)

anyone got some real-world experience and knows in what cases a ms-sql is
needed over an msde installation?

cheers,
thomas

Re: asp & ms-sql vs msde

Thomas wrote:
> for some small websites we still have access db's running. i want to
> convert them to a true sql db. now i wonder if there is any impact of
> putting the dbs into a msde when accessing the data from asp websites.
>
> as far as i found out, the limitations of a msde database shouldn't
> be of any matters when using as db backend for small to midsize
> websites. still i might be missing something, as most docus try to
> sell the expensive ms-sql server, of course ;-)
>
> anyone got some real-world experience and knows in what cases a
> ms-sql is needed over an msde installation?
>
> cheers,
> thomas
msde IS ms-sql, just scaled down to make it more useful as a development
tool than as a production database. You need to carefully read the EULA to
verify that you are legally in the clear to use msde for production purposes
(IANAL, so I cannot say one way or the other).

The main difference with msde (outside of the lack of client tools -
Enterprise Mangaer, Profiler, Query Analyzer, etc) is that it has a
"governor" that slows down processing when more than 5 threads are spawned.
If the website has low enough usage, there is not reason (outside of
legality) that msde cannot be used.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: asp & ms-sql vs msde

i guess the §4 of EULA does not leave much choice but keep using access dbs
or switch to mysql:

4. NO RENTAL/COMMERCIAL HOSTING. You may not rent, lease, lend or provide
commercial hosting services with the Software.

a pitty. thanks for pointing this out.

- thomas

"Bob Barrows [MVP]" wrote in message
news:eEx$N$tLFHA.2648@TK2MSFTNGP14.phx.gbl...
> Thomas wrote:
>> for some small websites we still have access db's running. i want to
>> convert them to a true sql db. now i wonder if there is any impact of
>> putting the dbs into a msde when accessing the data from asp websites.
>>
>> as far as i found out, the limitations of a msde database shouldn't
>> be of any matters when using as db backend for small to midsize
>> websites. still i might be missing something, as most docus try to
>> sell the expensive ms-sql server, of course ;-)
>>
>> anyone got some real-world experience and knows in what cases a
>> ms-sql is needed over an msde installation?
>>
>> cheers,
>> thomas
> msde IS ms-sql, just scaled down to make it more useful as a development
> tool than as a production database. You need to carefully read the EULA to
> verify that you are legally in the clear to use msde for production
> purposes
> (IANAL, so I cannot say one way or the other).
>
> The main difference with msde (outside of the lack of client tools -
> Enterprise Mangaer, Profiler, Query Analyzer, etc) is that it has a
> "governor" that slows down processing when more than 5 threads are
> spawned.
> If the website has low enough usage, there is not reason (outside of
> legality) that msde cannot be used.
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Re: asp & ms-sql vs msde

Thomas wrote:

> i guess the §4 of EULA does not leave much choice but keep using access dbs
> or switch to mysql:

Try PostGreSQL
http://www.postgresql.org/
rather than mysql. PostGreSQL is a full-fledged open-source database
with all the features that mysql doesn't have. A Windows version was
recently released.