Home arrow MySQL arrow Oracle Unveils MySQL Conversion Tools

Oracle Unveils MySQL Conversion Tools

If you use Microsoft's MS SQL Server, Oracle wants to lure you over to the MySQL side. Just ahead of releasing its MySQL 5.6 database, the software company started offering a number of downloadable migration tools to make it easier to convert from one to the other.

By: Terri Wells
Rating: starstarstarstarstar / 0
August 03, 2012

print this article



The migration tools, announced July 25, are designed to let users easily migrate data from Microsoft SQL Server to Oracle's MySQL. According to Oracle, choosing to use MySQL  instead of MS SQL Server 2012 can reduce a company's database total cost of ownership by up to 90 percent. The MySQL installer looks pretty comprehensive; it includes the software, all support connectors, Workbench and sample models, sample databases, and documentation.

Assuming everything else is self-explanatory, what is Workbench? It's software that “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 explains. MS SQL Server databases thus converted can be made to run on Windows, Linux and other platforms.

Oracle also began offering a new “MySQL for Excel” application plug-in. Users of this plug-in can access and manipulate MySQL data within Microsoft Excel, even if they do not have technical knowledge of MySQL. Oracle says that it created the plug-in to address the growing demand from business analysts using MySQL for data marts and analytic applications. It allows users to not only access and manipulate MySQL data, but import and export it as well.

Meanwhile, security-conscious administrators will be glad to hear that the company made an enhanced version of the MySQL Installer for Windows available. It helps users set up advanced security and logging features. Administrators can also benefit from the new MySQL Notifier application for Windows, which lets users easily monitor and manage MySQL instances.

Just how quick and easy is the conversion from Microsoft SQL Server to MySQL? Oracle claims that users “in most cases” can go from download to development in three minutes or less, thanks to point-and-click configuration.

If you'd like more information about MySQL and the new conversion tools, you may want to look into attending the upcoming MySQL Connect Conference. It will take place on September 29 and 30, 2012, in San Francisco. The new migration tools will be featured during the conference.

>>> More MySQL Articles          >>> More By Terri Wells

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: