MySQL Forums
Forum List  »  Microsoft SQL Server

Re: New Migration Article
Posted by: Mike Hillyer
Date: July 12, 2004 10:41AM

bob lambert wrote:
> Mike
> Thanks for the info. Regardless if I choose MySQL
> over MSSQL I am in for a lot of work converting
> all the VB code behind my access 2002 application
> and forms am I not ? I guess all that code would
> end up on the server side of the equation, but I
> am confused as to where it goes - I mean now its
> carried along in my access db and neatly tied to
> individual forms. If I leave that (and
> essentially leave MS-dom), what s/w do I use and
> how do I collect/manage it all ? Does MYSQL have
> a similar s/w interface to do the equivalent of
> all the VB code I wrote in Access, and what
> language is it ? Or do I have to buy some other
> s/w ? (I do have std at home now).
> Thanks a bunch
> Bob Lambert

You are right Bob, no matter what database you choose you are going to have a lot of work migrating your existing application to the web. That being said, any functions you wrote in VB could possibly be migrated to ASP without much effort, so if you used reusable functions and classes you will be ahead. You could use VB.NET and ASP.NET with either MSSQL or MySQL, and try to import as much of the code as possible. MySQL has no built in programming interface, but there are languages such as PHP available which work well at exposing MySQL data (or SQL Server data for that matter) to the internet.

Mike Hillyer, Technical Writer
Office: +1 403-380-6535


"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine

Options: ReplyQuote

Written By
July 08, 2004 12:30PM
July 09, 2004 10:18PM
July 12, 2004 08:30AM
July 12, 2004 10:33AM
Re: New Migration Article
July 12, 2004 10:41AM
July 16, 2004 10:42AM
July 17, 2004 03:58PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.