Export, convert database

Firstly, you have to select the database servers to export the tables from/to
You can select different types of databases, e.g. MSSQL to Oracle or MySQL to MSSQL

Select the source database

Select the target database

If you want to export to the common columns of the available tables, then please deselect the table structure
You can also select the properties of the tables to export by the program (index, trigger, check, foreign key, table properties)
You can select the types of the SQL statements to compile by the program for exporting your data.

A little explanation:
IF.. : generates conditional SQL statements. Only showed for MSSQL.
DELETE ALL: removes all the rows from the target database table
DELETE: removes only those rows from the target database table which exist in the source, too

Using type conversion rules you can set the matching between the data types of the source and the target databases. Usually you can leave it untouched, so you have to accept the type conversion rules recommended by the program.

The program lists the source database tables and defines their identifiers

How to export

During the export, the structure is created and dropped and the data are deleted and copied in the order defined by the foreign keys, too

Right after the export you can compare the source and the target databases

Data comparison

Data comparison has finished