Paul Thurrott's SuperSite for Windows
Home > Type > News > Microsoft Announces SQL Server Migration Assistant for MySQL

Microsoft Announces SQL Server Migration Assistant for MySQL

Jan. 12, 2010 Paul Thurrott | Paul Thurrott's Supersite for Windows

Some interesting new from Microsoft, for those that wish to migrate from MySQL to SQL Server:

Microsoft recently announced the first CTP of a SQL Server Migration Assistant (SSMA) for MySQL v1.0, which automates aspects of the migration process to Microsoft SQL Server 2005 & 2008 including SQL Azure Database.

SQL Server Migration Assistant for MySQL is the newest migration toolkit, others include Oracle, Sybase, Access, and an analyzer for PowerBuilder. The toolkits were designed to tackle the complex manual process customers deal with when migrating databases. In using the SQL Server Migration Assistants, customers and partners reduce the manual effort; as a result the time, cost and risks associated with migrating are significantly reduced.  Our recent SSMA survey showed that 94% of SSMA downloaders would recommend the tool to others.

Since the SQL Server Migration Assistants for Oracle became available in June of 2005, Microsoft has seen more than a 250,000 downloads across all of the SSMAs.  Motorola, Simon & Schuster, Sony Ericsson and Artesia are just a few of the customers that have downloaded and used the SQL Server Migration Assistant toolkit to move to Microsoft SQL Server.

SQL Server Migration Assistant for MySQL v1.0 will be generally available in the summer of 2010 as a free toolkit. The CTP is available today for download and preview at SSMA 2008 for MySQL v1.0 CTP1. Customers and partners can also provide feedback to: ssmateam@microsoft.com.

More information can be found at the DPI blog.

Discuss this Article 11

Waethorn
on Jan 12, 2010
Just FYI: SQL Server 2005 SP2 support is ending.
anonymous
on Jan 12, 2010
This post was mentioned on Twitter by gretchenglas: Microsoft Announces SQL Server Migration Assistant for MySQL: Some interesting new from Microsoft, for those th.. http://bit.ly/4Mx1R5
rr0de74@live.com
on Jan 12, 2010
I am thinking those that chose MySQL did so on the cheap. A migration tool is not going to fill their pockets full of money they want to spend on MS SQL.
FearTheDonut
on Jan 13, 2010
>> I am thinking those that chose MySQL did so on the cheap. A migration tool is not going to fill their pockets full of money they want to spend on MS SQL. Only if they buy a professional-level SQL Server. If they use SQL Server Express, it, too, is free, correct?
Waethorn
on Jan 13, 2010
"Only if they buy a professional-level SQL Server. If they use SQL Server Express, it, too, is free, correct?" Yes, but it's not something you want to rely on in a production environment for multiple clients. SQL Express is for integration into an application where Compact Edition doesn't meet the needs of the app. In an enterprise, you'd want to have synchronous and/or failover redundancy. Small businesses can get SQL Server 2008 Standard in SBS Premium though, and it certainly doesn't cost that much to add it to SBS when you look at the TCO in the IT investment. SQL Server can run multiple databases though. I have a client that runs their LOB app (a complicated business process management app), security monitoring and data collection, and customer database all from the same server.
FearTheDonut
on Jan 13, 2010
@Waethorn - Not starting an argument here. If you don't / can't run production environments for multiple clients on SQL Server Express, why would you want to do it with MySQL? I hear what you're saying, but I thought MySQL and SQL Server Express were equivalent, in terms of enterprise-ability? Or is that mistaken on my end?
rr0de74@live.com
on Jan 13, 2010
They are not equal. My SQL community server is equal to MS SQL standard version. SQL express is for turn key applications that need a database on the same machine as the application is running on. Express is limited to 1 CPU socket (quad core) 1gig of RAM and 4gig databases.
Waethorn
on Jan 13, 2010
"I thought MySQL and SQL Server Express were equivalent, in terms of enterprise-ability? Or is that mistaken on my end?" SQL Server Express isn't designed for enterprise applications. MySQL could work, if you have a very good system architect at work, but the free version of MySQL was never designed for enterprise-level production environments. If you want enterprise class support for MySQL, you end up buying the enterprise edition of it, along with a support contract. Prices start at $600US, but can go up to $5000. That's PER YEAR though. In either case though, there are basic versions for free, and there are enterprise versions for a lot of money. Nobody in their right mind would try and use a mismatched version for their environment though, and certainly, any business with a competent IT department won't be running their business-critical apps on a piece of freeware.
Waethorn
on Jan 13, 2010
@rrode: That is not correct. MySQL Community fits between SQL Server Express and Web, but unlike Web, it doesn't get anything beyond community support. Remember that MySQL Community, like SQL Server Express, is designed for beginner developers for mostly just educational and personal use. Real developers that have business-critical web or desktop apps that generate revenue, will never utilize those platforms. Microsoft has a nifty installer here that can get you started on web development. SQL Server Express 2008 is provided for starter development. If you web apps are business-critical, the target migration path is to use a web host that offers hosted SQL Server 2008 database offerings. http://www.microsoft.com/web/ In fact, you can download a PHP driver for IIS and integrate SQL+PHP web applications using only Microsoft technologies.
FearTheDonut
on Jan 13, 2010
@Waethorn - Much thanks. And, I agree - if you have a need to migrate from SQL Server Express / MySQL to SQL Server 2008 (an enterprise SKU), you need to do more work than just run a wizard, if you want to do it right (scaling it right, mirroring, etc..).
anonymous
on Jan 14, 2010
Fluent.NET 1.0 liberado : Si os gusta el tema de fluent interfaces , este es un más que decente framework

Please or Register to post comments.

Related Articles

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottYou'll have the opportunity to experience:
• 120 Technical
Sessions
• Networking with Peers
• Expert Speakers


Come See Paul Thurrott & Mary Jo Foley in Person!

Register Now

Office 365 InfoCenter

Get the latest insight and info from Paul

Read Now!

What I Use
Apr. 18, 2013
Article

What I Use: On the Road 21

Every so often, I publish an updated version of my “What I Use” document, which details the technology products and services I actually use day-to-day. Since I’m currently on my third business trip in five weeks, this is perhaps an ideal time to discuss the technology products I rely on when I travel and a few related points....More
Mar. 6, 2013
Article

What I Use: March 2013 33

Lots of changes since November, including a new PC-based home server running Windows 8, several new smart phones, new PCs and tablets, new cloud backup, Office 365 Home Premium and a nice doubling of my Internet speeds courtesy of Verizon FIOS....More
WinSuperSite.com
Related Penton Sites
Copyright © 2013 Penton Media, Inc