Microsoft delivers MySQL-to-SQL database migration tool

Microsoft delivers MySQL-to-SQL database migration tool

Summary: On August 12, Microsoft made available the first version of a tool designed to help customers migrate from MySQL to SQL Server and/or SQL Azure.

SHARE:

On August 12, Microsoft made available the first version of a tool designed to help customers migrate from MySQL to SQL Server and/or SQL Azure.

The MySQL migration tool is part of the SQL Server Migration Assistant (SSMA) tookit family. Version 1 is available for download from Microsoft's download center. Microsoft also refreshed its family of other SQL migration tools -- for Oracle, Sybase and Access -- at the same time as part of its 4.2 release yesterday. (The Access refresh also enables migrations to SQL Azure.)

Microsoft made available a first technology preview of the MySQL migration tool in January 2010.

As I noted back in January, even though MySQL has been a Microsoft partner, it also is a Microsoft competitor. And ever since Oracle bought Sun and (get MySQL in the process), Microsoft has been treating MySQL as even more of a rival.

SSMA for MySQL v1.0 works with MySQL 4.1 and above. The tool allows users to convert/migrate tables, views, stored procedures, stored functions, triggers, cursors, DML statements, control statements and transactions, according to a blog post on the SSMA Team's blog.

Topics: Open Source, CXO, Data Centers, Data Management, Enterprise Software, Microsoft, Software, Software Development

About

Mary Jo has covered the tech industry for 30 years for a variety of publications and Web sites, and is a frequent guest on radio, TV and podcasts, speaking about all things Microsoft-related. She is the author of Microsoft 2.0: How Microsoft plans to stay relevant in the post-Gates era (John Wiley & Sons, 2008).

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

Talkback

