La Base de Données Open Source la plus Populaire au Monde
Tél: 01 70 61 48 95
Tél: +33 1 70 61 48 95 (de l'étranger)
USA Subscription Renewals: +1-866-830-4410
SQL Server Migration Tutorial
Watch this clip to see how a MSSQL Server Database is migrated
Oracle Migration Tutorial
Watch this clip to see how an Oracle Database is migrated
Access Migration Tutorial
Watch this clip to see how an Access Database is migrated
Découvrez les nouvelles versions de MySQL, les articles techniques, les
événements, etc.
Abonnez-vous à la lettre d'information mensuelle de MySQL !
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
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.
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.
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.
The MySQL Migration Toolkit will migrate or map objects from select proprietary database formats to MySQL including the following object types:
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:
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.
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.
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.
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.
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.