Oracle releases MySQL migration tools for SQL Server, Windows users

Oracle releases MySQL migration tools for SQL Server, Windows users

Summary: 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.

SHARE:
TOPICS: Oracle
15

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.

 

Topic: Oracle

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

15 comments
Log in or register to join the discussion
  • Oracle claimed alot of things over the years

    but it's still Oracle after all, so everything is taken with a grain of salt.
    William Farrel
  • Imagine DODGE offers a tool to convert your BMW

    Why does Oracle even bother?
    LBiege
    • Re: Imagine BMW offers a tool to convert your DODGE

      Remember, MS-SQL is the USA-made product here, MySQL is from Europe.
      ldo17
      • Then Imagine Trabant offered a tool to convert your Tesla

        Does that satisfy your geography requirements now?
        Your Non Advocate
  • Why not a migration tool to move users to MySQL from MS Access?

    There's still lots of Access databases out there and many, eventually, require that they be upgraded to SQL Server for reasons such as data growth, concurrent multi-user support, etc. Oracle might want to try getting Microsoft converts a little earlier in the process.
    Rabid Howler Monkey
    • MS Access, even with the limited storage, is much better, and much more

      of a mature product. The whole thing is a thing of beauty.

      But, even I don't use Access, nor MySQL. I prefer Postgresql, a much more robust product than Access or MySql.
      adornoe
  • Is MySQL really Open Source??

    Seems to some bluff and fooler from Oracle. I remmeber once instance when one of our client mid-way decided to move aginst MySQL and opt for PostGresql. The reason being MySQL is not really OpenSource and free. They found out soem licensing in being able to use MySQL in their product (which by the way is quite big and popular).
    Also PostGresql is much more robost and feature rich product.
    mghasletwala
  • Is MySQL really Open Source and free??

    Seems to some bluff and fooler from Oracle. I remember once instance when one of our client mid-way decided to move aginst MySQL and opt for PostGresql. The reason being MySQL is not really OpenSource and free. They found out soem licensing in being able to use MySQL in their product (which by the way is quite big and popular).
    Also PostGresql is much more robost and feature rich product.
    mghasletwala
    • That was our exact experience

      First we bought SQL Yog. That helped, but at $100/user.
      Then we tried using chron jobs and scripting all our imports. That worked for a few months. Then started to fail. After several posts to the forumn, we reached out for support. Turns out we needed a fix only available to enterprise edition users.
      So Oracle, where is my cost savings?
      SQL Server has a conversion tool to get you off MySQL. I highly recommend that.
      cbslc
    • Free - for some

      Free for education and non-profit ventures. But for the Enterprise edition there is a fee - I believe with some negotiating skills you can get a site license for unlimited use at a very small price compared to buying full-blown MS SQL or Oracle. And that was the case before Oracle bought Sun. If you go to the Cloud the db cost is just part of your overall fee.
      I'm not happy with the Oracle purchase of MySQL - but that doesn't detract from the power of the software - this bashing of MySQL is somewhat tiresome. If you're on the internet, I'm sure you're hitting MySQL databases.
      beau parisi
  • Now if only there were some decent tools!

    Since there is no ETL tool with MySQL, the "free" MySQL tools are terrible and there is no support. Oh unless you buy the real version. Why on earth would you convert?
    First with SQL Server you get SSIS. Want a MySQL ETL tool, well you'll have to buy on.
    Then there is SQL Managment Studio - you want that functionality from MySQL - you better buy SQLYog and hope you don't need Management Studio's full functionality.
    Then there is Analysis Services - you want that from MySQL, you better buy an OLAP engine from somebody.
    You want replication from MySQL - ya good luck with that!
    My advise - spend the 90% upfront for SQL Server, instead of having to spend the 90% after a few months of pulling your hair out trying to get MySQL to act like a real database.
    cbslc
    • Try Postgresql; more robust, and I haven't had to spend on management

      tools to handle it. There are plenty of free or very inexpensive tools to take care of business.
      adornoe
  • Skire – One more feather in Oracles cap in its series of acquisitions, hea

    Launch of new migration tool for SQL Server, heartiest congratulations to oracle from Evosys.

    About Evosys: Evosys is an Oracle Platinum Partner with dedicated focus on Oracle Application. We specialize in ERP, EPM, CRM and Fusion Middleware Implementations in Kingdom of Saudi Arabia, United Kingdom, United Arab Emirates, Qatar, Bahrain, Oman & India. Evosys has a pool of highly talented & professional consultants, who hold expertise across Financial Management, Human Capital Management, Manufacturing, SCM, Business Intelligence, Hyperion, Siebel CRM and many other solutions. We are known for combining speed of implementation with the quality of delivery.

    For more details, please visit our homepage at www.evosys.co.in.
    evosys
  • Launch of new migration tool for SQL Server, heartiest congratulations to o

    Launch of new migration tool for SQL Server, heartiest congratulations to oracle from Evosys.

    About Evosys: Evosys is an Oracle Platinum Partner with dedicated focus on Oracle Application. We specialize in ERP, EPM, CRM and Fusion Middleware Implementations in Kingdom of Saudi Arabia, United Kingdom, United Arab Emirates, Qatar, Bahrain, Oman & India. Evosys has a pool of highly talented & professional consultants, who hold expertise across Financial Management, Human Capital Management, Manufacturing, SCM, Business Intelligence, Hyperion, Siebel CRM and many other solutions. We are known for combining speed of implementation with the quality of delivery.

    For more details, please visit our homepage at www.evosys.co.in.
    evosys
  • SQLyog already has this feature

    SQLyog has already this feature to import any data from MS SQL server, Oracle, Db2, Sybase etc.. to MySQL with ease here is a answer by expert in stack-overflow http://bit.ly/1aGKBxn
    markflinch