MySQL Migration Toolkit

The MySQL Migration Toolkit is a powerful framework that enables you to quickly migrate your proprietary databases to MySQL. Using a Wizard-driven interface, the MySQL Migration Toolkit implements a proven methodology and walks you through the necessary steps to successfully complete a database migration project. By using the Migration Toolkit, you will be able to

• Quickly migrate your databases including schema objects such as tables and views from Oracle, Microsoft SQL Server, Microsoft Access and other databases
• Reduce risk by using a proven migration methodology
• Save costs by using an integrated tool set to increase productivity
• Eliminate days of work required to manually write, test and debug scripts
• Customize the migration process and adapt the tool to your needs

Watch the Migration Toolkit in Action:

• SQL Server Migration Tutorial »
• Oracle Migration »
• Access Migration »

MySQL Migration Methodology Reduces Risk

The MySQL Migration Toolkit implements a proven 8 step migration methodology that also gives you complete control over the migration process to ensure success. The toolkit walks you step by step through migrating your application from object selection and mapping to schema creation, data mapping, and data transfer. By using a proven methodology you can reduce the risk associated with complex migration projects.

Intuitive, Easy to Use Environment Improves Productivity

The MySQL Migration Toolkit provides a Wizard driven interface that automates manual migration tasks. The Visual Environment also gives you the control to edit SQL statements for objects that require manual intervention. By combining a proven migration methodology with a powerful Wizard driven interface you will avoid the high-risk and high cost of manually migrating your database.

Remote Server to Server Migration

The MySQL Migration Toolkit supports Server to Server migration eliminating a common bottleneck present in other migration solutions. You have the flexibility to run the MySQL Migration Toolkit on your desktop while migrating database applications between remote servers. The migration is not proxied through your desktop which means you can perform a migration remotely.

Migration of Database Objects including Schema, Stored Procedures, Triggers and Views

The MySQL Migration Toolkit will migrate or map objects from select proprietary database formats to MySQL including the following object types:

• Tables
• Indexes
• Views
• Assists with Stored Procedure Migration
• Assists with Trigger Migration

The toolkit enables you to use standard migration methods or you can easily create your own using the Java language. Using the standard migration methods several parameters can be tuned including: based on the parameters you require such as:

• Transactional / High-speed data handlers
• Foreign Key constraints
• Mult-language support (UTF8)
• User defined settings

Furthermore, you can transfer data online in real-time or you can store a snapshot of the data and schedule a future transfer offline using a SQL script for execution later. This option can also be used to create a backup copy of the stored data and put the application back into its original state.

Extensible Modular Architecture

The MySQL Migration Toolkit includes multiple migration modules for databases including Oracle, Microsoft SQL Server, Microsoft Access. The extensible architecture gives users the flexibility to customize existing modules to also migrate data from other proprietary database products. In addition, users can extend the base modules to support additional data types such as geographical data.

Optimize the Migration Process

The MySQL Migration Toolkit gives you the power to optimize the migration process by manually editing the script of generated objects. For example, users can migrate the database schema with the Wizard Interface once and use part of the generated script to migrate the data on a daily or as needed basis.

Standards-based Platform Independent Migration

The MySQL Migration Toolkit uses a platform independent agent written in Java so you can migrate databases to MySQL on multiple platforms. For example, you can migrate an Oracle database running on Solaris to a MySQL Server running on Linux to significantly reduce your database Total Cost of Ownership (TCO). Standards-based JDBC connectivity is used to connect to the data source. Users have the flexibility to add native methods written in C to improve performance.

Comprehensive Summary Reports

The MySQL Migration Toolkit generates comprehensive reports that provide detailed information about the number of objects (tables, views, etc) that have been migrated. Use these reports to identify the objects that have been migrated successfully and those that require additional attention.