Re: Thinking about moving!

[Randall McGarvey]

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.