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
Anybody who has developed with MySQL in the past five years, especially on Windows, knows the poor mans tools that MySQL has presented to database administrators and developers. This is especially galling given the ever higher quality tools presented first by Oracle and Sybase, then SQL Server and lately IBM DB2. The screenshot below shows the old and rococo WinAdmin utility for MySQL for use in Windows. Don't get me wrong - WinAdmin was useful; t just stopped short from being really helpful. For example, as seen in the screenshot below you could view the MySQL table schemas but not change or create new ones.
Solution For MySQL
Quest Software, a MySQL Strategic Partner, provides innovative solutions with product depth, community involvement and database expertise. Whether part of a corporate enterprise migrating from an existing 24x7 production database, or managing databases as part of the LAMP (Linux, Apache, MySQL, Perl Python or PHP) stack, developers and DBAs have put their confidence in the depth of Quest?s tools to get the job done. And get it done quickly. With more than five million production databases, MySQL is leading the way for open source databases. As companies look to MySQL for their open source strategy, no matter how complex or simple the task, from migrating platforms to querying the database, Quest is committed to providing the tools and expertise to deliver, manage and control MySQL environments that run on Windows ? enabling you to take MySQL to the next level.
MySQL Tool Tutorial
MySQL is a client-server DBMS, and so to use MySQL you'll need a client, an application that you'd use to interact with MySQL (giving it commands to be executed). There are lots of client application options, but when learning MySQL (and indeed, when writing and testing MySQL scripts) you are best off using a utility designed for just that purpose. And there are three tools in particular that warrant specific mention. Every MySQL installation comes with a simple command-line utility called mysql. This utility does not have any drop-down menus, fancy user interfaces, mouse support, or anything like that.