Database Export Tool - Export Databases, Tables, and Queries

The Database Export Tool allows users to export single tables, query results, or all tables in a database and/or schema as a delimited file, insert statements, HTML, XML, Excel, and Text formats.

Exporting Options

The Export Tool gives the following options:

Escape Single Quotes: Select this box if you would like single quotes to be escaped. This is useful if exporting in a format that will be executed as SQL.

Escape Character: The character to use if escaping single quotes.

Include Column Names: Select this option if you would like the column names to be included in the exported data.

Convert Nulls to Blanks - If the export type selected is not SQL Insert, then this option will convert null values to blanks in the exported data.

Wrap Values in Quotes when Delimiter Found in Value - If you are exporting delimited data, and there is a delimiter found in the actual data, this option will wrap the entire data value in quotes. Doing this allows the exported data to be re-imported.

Export Types

Delimited File: This option allows data to be exported using a delimiter. Each column is separted by the specificed delimer. For example, if selecting a comma as the delimiter, the following is an example of the exported data:

1,John,Smith
2,Jane,Doe

If selecting the delimited file option, the user can choose to export data with one line of the export file corresponding to one row of the data, or to combine all data and separate each value with a delimiter.

The "combine all data" option would typically be selected if there are line breaks in the data to be exported.

Insert Statements: This option is not available for query results, but is available if exporting a single table or all tables in a database / schema.

The Insert Statements option allows users to export data as SQL insert statements.

HTML: This option allows users to export data in HTML table format.

XML: This option allows users to export data in XML format.

XLS: This option allows users to export data in Microsoft Excel format.

Text: This option allows users to export data in text format. The Export Tool will attempt to align columns to make them symmetrical.

Export