Create Dump Dialog Help
This wizard serves to create a database dump. Valentina studio uses the same wizard to create a dump for different database engines. If some database provides additional dump options, the wizard shows them on the separate page.
Objects
If the dump wizard was called for the table or schema you can select few items that will be dumped.
The list filter is available only in the Pro version.
Dump Type
On this page, you should define a type and content of output data.
Excel 1997-2004 (.xls) – If selected, then dump will be created in XLS format.
Excel (.xlsx) – If selected, then dump will be created in XLSX format.
HTML – If selected, then dump will be created in
HTML format.
JSON – If selected, then dump will be created in JSON format.
SQL – If selected, then dump will contains SQL quires.
XML – If selected, then dump will be created in XML format.
Structure Only – If selected, then the dump will contain information only about database structure.
Structure And Records – If selected, then the dump will contain the information about the database structure and all data in the tables.
Records Only – If selected, then the dump will contain only data from tables.
PostgreSQL has more formats for dump:
Custom – Create custom-format archive.
Directory – Create a directory with one file for each table and blob being dumped, plus a so-called Table of Contents file describing the dumped objects in a machine-readable format.
Tar – Create a tar-format archive.
Options
Several database engines are provides advanced dump options:
PostgreSQL dump options:
Options: Queries
Include CREATE DATABASE statement – If ON then the CREATE DATABASE statement will be added to the dump.
Clean before restore – Clean (drop) database objects prior to outputting the commands for creating them.
Use column inserts – Dump data as INSERT commands with explicit column names
(INSERT INTO TABLE_NAME (column_name, ...) VALUES ...)
Use INSERT commands – Dump data as INSERT commands (rather than COPY).
Options: Save
Owner – Dump commands to set ownership of objects.
Privilege – Dump of access privileges.
Tablespace – Dump commands to select tablespaces.
Unlogged table data – Dump the contents of unlogged tables.
Options: Misc
Disable triggers – Include commands to temporarily disable triggers on the target tables while the data is reloaded.
Disable '$' quoting – Disable the use of dollar quoting for function bodies.
Use SET SESSION AUTHORIZATION – USE SQL-standard SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to determine object ownership.
With OID's – Dump object identifiers (OIDs) as part of the data for every table.
Verbose – Output detailed object comments and start/stop times to the dump file, and progress messages to standard error.
Force double quotes on identifiers – Force quoting of all identifiers.
Dump utility version – version of the pg_dump to create a dump. The drop-down menu allows the user to manage versions of the pg_dump utility. Detailed description of version management is described here.
MySQL dump options:
Disable triggers – Include commands to temporarily disable triggers on the target tables while the data is reloaded.
Disable '$' quoting – Disable the use of dollar quoting for function bodies.
Use SET SESSION AUTHORIZATION – USE SQL-standard SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to determine object ownership.
With OID's – Dump object identifiers (OIDs) as part of the data for every table.
Verbose – Output detailed object comments and start/stop times to the dump file, and progress messages to standard error.
Force double quotes on identifiers – Force quoting of all identifiers.
Destination File
At this page you should define a destination file that will contain the dump.
Destination File – The path to the file, that will contain a dump.
Encoding – The encoding of the dump.
Result Page
The last wizard page shows the dumping progress and results.
