- 12 Extending The MySQL Migration Toolkit
- 12.1 Introduction
- 12.2 Architecture of the MySQL Migration Toolkit
- 12.3 The Modular Migration Process
- 12.4 Tools Required to Extend the MySQL Migration Toolkit
The MySQL Migration Toolkit is built on three primary modules: reverse engineer modules, migration modules, and transformation modules.
Reverse engineering modules retrieve the schema information from
the source database and return GRT objects that describe the
schema. Reverse engineering modules will have a name similar to
ReverseEngineeringAccess.
Migration modules convert the source database GRT objects to MySQL
GRT objects and then handle the bulk data transfer between the
source and MySQL databases. Migration modules will have a name
similar to MigrationAccess.
Transformation modules convert the MySQL GRT objects into the
actual SQL statements used to create objects such as tables and
views on the target MySQL server. Transformation modules will have
a name similar to TransformationMySQL.
Transformation modules are supplied by the MySQL GUI team and need
not be created to add support for a new source database.
All modules are derived from base classes whose methods can be rewritten to match the new source database.
