O'Reilly logo

Microsoft SQL Azure: Enterprise Application Development by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Migration from MySQL to SQL Azure using SQL Server Migration Assistant 2008 for MySQL

With SQL Server Migration Assistant 2008 for MySQL (SSMA), introduced in the previous chapter, you can accomplish the following:

  • Connect to both MySQL and SQL Azure
  • Convert MySQL schemas to SQL Azure
  • Upload MySQL database schemas to SQL Azure
  • Migrate MySQL data to SQL Azure

Another option available for the target server is SQL Server 2008.

You need to have both servers available and you should make sure you can connect to the servers using SSMA. The details of MySQL programs installed for use in this section are as follows:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required