Forum Moderators: phranque

Message Too Old, No Replies

Script to switch to mySQL

does something like this exist?

         

too much information

3:06 pm on Jan 5, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I am currently trying to redevelop my site using mySQL instead of Access for the database. In the mean time I would like to switch the current system to mySQL but moving all of that data would be a nightmare.

Does anyone know of a script or program that can transfer the data for me? (I can handle the connection string changes on my own)

giggle

3:59 pm on Jan 5, 2005 (gmt 0)

10+ Year Member



Microsoft SQL Server comes with an Import and Export Data program that can convert data from Access to SQL or vice versa.

txbakers

3:15 am on Jan 7, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



do a google search on "access2mysql" and you might find something.

I never did these, I just made text files and uploaded them into mySQL. It was pretty easy actually.