ASA Data Wizard online Help

Return to chapter overview

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.

Return to chapter overview

Company news

Feb 11, 2016

Data Wizards are updated to version 16.2

New version features two new wizards for unloading and loading BLOB data, updated Data Import tools, command-line builders for all the wizards as well as some other new features.

Dec 6, 2013

Data Wizards advanced to version 13.12

New version features updated Data Import and SQL Dump tools, data export to JSON format, redesigned Start Page, and some other useful things.

Feb 11, 2013

The Connection String Reference has been updated

Features up-to-date list of ODBC drivers / OLE DB providers and appropriate connection strings AnySQL Maestro has been examined with.

More news

Feature of the day

Templates

Each wizard included in ASA Data Wizard allows you to save its current settings as a template for future use.

Tray Agent

Tray agent can execute tasks scheduled in ASA Data Wizard, but does not require Data Wizard to be running at the current time.

ASA Data Wizard online Help

Customizing common dump options