Question: I'm using derby for development in eclipse. Is it possible to dump a table from MySQL and use it for derby in some way? I know that ddl & dml are different for both dbms but I'm looking for a way, other than dump/export, that would be appropriate.

Answer: 
Unless you need to automate the process, the "[DBCopy Plugin for SQuirreL SQL Client](http://dbcopyplugin.sourceforge.net/)" tool might work for you. There are probably other tools, but that's the one I know (however never used myself).

If you do need to automate the process, and if you don't care so much about the DDL, then I would probably use CSV.
To take over the data from MySQL (production environment) to Derby (development environment), I use following command:

```
mysqldump -u root -h 127.0.0.1 --compatible=ansi --complete-insert --skip-add-drop-table --skip-add-locks --skip-comments --skip-disable-keys --skip-set-charset --no-create-info dbname > export.sql

```

But specially in Derby, I have also the problem of disalbing constraints. Therefore, the insert statements have to be in the correct order!