How to Migrate Data into Existing Database

If you want to overwrite the table definitions, you can specify GENERATE_DROP_STATEMENTS_WZD option of section [_WZD_COMMON] with 'Yes' value in SQLWays.

To load data into an existing table structure without recreating it, you need to disable DDL generation so that SQLWays transfers data only.
The GENERATE_DDL_SCRIPTS option controls DDL generation. You can find this option on the 'Settings' page in the [_WZD_COMMON] section. Please set its value to 'No'.
Next, ensure that the EXPORT_DATA option of [_WZD_COMMON] section is set to 'Yes', and then run the migration.

With these settings, SQLWays will extract, convert, and load only the data, without generating or applying object definitions.

NOTICE: Please note, when running data only migration, the SQLWays will append the data into table so you need to be sure that target table doesn't contain the same rows and there are no constraints in the database that will not allow to push the data into tables in your target database. Otherwise, you will have to disable such constraints in your database before the migration and enable them after the migration process is finished.

More details about options of section [_WZD_COMMON] please see here.

If you have any other questions, please feel free to contact us at support@ispirer.com