Forum Moderators: open
I have a website written in asp and hosted on a Microsoft server. The website is currently writing to an Access database.
Would it be OK to transfer this database to MY SQL or would it be better to choose the Microsoft version?
What do you think?
If you're still at the point where you're not crashing with Access, MySQL will probably be fine if you don't want to spend the money right now. But you may reach the point some time where a free solution just won't scale any longer. Chances are you're many months or years away from that point, so the money would probably be better spent in other development right now.
Oh, and I am saying that as an MS SQL user (who did the Access -> MS SQL migration years ago).
It depends of how big you plan to grow
...
you may reach the point some time where a free solution just won't scale any longer
even bigger than G, perhaps?
you can design non-scalable architectures for proprietary technology as well.
from the mysql site [mysql.com]:
In the online world, many of the largest and fastest-growing companies use MySQL to cost-effectively Scale-Out their successful businesses, saving millions of dollars over high-cost proprietary technology including Google, Yahoo, craigslist, Ticketmaster, Wikipedia, YouTube, and Evite/Citysearch.
