Oracle releases MySQL migration tools for SQL Server, Windows users

As it prepares to release its Windows-enhanced MySQL 5.6 database, Oracle announced late last week a number of downloadable migration tools to ease the process of converting from Microsoft SQL Server to MySQL, including data conversion, Excel and Windows installer tools.

Oracle is making a big push to convert Microsoft SQL Server users to mySQL.

The Redwood Shores, Calif. database giant has released a new set of migration tools to ease the process of moving to the Windows-based open source database.

The migration tools, which were announced July 25 and will be showcased at MySQL Connect in late September, allows users to more easily migrate data from Microsoft SQL Server to Oracle's MySQL.

"The new migration tool is integrated into MySQL Workbench, which allows the visual design, development and administration of MySQL databases, and now provides a complete solution for migrating Microsoft SQL Server database tables and data to MySQL with less time and effort," Oracle announced in a press release. "With MySQL Workbench, SQL Server developers and DBAs can quickly and easily convert existing applications to run MySQL on Windows as well as Linux and other platforms."

As it continues to refine its forthcoming MySQL 5.6 with Windows improvements, Oracle also recently announced a MySQL for Excel plug-in that allows users to acccess and edit MySQL data from within Excel as well as an enhanced version of the MySQL Installer for Windows and new MySQL Notifier application that that allows Windows-based users to more easily monitor, start and stop MySQL instances with a Microsoft SQL Server look and feel, the company said.

"Addressing the growing demand from business analysts using MySQL for data marts and analytic applications, the new MySQL for Excel application plug-in allows users to easily import, export and manipulate MySQL data, Oracle noted in a statement issued July 26. "Enabling users in most cases to go from download to development in three minutes or less, the enhanced MySQL installer provides point-and-click configuration of new MySQL database instances, as well as advanced logging and security features."
Oracle purchased MySQL along with Sun roughly three years ago.
Oracle claims customers can reduce total cost of ownership by as much as 90 percent by switching from Microsoft SQL Server 2012 to MySQL.