How to transfer my MYSQL table to derby database?

Question

I am trying to use Derby with eclipse, do I need to have Java EE eclipse? Also is there a way to import a MYSQL table into a derby database? Sorry if these questions are really basic, I'm new to derby and I need it to work fast (project today, etc.), Thanks

Answer 1

You can export MySql to a CSV file: http://www.debianadmin.com/export-mysql-database-into-a-csv-file.html

and import it into the derby database: http://www.razorsql.com/features/derby_import.html

Answer 2

http://db.apache.org/derby/integrate/db_ddlutils.html

DdlUtils, a subproject of Apache DB, provides utilities for creating and working with database definition files (DDL) and for exporting and importing XML data using Ant tasks or programmatically in Java.

Among other uses, DdlUtils makes it easy to migrate from one database provider to another. This document provides a simple example of using DdlUtils to migrate a database to Derby using DdlUtils Ant tasks.

In this example, Derby is the source and target database because Derby is easily accessible and knows what the author knows, but can be used with any of the databases supported by DdlUtils. Usually there is an even simpler way to transfer the Derby database from one machine to another: just copy the Derby database files. If the source and target computers use official versions of Derby, you do not need to export / import the schema and data, even for machines with different architectures, since the files that make up the Derby database are platform independent. However, if you want to upgrade the Derby database to or from the alpha version of Derby to the official version, you must export the schema and data because Derby does not support updating the alpha database. DdlUtils facilitates this migration.

Answer 3

You can import CSV data into Derby with something like:

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

as described in this post.

Following are the Derby docs for the arguments.

No need to buy anything;)