Export Objects and Data

SQLife has separate workflows for exporting database object definitions and table/query data.

Export Object Definitions

1. Open a database connection.
2. Open Database -> Export Object, or use the object navigator context menu when available.
3. Select the schema and filter the object list.
4. Add the objects to the export list.
5. Choose the object options and select Export.
6. Choose the output file in the save dialog.

The object exporter generates SQL definitions. The exact objects and clauses depend on the database dialect and the privileges of the connected user. Review the generated SQL before applying it to another database.

Export Table Data

Open Database -> Export Data, or start the export from a table or a data-view result. The exporter shows available tables with schema, comment, last-change time, and row-count columns. Use the filter box, select tables, and move them to the export list.

Formats

The current desktop exporter supports:

• SQL: data statements suitable for loading into a database.
• Excel: workbook output.
• CSV: comma-separated text.
• TSV: tab-separated text.
• Bulk: database bulk-load output where supported.

JSON, XML, HTML, Markdown, and PNG are not data-export formats in the current exporter. Query-result sharing supports HTML and PNG separately; see Other Features.

Options

The available controls depend on the selected format. Current options include:

• Single file: write selected tables to one file where supported.
• ZIP file: package generated files into a ZIP archive.
• Escape line break: escape line breaks in text output.
• Ignore binary column: skip binary columns.
• Constraints control: include constraint handling in SQL output.
• Ignore schema: omit schema qualification.
• Truncate table: include a truncate operation before data output where supported.
• Use PK as ID: use the primary key as the generated row identifier where supported.
• Binary to Base64: encode binary values as Base64. This is unavailable when binary columns are ignored.
• Ignore long text column: skip long text columns.
• Delimiter and quote: enable and configure separators for delimited output.
• Commit every: add a commit interval. The default interval is 5,000 rows/statements.

Do not enable truncate or constraint controls without checking the generated SQL and the target database. These options can change or remove data and can affect referential integrity.

Exporting a Data-View Result

1. Execute a query or open table data.
2. Click the data-view Export action.
3. Select the format and output options.
4. Choose the destination file.

Exporting from a data view exports the current result context. Use Export Data when selecting multiple tables or configuring table-level options.

Troubleshooting

• An empty table list usually means the wrong schema is selected or the user lacks metadata privileges.
• If binary or long-text values are missing, review the ignore-column options.
• If delimited output is misaligned, verify delimiter, quote, and line-break settings.
• If generated SQL cannot be loaded, inspect schema qualification, constraints, and commit settings for the target database dialect.

See Import Data for the reverse workflow.