Good morning to all,

Well.. the time has come that I need to take the plunge and upgrade an
existing site I have running ASP/Access/IIS5/W2K Server.

I have been racking my brain looking for information on the web
regarding which of the 3 platforms I mentioned above would be the best
choice (MySQL, SQLServer, FoxPro, MSDE).

The site is e-Commerce with an expected load of about 1500 visits per
day with 30-35 concurrent connections needed.  In development, the site
worked flawlessly with no more than 6-8 concurrent connections, thus the
need for the upgrade.

Any thoughts?  I would love to go the MySQL route but have read that it
is not that great of a DB to handle transactions, and that its interface
to ASP is not as tight as it would be for PHP.  Lastly, any thoughts on
a good migration utility to port out of Access into the new DB?

As always... many thanks.

Regards,
Eric

Would also be interested in any opinions, as am in the same situation.

Thanks,

Martin

At 09:59  4/19/2002 -0400, you wrote:
>Good morning to all,
>
>Well.. the time has come that I need to take the plunge and upgrade an
>existing site I have running ASP/Access/IIS5/W2K Server.
>
>I have been racking my brain looking for information on the web
>regarding which of the 3 platforms I mentioned above would be the best
>choice (MySQL, SQLServer, FoxPro, MSDE).
>
>The site is e-Commerce with an expected load of about 1500 visits per
>day with 30-35 concurrent connections needed.  In development, the site
>worked flawlessly with no more than 6-8 concurrent connections, thus the
>need for the upgrade.
>
>Any thoughts?  I would love to go the MySQL route but have read that it
>is not that great of a DB to handle transactions, and that its interface
>to ASP is not as tight as it would be for PHP.  Lastly, any thoughts on
>a good migration utility to port out of Access into the new DB?
>
>As always... many thanks.
>
>Regards,
>Eric
>
>
>
>
>

SQL Server is an enterprise class RDBMS. mySQL simply isn't in the same
league. If you don't think you need transactions and so forth, then use
mySQL.

On the other hand, if you want to build a really robust system, then use SQL
Server (or Oracle, or DB2 or any of the other enterprise class DBMSes)

There are whole books on what goes into building a good DBMS, most of which
isn't easy to explain via a list. I can recommend a book or two if you're
interested in the theory...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Eric Levine" <eric@d...>
Subject: [access_asp] Access Migration -- MySQL vs. SQLServer vs. FoxPro vs.
MSDE


: Good morning to all,
:
: Well.. the time has come that I need to take the plunge and upgrade an
: existing site I have running ASP/Access/IIS5/W2K Server.
:
: I have been racking my brain looking for information on the web
: regarding which of the 3 platforms I mentioned above would be the best
: choice (MySQL, SQLServer, FoxPro, MSDE).
:
: The site is e-Commerce with an expected load of about 1500 visits per
: day with 30-35 concurrent connections needed.  In development, the site
: worked flawlessly with no more than 6-8 concurrent connections, thus the
: need for the upgrade.
:
: Any thoughts?  I would love to go the MySQL route but have read that it
: is not that great of a DB to handle transactions, and that its interface
: to ASP is not as tight as it would be for PHP.  Lastly, any thoughts on
: a good migration utility to port out of Access into the new DB?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~