Roadmap for moving from Access to SQL Server

[easymoney]

Any have good practical advice for a developer looking to utilize sql server. I have several apps that us MS access and ADO, but I also have several db driven websites using MySQL running on Apache and Windows XP, but it is currently hosted on a 3rd party server.

I am wish to port my ADO apps and web sites to a local SQL server.

I am looking into Sqlite, MySql and Apache, and MS SQL Server along with vb6/.Net for apps and PHP/java for db driven webs.

What would be a good starting platform? etc.

Any idea....

[penagate]

Since you've listed MySQL, PHP, and Apache, let me point you to Xampp:
apachefriends.org/en/xampp.html

It is a great web server package which combines the three (among other things) nicely. Very easy to install.

You can also use MySQL with .NET, for desktop apps. If you install Xampp and then the connectivity drivers available from the mysql website then you can have a minimal-components solution.

[easymoney]

Thanks for your input. I am looking into the info you posted.

Anyone else want to chime in on the topic?

[Merrion]

There is an upsizing tool for Access->SQL server.
Works pretty well. (You might also consider adding a "timestamp" field to all tables - that way if you import them in to access as linked tables they can be updated from that front end.)