This week's book giveaway is in the XML and Related Technologies forum.
We're giving away four copies of Java XML & JSON and have Jeff Friesen on-line!
See this thread for details.
Win a copy of Java XML & JSON this week in the XML and Related Technologies 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 ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Devaka Cooray
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

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

 
Ranch Hand
Posts: 474
  • 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.

Tks.
 
author & internet detective
Posts: 39128
723
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.
 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!