Migrating data from an external RDBMS to MySQL is an eight step process :
Source/Target Selection
: In the first step
you specify the connection parameters for the source and target
database servers.
Object Selection
: In the second step you
select the objects (tables, views, stored procedures) that will
be migrated.
Object Mapping
: In the third step you choose
the method used for mapping and transforming the objects.
Manual Editing
: In the fourth step you can
manually edit the new objects to ensure a proper transformation.
Schema Creation
: In the fifth step the
MySQL Migration Toolkit creates the transformed object on the target
MySQL server.
Data Mapping
: In the sixth step you specify
any changes that need to be made to the data as it is migrated.
Bulk Transfer
: In the seventh step the
MySQL Migration Toolkit transfers the data from the source server to
the target server.
Summary
: In the eighth and final step the
MySQL Migration Toolkit creates a summary report of the migration
process for you to review.
Each of these sections will be covered in more detail in the coming chapters.