0

I have used many tools but they not work correctly and when i start migration process, they generate the Null value error. Also I have tried to migrate usingSql script to insert data in derby table but they not work it.

So basically my question is: How do we migrate Data From one DB to Other?

Yash Pathak
  • 9
  • 1
  • 5
  • 3
    Welcome to Stack Overflow! You can take the [tour] first and learn [ask] a good question and create a [mcve]. That makes it easier for us to help you. – Katie Jan 11 '17 at 11:27

1 Answers1

1

A very simple way would be to Export Mysql Database into a CSV File and than,

import it to derby database using Derby Import Tool.

you can also import your CSV data into Derby with something like this as explained in this blog:

CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'Sampletable', 'Sampledata.csv',  ';', null, null, 0);

UPDATE: Also refer Jad answer as well as the posts: mysql dump into derby and MySQL dump .sql script and import to an apache derby.

You can read this article which says: Install the most current official release of Apache Derby.

You can also get a specific version here.

Community
  • 1
  • 1
StackUseR
  • 884
  • 1
  • 11
  • 40
  • i want to try this one but i have migration multiple data approx 250 table , i think Derby import tool migrate only one Table and i have download the import tool from here http://razorsql.com/download_win.html this one correct ? i want to create derby database in netbeans. – Yash Pathak Jan 11 '17 at 12:15
  • if derby database tools install any else not in netbeans so if possible send me the Download link. – Yash Pathak Jan 11 '17 at 12:18