This week's book giveaway is in the NodeJS forum.
We're giving away four copies of Serverless Applications with Node.js and have Slobodan Stojanovic & Aleksandar Simovic on-line!
See this thread for details.
Win a copy of Serverless Applications with Node.js this week in the NodeJS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • paul wheaton
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Ron McLeod
  • Tim Moores
  • salvin francis
  • Carey Brown
  • Tim Holloway
  • Frits Walraven
  • Vijitha Kumara

What is the best way to migrate my old database to the new schema ?  RSS feed

Ranch Hand
Posts: 486
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am new in 'data-migration' and I think it is best seek out advice with the experts before I get my hands dirty.

Basically, I have a database which has a few thousands of rows and just a single table.

With the new schema which has a many to many relationship(many tables), I would need to migrate the data to my new schema.

Can I know if there is/are a free tool(s) out there to migrate the data ?

I will be using MYSQL server 8.0.14.

Running on Windows 10 OS.

Any opinions are most welcomed.

author & internet detective
Posts: 39208
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's not a lot of data so whatever you choose, it'll be quick.

Since you are migrating between schemas, you need to express how the data should change. While I imagine that data warehouse tools can do this, it seems like overkill for your scenario. I recommend just writing a program to do it.
Posts: 1661
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are DB tools out there that will let you drag and drop tables between schemas. Navicat, for example, will let you do that.

Otherwise, for data migration, especially if I know it may need to run more than once, I just whip up a little JDBC logic and even schedule it if necessary.


- mike
Posts: 20580
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, one approach would be to use an ETL tool like Talend or Pentaho DI (Kettle). For myself, I'd probably dump the single table using mysqldump and load it into the new schema, use a set of sql commands to plunder it into loading the new tables, then drop the copy of the original single table when everything's been place in its new home. For best results, don't index or set foreign keys until AFTER all the new tables have been loaded.
Mo-om! You're embarassing me! Can you just read a tiny ad like a normal person?
global solutions you can do at home or in your backyard
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!