-
October 23rd, 2012, 08:15 PM
#1
To Migrate Access db to MySQL
Hi everyone.
I need to convert an Access 2007 database to MySQL 5.5. The Access database has thirteen tables. My first thought on how to do this is to create the MySQL database and tables by hand and to write a program that connects to both databases, which gets the data from the Access database and inserts it into the MySQL database. Is this the way you folks would go about doing this? Or is there something that I'm missing that can make some or all of the steps that I said easier? Please advise me on how to handle this project.
-
October 24th, 2012, 05:24 AM
#2
Re: To Migrate Access db to MySQL
Well, it the database has only thirteen tables then you can convert it as you want without much problems.
Othewise, you could try some of the existing tools for such a conversion:
http://www.bullzip.com/products/a2m/info.php
http://dbconvert.com/index.php?DB=6&...FYxa3god63oAJQ
http://www.brothersoft.com/access-to...re-489569.html
...
Victor Nijegorodov
-
October 24th, 2012, 02:57 PM
#3
Re: To Migrate Access db to MySQL
Thanks Victor.
I'll let you and the brotherhood know how it goes
-
October 30th, 2012, 09:48 AM
#4
Re: To Migrate Access db to MySQL
I used the bullzip link. It was sooo easy to use the program from that website and it converted the Access database to mysql perfectly. Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|