数据迁移工具mysql_MySQL Visual Database迁移工具

数据迁移工具mysql

Nothing like good timing. I am working on a project with a company right now who has elected to migrate more than 30 Microsoft Access databases of various size and complexity used internally and on the web to MySQL 4.

恰到好处的时机。 我现在正在与一家公司合作进行一个项目，该公司选择将内部和Web上使用的30多种大小和复杂程度不同的Microsoft Access数据库迁移到MySQL 4。

To my own and all of our good fortunes — MySQL AB today announced the free availability of the MySQL Migration Suite. This GUI toolset will allow for comprehensive migration from Oracle and Access initially (with Microsoft SQL Server, IBM DB 2 and others to follow) and is released under the GPL 2 license.

出于我自己以及我们所有的好运，MySQL AB今天宣布免费提供MySQL Migration Suite 。 该GUI工具集将允许最初从Oracle和Access进行全面迁移(随后是Microsoft SQL Server，IBM DB 2和其他)，并根据GPL 2许可发布。

Better yet it is written in Java, meaning one can perform cross-platform database migrations (Unix to Windows, Solaris to Linux and so on). The Suite utilizes time-tested methodologies and a Wizard guide to cover all the basics of migration as well as stored procedures and triggers.

更好的是，它是用Java编写的，这意味着可以执行跨平台的数据库迁移(从Unix到Windows，从Solaris到Linux等)。 该套件利用久经考验的方法和向导指南来涵盖迁移的所有基本知识以及存储过程和触发器。

With its handy reporting capabilities, audits and due diligence can be performed on migrations as they are expedited to insure no missing links are passed over.

凭借其便捷的报告功能，可以加快迁移过程的审核和尽职调查的速度，以确保不会遗漏任何丢失的链接。

I am going to do some test migrations in my development environment as taking anything brand new into production can be interesting to say the least. However – this looks to save some serious time and potential headaches.

我将在开发环境中进行一些测试迁移，因为至少可以说将任何全新的产品投入生产。 但是，这看起来可以节省一些时间和潜在的麻烦。

Breaking with my habit of not mentioning the products I use – normally I have used Navicat during the migration process as it also spans multiple operating systems (specifically Linux, Mac and Windows). It has done its job superbly – however – the MySQL Migration Suite being GPL open source – I absolutely have to give it a run through the paces to see how it performs.

摒弃不提我使用的产品的习惯–通常，我在迁移过程中使用过Navicat，因为它也跨多个操作系统(特别是Linux，Mac和Windows)。 它出色地完成了自己的工作-但是-MySQL迁移套件是GPL开源的-我绝对必须逐步了解它的性能。

With Navicat 7 pending release and adding several features I felt were missing from version 6 – it may keep me from adopting the MySQL Suite. However, it will not keep me from giving it a good bench test on this current Access project!

Navicat 7即将发布，并添加了一些我觉得版本6缺少的功能–这可能使我无法采用MySQL套件。 但是，这并不能阻止我对当前的Access项目进行良好的基准测试！

For those who also work with MySQL in a commercial capacity (paying for MySQL services or licensing) — the company is also offering quite an appealing $1500 discount on their own consulting services for getting a 5-day kickstart with MySQL 5 deployments.

对于那些也以商业身份使用MySQL的人(为MySQL服务或许可付费)，该公司还将为他们的咨询服务提供相当诱人的1500美元折扣，以在5天内启动MySQL 5部署。

翻译自: https://www.sitepoint.com/mysql-visual-database-migration-tool/

数据迁移工具mysql