All About Microsoft

Mary-Jo Foley
Home / News & Blogs / All About Microsoft

Microsoft delivers MySQL-to-SQL database migration tool

By | August 13, 2010, 7:05am PDT

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.

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

More from “All About Microsoft”

Topics

MySQL, SQL, Microsoft Corp., Migration Tool, Tool, Microsoft SQL Server, Databases, Open Source, Productivity, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Mary Jo Foley

Mary Jo has covered the tech industry for more than 25 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).

Disclosure

Mary-Jo Foley

Freelance journalist/blogger Mary Jo Foley has nothing to disclose. WYSIWYG (what you see is what you get). I do not own Microsoft stock or stock in any of its partners or competitors. I have no business ventures that are sponsored by/funded by Microsoft or any of its partners or competitors.

Biography

Mary-Jo Foley

Mary Jo Foley has covered the tech industry for 25 years for a variety of publications, including ZDNet, eWeek and Baseline. She has kept close tabs on Microsoft strategy, products and technologies for the past 10 years. In the late 1990s, she penned the award-winning "At The Evil Empire" column for ZDNet, and more recently the Microsoft Watch blog for Ziff Davis.

Got a tip? Send her an email with your rants, rumors, tips and tattles. Confidentiality guaranteed.

Talkback Most Recent of 54 Talkback(s)

  • DOA
    whou would migrate to M$ sql when MySql is free and better?
    ZDNet Gravatar
    Linux Geek
    13th Aug 2010
  • RE: Microsoft delivers MySQL-to-SQL database migration tool
    @Linux Geek - Precisely how is MySQL better than SQL Server?
    ZDNet Gravatar
    de-void-21165590650301806002836337787023
    13th Aug 2010
  • 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!!!

    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. araba oyunu
    ZDNet Gravatar
    Arabalar
    18th Aug
  • 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!
    graduate diploma graduate certificate business degree
    ZDNet Gravatar
    disturbforce
    21st Sep
  • 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!
    Computer Science degree Criminal Justice degree graduate course certificate
    ZDNet Gravatar
    disturbforce
    21st Sep
  • 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..
    IAO Accreditation
    ZDNet Gravatar
    nestdrive
    6th Oct
  • 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.
    Rochville University
    ZDNet Gravatar
    nestdrive
    6th Oct
  • 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.
    Woodfield High School
    ZDNet Gravatar
    nestdrive
    6th Oct
  • 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.
    ZDNet Gravatar
    LBiege
    13th Aug 2010
  • 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?
    ZDNet Gravatar
    jasonp@...
    13th Aug 2010
  • 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.
    ZDNet Gravatar
    LBiege
    13th Aug 2010
  • 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?
    ZDNet Gravatar
    Mister Spock
    13th Aug 2010
  • 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!
    ZDNet Gravatar
    kirovs@...
    15th Aug 2010
  • RE: Microsoft delivers MySQL-to-SQL database migration tool
    I hope there will be more successful your site is very wonderful site. sikis Thanks to the efforts of. porno
    ZDNet Gravatar
    kirismin
    20th Aug
  • Merhaba
    Ke??i??ren sat??l??k daireler veya ke??i??ren kiral??k daireler denince akla gelen ilk adres istevitrin.com, keci??ren satilik daireler 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. kecioren kiralik daireler i??in daha fazla bilgi i??in sitemizi ziyaret ediniz.
    ZDNet Gravatar
    kirismin
    25th Sep
View More Comments

Talkback - Tell Us What You Think

Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

The best of ZDNet, delivered

ZDNet Newsletters

Get the best of ZDNet delivered straight to your inbox

Facebook Activity

Blog Roll

Blog Archive

White Papers, Webcasts, & Resources