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".
Michael Pavitsky: "SQL Maestro Group provided the kind of services and support for managing PostgreSQL data expected in a true business partnership. Their devotion to customer satisfaction and cost curtailment is a pleasure for PostgreSQL users. I wouldn?t hesitate to recommend PostgreSQL Data Wizard to any of my peers and I know and trust they will surpass all expectations".

More

Add your opinion

PostgreSQL Data Wizard online Help

Prev Return to chapter overview Next

Customizing common options

All data sources and target tables are specified on previous steps, it's time to define the import process.

 

Logging

Use this option to be informed about all the actions occurred during the import. The log file name may contain current timestamp with the %ts:TIMESTAMP_FORMAT% string.

Examples of valid log file names:

dbname_import_%ts:yyyy_mm_dd%.log

import_%ts:yyyy_mm_dd_hh_mm%_mysql.log

%ts:yyyy_mm_dd_hh_mm_ss%.log

 

Email notification

To send a log file as an email attachment after each import process or in case of an occurred error, specify settings of email(s) to be sent: parameters of your SMTP server, email addresses, subject and body text.

 

 

Scripts

There are many cases where the import process is necessary to correct with additional scripts. So to disable table indexes before the importing, specify the corresponding scripts to be executed before and after the process.

 

The typical example of usage of the Before each table and After each table scripts is the import data to autoincrement columns of several tables. In this case it's neseccary to set the corresponding scripts:

SET IDENTITY_INSERT %table_name% ON

and

SET IDENTITY_INSERT %table_name% OFF

to be executed before and after import data to each table correspondingly.

 

Import mode

If the Update existing records option is turned ON, the records will be either updated or inserted: an UPDATE will be performed when a target row exists in the table and an INSERT is performed when the target row does not exist.

 

Import Data Wizard supports the COPY FROM command to insert data to the table. This feature can speed up the import process up to 10 times so it is recommended to use it always if possible. Uncheck this option to use INSERT statements instead.

 

Reorder

PostgreSQL Data Wizard arranges target tables on import by dependencies to inserted records in the correct order. To reorder target tables manually, follow the corresponding button.



Prev Return to chapter overview Next