upgrade from ms access to mysql
hi
I have a friend who has asked me to help him improve his web site. Currently he has some data in MS access with the site using Cold Fusion but now the level of traffic dictates upscaling the database.
I was hoping for help with either of the following
- what is the easiest way to port the data from MS access to mysql?
- will the Cold Fusion scripts need to be modified much to work the new data source?
any help appreciated
greg
Peter J. Boettcher posted this at 12:43 — 28th June 2001.
They have: 812 posts
Joined: Feb 2000
I'm don't know for certain, but I would think that mySQL includes filters for importing data from other sources. At the very least it should be able to import from a text file. So you could save your Access database as a text file and import it that way.
As for the CF scripting, there will have to be some changes, but it shouldn't have to be rewritten entirely.
PJ | Are we there yet?
pjboettcher.com
Adrian J. Moreno posted this at 19:59 — 25th July 2001.
They have: 19 posts
Joined: Jul 2001
Check out http://www.mysql.com for more info. Here's a direct link to db converters - http://www.mysql.com/doc/S/E/SEC583.html
There are two in particular to check out:
exportsql.txt and access_to_mysql.txt. The first one is more configurable from the description.
As for the CF scripts, you shouldn't have too hard a time. You might have some small SQL syntax to change, but the rest should be fine. However, is your friend used instead of INSERT INTO for sql queries you may have some work ahead of you. It's much worse converting from SQL Server to mySQL.
A great resource I keep close at hand is O'reilly's SQL in a Nutshell. It has all the datatype differences of the commons dbs as well as syntax differences.
ravijp posted this at 04:23 — 14th August 2001.
He has: 39 posts
Joined: Aug 2001
This is a tool which lets you import Access 2000 tables into MySQL.
I've used it extensively.
Works great, but has a nag screen which pauses the entire interface for 10 seconds every so many minutes. It can be gotten rid of by paying a few $$s.
This is where you can find the s/w :
http://www.mysql.com/downloads/os-win32.html
Regarding changes to your code, if the code is object oriented, then by just changing the code pertaining to the db access (drivers etc) from Access to MySQL should take care of your situation.
I'm a Java/PHP/Perl specialist. So, I don't know too much about ColdFusion.
My 3.5 cents...
Ravi
Make up to $45 Per Sale
One of the most amazing suite of scripts for the Non-programming Web Site Owner and Webmaster.
http://www.WebmasterInABox.net/
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.