53 comments
Log in or register to join the discussion
  • DOA

    whou would migrate to M$ sql when MySql is free and better?
    Linux Geek
    • RE: Microsoft delivers MySQL-to-SQL database migration tool

      @Linux Geek - Precisely how is MySQL better than SQL Server?
      de-void-21165590650301806002836337787023
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @de-void- Don't get me wrong, iPhone games are cute... for about 10 minutes. To compare them to the games you can get for the PSP (the only other mobile game platform I have any personal experience with) is absolutely laughable though!!!<br><br>Again, before the Apple zealots go absolutely nuts on me, I'm not saying the iPhone is bad but come on, if you've played even one PSP game, you have to admit they are simply not even in the same league when it comes to gaming. And that's okay. iPhone doesn't have to be good at everything. But please don't ever compare iPhone to PSP. That's just silly. <a href="http://www.arabaoyunlarimiz.gen.tr/"><b>araba oyunu</b></a>
        Arabalar
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @de-void-21165590650301806002836337787023 I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing!
        <a href="http://www.olwauniversity.com/programs/diploma-programs/diploma-programs.asp">graduate diploma</a> <a href="http://www.olwauniversity.com/programs/certificate-programs/certificate-programs.asp">graduate certificate</a> <a href="http://www.olwauniversity.com/schools-and-majors/business-and-management.asp">business degree</a>
        disturbforce
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @de-void-21165590650301806002836337787023 I am looking forward for your next post, I will try to get the hang of it!
        <a href="http://www.olwauniversity.com/schools-and-majors/computer-science.asp">Computer Science degree</a> <a href="http://www.olwauniversity.com/schools-and-majors/criminal-justice.asp">Criminal Justice degree</a> <a href="http://www.olwauniversity.com/programs/certificate-programs/certificate-programs.asp">graduate course certificate</a>
        disturbforce
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @de-void-21165590650301806002836337787023 Thanks for sharing. i really appreciate it that you shared with us such a informative post..
        <a href="http://www.facebook.com/internationalaccreditationorganization">IAO Accreditation</a>
        nestdrive
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @de-void-21165590650301806002836337787023 The difference between the right word and the almost right word is really a large matter ??? it's the difference between a lightning bug and the lightning.
        <a href="http://www.reviewonlineuniversity.com/universities/rochieville-university.asp">Rochville University</a>
        nestdrive
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @de-void-21165590650301806002836337787023 I'm the same way, I do my best to remain neutral. It's hard, if you communicate with the person the other person dislikes, then you fall out of favor with them! I simple can't dislike a person, just because someone else does, I just can't.
        <a href="http://www.schoolguidez.com/United_Kingdom/England_-_Doncaster/Doncaster/Woodfield_High_School_1769768/">Woodfield High School</a>
        nestdrive
    • You are right about DOA

      @Linux Geek

      Only junk insignificant apps use the subprime noob MySql so there's no need for them to migrate to SqlServer or any serious database server for that matter.
      LBiege
      • Interesting...

        Facebook uses mySQL. LinkedIn uses mySQL. Craigslist uses mySQL. Wikipedia uses mySQL. iStockphoto uses mySQL. Eli Lilly uses mySQL. Ernst and Young uses mySQL. Eastman Kodak uses mySQL. Hewlitt-Packard uses mySQL. SAS uses mySQL. SonicWALL uses mySQL. Veritas uses mySQL. VMWare uses mySQL. Zimbra uses mySQL. Slashdot uses mySQL. Should I go on or do you get it?
        jasonp@...
      • Facebook, LinkedIn and so on = junk apps

        @jasonp

        Yeah very interesting you don't understand there's nothing mission critical behind those apps. If some data goes corrupted in your Facebook record, it ain't affect nothing. No one cares.

        If you fail a medical record for a hospital and cause a diagnosis accident then you are in for serious doo doo, which is why those mission critical guys use Sql Server over the subprime junk aka MySQL.

        Nice try.
        LBiege
      • jasonp@: do they use it exclusivelly

        to run their own businesses, or are you speaking only in the terms of smaller, less critical applications they sell or give away?
        Tim Cook
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        @LBiege
        Only n00bs use SQL server. Professionals use PG, Oracle, mainly. MySQL is neat for certain applications too. SQL server? God, no!
        kirovs@...
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        I hope there will be more successful your site is very wonderful site. <a href="http://www.sikis.info/" title="sikis izle">sikis</a> Thanks to the efforts of. <a href="http://www.frepornmovie.net/" title="porno">porno</a>
        kirismin
      • Merhaba

        Ke??i??ren sat??l??k daireler veya ke??i??ren kiral??k daireler denince akla gelen ilk adres istevitrin.com, <a href="http://emlak.istevitrin.com/ankara/kecioren-ilcesi/emlak-konut-satilik-daire-ilanlari.html" title="keci??ren satilik daireler">keci??ren satilik daireler</a> 2011 y??l??nda en ??ok sat??lan daireler ve fiyatlar?? hakk??ndada ayr??nt??l?? bilgi alabiliriniz.
        ankara'n??n en ??ok talep g??ren b??lgesi olan ke??i??ren'de ortalama krize ra??men ge??en y??l ile bu y??l aras??nda daire fiyatlar??nda % 15 lik prim yapm???? olmas??n??n yan?? s??ra ke??i??ren yeni emlak projelerinin
        g??zdesi haline gelmi??tir. <a href="http://emlak.istevitrin.com/ankara/kecioren-ilcesi/emlak-konut-kiralik-ilanlari.html" title="kecioren kiralik daireler">kecioren kiralik daireler</a> i??in daha fazla bilgi i??in sitemizi ziyaret ediniz.
        kirismin
      • RE: Microsoft delivers MySQL-to-SQL database migration tool

        Adjusting your diet to a healthier way of eating is a way to lose belly fat without dieting that works for many people. Instead of putting yourself on a restrictive and often unsafe diet, you can try adjusting the way you eat. Instead of five cookies, maybe have one small slice of low fat angel food cake. Simple exchanges like that will provide you with a way of eating that will keep you healthy your entire life.<a href="http://www.curesinusinfection.org">Cure Sinus Infection</a>
        leonardod
    • RE: Microsoft delivers MySQL-to-SQL database migration tool

      @Linux Geek you = ball lost...weeds very, very tall.
      ItsTheBottomLine
    • RE: Microsoft delivers MySQL-to-SQL database migration tool

      @Linux Geek I bet Kinect will not be magical either.<br><br><a href="http://www.trsohbet.com">sohbet</a> could have made <a href="http://www.trsohbet.com">chat</a> magical if they wanted to, they could have hired a man in a turtleneck to give a magical presentation and BAM... a <a href="http://www.trsohbet.com.tr">mynet sohbet</a> Event (maybe a <a href="http://www.forumuz.net/">forum</a> product too, who knows.)<br><br><a href="http://video.trsohbet.com">izlesene</a> would have been much cheaper to <a href="http://www.trsohbet.com.tr">cinsel sohbet</a> too. No wonder <a href="http://www.trsohbet.com/portal/">portal</a> overtaking <a href="http://www.trsohbet.com">chat sohbet</a>, <a href="http://www.trsohbet.com">sohbet odalari</a> know where NOT to spend their money. <a href="http://www.sohbet35.com">sohbet</a> <a href="http://www.cinselsohbet.gen.tr">cinsel sohbet</a> <a href="http://www.mircalem.net">mirc</a>
      atrok
    • RE: Microsoft delivers MySQL-to-SQL database migration tool

      Hey your site is really great I came across while in search for brand info on bing and it has lots of related information on it. Will be sure to come back again and bookmark. Keep up the great work! <a href="http://www.fairingkits.org/suzuki-fairings.html">suzuki fairings</a>
      leonardod
    • RE: Microsoft delivers MySQL-to-SQL database migration tool

      i will promote this particular on my flickr if you do not mind and possibly even blogroll this depending on the comments, great stating. <a href="http://www.liveseo.in/" >seo training indore</a>
      leonardod