Java tool to export db data into csv, json, xml or sql files.
Oracle DB, MySQL DB, PostgreSQL DB, Firebird DB, SQLite DB, Derby DB and HSQL DB are supported.
This tool does NOT include the needed db drivers, but they only have to be downloaded and configured once.
Features
- Export any results of any select statement
- Use a list of tablenames with wildcards to export a bunch of tables
- Optional export in CSV, JSON, XML or SQL(Insert) format
- GUI and console mode
- Use any export encoding
- Use your own csv separator
- Use your own csv string quote
- Individual indentation for JSON and XML
- Option to create files for Blobs and Clobs instead of inline BASE64 code
- Optional zipping output
- Optional structure information exported
- Automatic update of application on user request
- GUI internationalisation(i18n) for english and german
- Password secured preferences in GUI mode
- Connection Test with repeated timing
Follow Java DB CSV Export
You Might Also Like
Rate This Project
Login To Rate This Project
User Reviews
-
Just use simple wildcards (? and/or *) to select the wanted db tables to export. Each will be exported into a separate file. So you only define a directory not a file for destination of the export.
-
Hi, This tool is not working for multiple tables export. can you suggest me how to do this ? Once this feature is implemented then this tool is a 5 start project. Regards, Harikrishna