The new tool is integrated into MySQL Workbench, which allows the visual design, development and administration of MySQL databases
Oracle has introduced a new tool that will help in migrating data from Microsoft SQL Server to MySQL, enhancing the MySQL user experience on Microsoft Windows.
The new migration tool is integrated into MySQL Workbench, which allows the visual design, development and administration of MySQL databases.
MySQL Workbench provides a complete application for migrating Microsoft SQL Server database tables and data to MySQL with less time and effort. It also helps SQL Server developers and DBAs convert existing applications to run MySQL on Windows as well as Linux and other platforms.
By using MySQL over Microsoft SQL Server 2012, users can reduce their database total cost of ownership by up to 90%, the company said.
Oracle is also offering a new "MySQL for Excel" application plug-in that enables data analysts with no experience on MySQL to work with MySQL data inside Microsoft Excel.
The new "MySQL for Excel" application plug-in addresses the demand from business analysts using MySQL for data marts and analytic applications. It also allows users to import, export and manipulate MySQL data.
The company is also releasing an improved version of the MySQL Installer for Windows, helping users through the setup of advanced security and logging features, and a new MySQL Notifier application for Windows that allows users to monitor and manage MySQL instances.
Enhanced MySQL installer provides point-and-click configuration of new MySQL database instances, as well as advanced logging and security features by enabling users to go from download to development in three minutes or less.
MySQL Notifier application for Windows helps developers and DBAs to monitor, start and stop their MySQL database instances, with the Microsoft SQL Server look and feel.
Oracle MySQL Engineering vice president Tomas Ulin said, "Easier migration, better data management, administration and monitoring, as well as easier installation and more configuration options make MySQL the ideal platform for developing, deploying and managing business-critical applications on Windows."