Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    2

    Question Unanswered: migrating to db with different structure

    Hi.

    Let's say I got a mysql database A filled with lots of tables and content of all sorts. And I got a database B, which is somewhat similar to A, but has a slightly different structure. I now want to move the contents of database A into database B.

    My question is: does anyone happen to know a tool or something, where I can set up some rules, that make this migration process run smooth without any problems? Like, where I could tell the tool something such as "if table name = XYZ then add a new field to each index". Just a way that lets me define on how to deal with the slight structural differences between the two databases.

    Thanks for any help.

  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    If you do not want to create your own select/insert from from_database_table to to_database_table selecting only the columns you want, example: Oracle Database Link - MySQL Equivalent? - Stack Overflow
    Then check out these utilities/tools:
    http://www.navicat.com/products/navicat-for-mysql
    Migration to MySQL - MySQLUtils.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •