Hi,
I would suggest that you need to change. It is correct about estimating where the usage comes from and what it is doing.
As such you need to make the decision if to migrate and if so what to.
Now either database is a solid and fast platform and can be integrated into most things that you are doing.
If you are using asp for your web portal then I would suggest that you use mssql because it is easier to integrate, similarly if you are using php then I'd reccomend php.
One issue you will have is getting the data from access to either of your chosen database platforms - if you choose to use mysql there is a mysql migration toolkit available on mysql's web site that makes migrating easy (in terms of converting the data and creating appropriate tables, without loosing data). If you chose to go down the mssql option migration is not too hard using DTS / SSIS depending on what version you choose.
Either way the ways that queries are run have slightly different syntax, and you can not "save" the queries in these databases as you would in access.
You can save views that store the data or have stored procedures to do inserts / updates for you - but this requires some effort to produce.
at the end of the day the choice is up to you - but both will give you better stability and performance than access, and your sites should not suffer because of the access dll problem that you mentioend.
I would reccomend mysql because there are more hosting solutions that provide mysql databases as opposed to sql server, and you can run mysql on nearly all operating systems.
Main Topics
Browse All Topics
by: dale_burrellPosted on 2007-02-13 at 18:56:26ID: 18528253
Can you not just use another webhost?
Otherwise you can use SQL Server 2005 Express for free - although you do need to find a host for that which won't be free. SQL Server Express is way way better than Access but with your Access background you should be able to pick it up fairly quick.
I can't comment on MySQL - never used it. Cheaper to host I believe but may take more learning time.