Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Josh Armstrong: "I absolutely love this software! It will me take our migration time down by an order of magnitude. It has especially helped with my indexing as my database contains many complex ones".
Paul Gibson: "The strength of SQL Maestro Group's technical skills and support allow us to recommend PostgreSQL Maestro and PostgreSQL Data Wizard to others. Above that, they provide us with amazing value (great service, fair price) in comparison with every other software development teams that I've researched".

More

Add your opinion

Customers
Download Buy

PostgreSQL Data Wizard online Help

Prev Return to chapter overview Next

Customizing common dump options

Use multi-row INSERT statements/Use separate single-row statements

Use these options to define type of INSERT statements to be generated. To create a smaller dump file and speed up inserts when the file is reloaded, select the multi-row inserts and specify the commits' frequency.

 

Statement syntax

This allows you to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as MySQL, PostgreSQL, SQL Server, Oracle, Firebird, or SQLite.

 

Add the "Create table" statement to the top of the dump

By default the dump file contains only INSERT statements. To include the SQL definition of the source table, check the corresponding box.

 

Output

Specify the output directory for the result files and the files encoding.

 



Prev Return to chapter overview Next