Feature TourFeature Tour

Export Schema/Database

Previous Next

The Export Schema/Database feature is used to export the DDL for objects such as tables, views, procedures, functions, triggers, packages and package bodies. The target destination can be any of file, clipboard or an SQL Commander editor. You can export all objects or just a selection.
(This feature is available for Oracle, DB2 for LUW, Mimer SQL, PostgreSQL, Sybase ASE, SQL Server, MySQL, JavaDB/Derby, H2, SQLite and Informix)

 
Exporting in CSV format allows export of table data only.
Export Database in CSV
Exporting in HTML format allows export of table data only.
Export Database in HTML
Exporting in SQL format supports export of the DDLs and table data. The output is SQL statements that can be re-executed in DbVisualizer or in a 3:rd party tool.
Export Database in SQL
Exporting in XML format allows export of DDLs and table data.
Export Database in XML
 
Exporting in XLS/XLSX format allows export of table data only. XLS is the old binary format for XLS while the XLSX format is the XML based OOXML format.
Export Database in XLS/XLSX
Exporting in JSON format allows export of table data only.
Export Database in JSON
Feature DbVisualizer
Pro		 DbVisualizer
Free
» Export Formats CSV, HTML, SQL, XML, XLS, XLSX, JSON
» Export object DDLs
» Export Table Data
» Custom Data Format Settings
» Support for BLOB, CLOB and binary data