SQL Server Migration Assistant (SSMA) Team's Blog

How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure

Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.

Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.

Rate This
  • Comments 16

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project. 

The new version of SSMA - SSMA 5.3 provides the following major enhancements:

  • Support of Migration to MS SQL Server 2014.
  • Improved conversion mechanism when migrating to Azure.
  • New features in the Migration GUI.
  • No requirement to get a License key to start using SSMA.

 

Download SQL Server Migration Assistant (SSMA) v.5.3 :

 

Launch the download of the SSMA for Oracle.

Launch the download of the SSMA for Sybase.

 

Launch the download of the SSMA for MySQL.

 

Launch the download of the SSMA for Access.

 

 

 

The SSMA product team is available to answer your questions and provide limited technical support. Contact the team at ssmahelp@microsoft.com

 

  • Thanks a ton for sharing this info !!

  • Was waiting eagerly for this update. Thank you.

  • About time. Hopefully the Bugs are fixed.

  • Thanks for quick response about the un-availability. I'm starting the download now. This makes my life easier.

  • This is an good feature upgrade over the previous version. Thank you so much !

  • Hello, I tried to run on Windows 2003 but I receive no valid win32 error. It is only for 64 bit?

  • @ Luiso - You should be able to run and install SSMA v 5.3 on Windows 2003 Platform without any issues , since its completely supported. Do let us know what specific error you're observing , will be glad to assist.

  • Thanks for releasing this new version. Love this tooling for migration. Mostly use the Oracle to SQL migration, works perfectly.

  • Hi,

    i have the same issue as Luiso. this is in win2k3r2 sp2.

    I get 'is not a valid win32 application' error.

    Nothing gets logged in event viewer logs.

  • I am having the same problem as Law and Luiso.

  • Hi,

    Please help me.

    I am using SSMA v.5.3 version to migrate oracle schema to sql server and the oracle schema size is just 2 GB and around 2800 tables. But the schema conversion step is taking more than 12 hours. Source is linux OS and target is windows 2012. I am using server side migration . Could some one please help me to resolve the slowness.  Very very slow conversion.

    Thanks,

    Vijay

  • Can you please document when and why SSMA 5.3 adds or does not add SSMA_Timestamp columns? I have not been able to find this info on the internet and can't figure out what the pattern is.  

  • Hi!

    Does this still require the "SSMA Components on SQL Server (MySQL to SQL)"? If yes, where do I get them from?

    The documentation just says I ought to have a zip file but noit where to get it.

    Lots of Greetings!

    Volker

  • Sorry, I was stupid. The download is right there...

  • Any word on the win32 install issue?  I'm also on win server 2003 r2 and am getting the error "...SSMA for Sybase 5.3.0 is not a valid Win32 application."  It gives me a similar error if I try to open the Oracle version.  Help!  I want to leave sybase behind.

Page 1 of 2 (16 items) 12
Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post