Table of ContentsPreviousNext

Ispirer             Ispirer

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

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.