MySQL Forums
Forum List  »  Microsoft Access

Re: Thinking about moving!
Posted by: Randall McGarvey
Date: July 27, 2004 07:22AM

Ron,

Perhaps taking one step at a time may be a better approach. For example, I'm thinking about moving as well. I'm currently running ASP with Access. It's quite simple to convert the database piece to mySQL without changing any of the ASP code. Once I have the mySQL software installed and the database transfered, all I do is either set up a new DSN for mySQL or configure the DSN-less connection. Once that is complete, then switching to PHP isolates that change.

I've found that transfering the data is quite simple. Regardless of whether you want to use a DSN, set up DSNs for both the Access and mySQL. Then you can export the data from Access directly into the MySQL DSN. It's surprisingly fast compared to other options I've tried.

Options: ReplyQuote


Subject
Views
Written By
Posted
3704
July 23, 2004 04:46PM
2587
July 24, 2004 02:18AM
2495
July 24, 2004 02:21AM
Re: Thinking about moving!
2620
July 27, 2004 07:22AM


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.