java - Apache Derby: Create SQL Dump with data -


Is there an easy way to create a complete SQL dump from Apache Derby DB? Using the Dblook tool, I managed to dump the database schema into a SQL file, though there is no way to include the data in it.

Derby has procedures for bulk import / export. APP.MESSAGES Table:

  & gt; Ij ij version 10.3 ij & gt; Here's an example of using the  ij  tool to export. Connect 'jdbc: derby: dbName'; Ij & gt; Call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'Message', 'MyFile DL', blank, empty, 'UTF-8');  

Look for your version.

This is not in the format you are asking. In addition, you may have to resort to external devices.


Comments