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

Subscribe to our news
Partners
Testimonials
Richard Finner: "Thanks. I have paid my money. I experimented with many trial copies of similar programs and found your SQLite Data Wizard to be ingenious yet simple. It suits my working style".
Stephan Hennekens: "Excelent tools!!! Suberb design and interface. I have just pumped an Access database into a SQLite database. All the data including the indexes with just a few clicks".

More

Add your opinion

Customers
Download Buy

SQLite Data Wizard online Help

Prev Return to chapter overview Next

Setting transfer options

Transferring

•To generate the objects directly in the target database, check the Generate database objects box (do not activate this option if you want only generate an SQL script).

 

•To import data to the selected tables, turn the Insert records into database option "ON".

 

The Script generation options allows you to generate SQL scripts to a file to be executed later using any appropriate software product.

•To save SQL definitions of the target objects to .sql file, check Save metadata script to file and specify the file name.

 

•To add to the file INSERT statements, check the corresponding box.

 

Scripts

Follow the Customize scripts link to specify SQL scripts to be executed during the transfer. The scripts are executed as follows:
 

•After connect: after connecting to the target database but before creating schema objects;
•Before data importing: after creating schema objects but before transferring tables' data;
•After pumping: after completing the deal.

 

Logging

This option group allows to enable/disable logging of the pump process.

 

Templates

On this step you can save all parameters that have been set during the wizard session to a template file for a further using. To do so, click More > Save Template.

 



Prev Return to chapter overview Next