CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2009
    Posts
    596

    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.

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,395

    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

  3. #3
    Join Date
    Dec 2009
    Posts
    596

    Re: To Migrate Access db to MySQL

    Thanks Victor.

    I'll let you and the brotherhood know how it goes

  4. #4
    Join Date
    Dec 2009
    Posts
    596

    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
  •  





Click Here to Expand Forum to Full Width

Featured