|
|
Ispirer SQLWays Database Migration Software
Importing Tables
This chapter describes importing tables to the target database using SQLWays.
Importing tables that already exist in the database
Tables that you import may already exist in the target database. For example, tables might be created by another tool and you use SQLWays to import data only. Or you perform the migration process several times, and after first migration all tables exist in the target database.
In this case, you may want to drop tables before importing them again.
SQLWays has the option to generate the DROP TABLE statement before each CREATE TABLE statement. This option allows you to drop the table before re-creating it.
To generate the DROP TABLE statement
Executing a DROP TABLE statement in some databases you may face a problem that the table cannot be dropped. For more information see, Dropping Tables
|
|