Share via

Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available

  • Article

Automating Database Migration to SQL Server 2012

SQL Server Migration Assistant (SSMA) v5.2 is now available. 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.2 provides the following major enhancements:

  • Support conversion of Oracle %ROWTYPE parameters with NULL default
  • Support conversion of Sybase’s Rollback Trigger
  • Better user credential security to support Microsoft Access Linked Tables

Download SQL Server Migration Assistant (SSMA) v.5.2

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.

Comments

  • Anonymous
    April 09, 2012
    Do I still need all of the prerequisites that are mentioned in a previous post? I have downloaded and installed this product but I am getting an alert saying it cannot access the server.

  • Anonymous
    April 18, 2012
    Can we use this to migrate Data from SQL Azure to any SQL server version like SQL 2008 or, SQL 2012??

  • Anonymous
    April 26, 2012
    Does SSMA 2012 convert attachment data? Would be good if it does!

  • Anonymous
    May 08, 2012
    Does this version  still need extn pack?

  • Anonymous
    July 25, 2012
    Hi, a) It'd be good if the SSMA team actually responded to the comments posted on their blog posts. b) Are you aware that the download is actually not working?

  • Anonymous
    July 26, 2012
    Hi there I let Han know there are questions and the links need updating. Thanks for posting.

  • Anonymous
    August 02, 2012
    I am able to download the product but upon launch when I get the license management screen it fails to download the licence after I sign in and submit my information.  Not sure if that is the same issue that AG_aus was talking about with the download or not but thought I would mention it just in case it is not, thanks.

  • Anonymous
    August 02, 2012
    I have the same issue as Vernon.  We are burning investigation time just trying to get a licence key to try the product. It will not be long before we conclude that staying with Oracle is the cheaper option

  • Anonymous
    August 03, 2012
    Hi folks. Thanks for letting us know. We found a link had been inadvertently removed. The link should be fixed now.

  • Anonymous
    August 05, 2012
    Hi There, still  having the same problem (now 6 aug).  Cannot download the license file: file not found Cheers.

  • Anonymous
    August 06, 2012
    Hi, I am getting the same error as you described in your blog, however even after following all the procedure I am not able to resolve this issue. The error stack trace is exactly the same as you have "Must declare variable error messages". I am using SSMA for Oracle Extension Pack 5.2. I am migrating from Oracle 11g R2 to SQL Server 2008 R2. Just FYI, My SQL Server Collate Name is "SQL_Latin1_General_CP1_CS_AS". I am new to SQL Server. Please help me to resolve this error. If this is not the correct blog, please suggest me one where I can find solution. Thanks, Anwesh

  • Anonymous
    August 08, 2012
    Hi MB I apologize for the inconvenience. It took me a few days of escalating through channels to find that the license file had also been physically deleted. The file has now been restored. -Sam

  • Anonymous
    August 09, 2012
     I am migrating 11gr2 to SQL 2008r2.  Is there any reason why SSMA doesn't migrate the oracle tables. When I run the tool and check the objects in SQL Server it only show the packages and procedures. No tables, views or any other objects. Any idea why that is?

  • Anonymous
    August 27, 2012
    The comment has been removed

  • Anonymous
    October 12, 2012
    hi sam, there is still no license to download - 3 months and still not working maybe that license thing was not such a good idea after all :) but anyway we do need the proper file, so please fix it !!

  • Anonymous
    October 12, 2012
    Sorry you're still having issues Rob and Jorg.  We tested this and were not able reproduce the problem. Of course that doesn't mean there's not a problem.  Please contact ssmahelp at microsoft.com if you're still stuck.

  • Anonymous
    October 20, 2012
    The comment has been removed

  • Anonymous
    October 21, 2012
    j ai un probleme avec la migration des données . j ai une table de 900000 lignes a migré de mysql vers sql azure mais au bout de la 686000 lignes la connexion est perdu et la migration est interrompue helppp please

  • Anonymous
    October 21, 2012
    softdesigner.googlecode.com/.../mysql-ssma.license use that one...it worked 4 me..

  • Anonymous
    October 22, 2012
    Hi Robyscar! We are really sorry that we started on a bad note here as there might have been a momentary loss of service availability. Incase you don't have the file yet please email us at ssmahelp@microsoft.com we would provide you the license file directly. We would also assist you in moving data from MySQL to MS SQL Server  as and when you face issues free of charge.

  • Anonymous
    October 22, 2012
    The comment has been removed

  • Anonymous
    October 24, 2012
    First off, I'm very sorry it took so long to get you guys what you need. If you ever get blocked feel free to contact ssmahelp@microsoft.com. Our support team is ready to help. I've investigated the missing license for the MySQL version and believe it should be downloadable again. robyscar - I agree with you that this is a real bummer... Migrations are hard and  something silly shouldn't get in the way of getting you the tools you need. I'm pretty new to this particular product. I have been investigating why it's this way. I haven't found an answer that I liked and yesterday have proposed changing this to remove the downloading of the license requirement for future downloads. It won't happen quickly since it's "working" right now, but I think it is a good change. Thanks for the suggestion. -Sam

  • Anonymous
    October 25, 2012
    The link to license registration page does not work, how can i get the license for SSMA for mysql v5.2?

  • Anonymous
    October 25, 2012
    Hi Fdo, Please open a ticket at support.microsoft.com/.../default.aspx and provide your email id. I will send you the license file for MySQL 5.2

  • Anonymous
    November 06, 2012
    This is pig-awful software, guys...did you collect a salary for this? After about half a day of installing everything I can only run a report on a source DB once or twice before I get what looks like null pointer errors. I have to persist as I have to use it but thanks, MS, for producing plop again.

  • Anonymous
    November 15, 2012
    Hi, I have to migrate Sybase to SQL server 2005, is it ok if I will work with SSMA 5.2 version or I needed older version of it? Thanks, Chirag

  • Anonymous
    November 15, 2012
    When I run Migrate Data option in  SSMA, i got this error: Could not find stored procedure 'sysdb.ssma_syb.bcp_save_migration_package'. How to get install this stored procedure?

  • Anonymous
    November 16, 2012
    Hi Chirag, You should always use the latest version of SSMA. Currently, it is version 5.2. It supports SQL Server 2005 as well as 2008, 2012 and Azure. In order to use server side data migration (that is where bcp_save_migration_package is needed), you have to install SSMA Extension Pack (for Sybase, in your case).

  • Anton

  • Anonymous
    November 28, 2012
    Is there  user's guide for this migration tool?

  • Anonymous
    January 08, 2013
    Is it possible to migrate data from Oracle 11g to SQL Server 2008 R2 Standard Edition. I know it works with the enterprise edition. I mean will SSMA work with the standard edition.

  • Anonymous
    January 08, 2013
    Hi Dibin, You use SSMA 5.2 to migrate to any edition of SQL Server. In the overview section of www.microsoft.com/.../details.aspx we have mentioned "SSMA for Oracle v5.2 is designed to support migration from Oracle 7.3 or later version to all edition of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012."

  • Anonymous
    January 08, 2013
    Hi Mindy, I am sorry for the late reply. You can use the help section of the tool and you can also download the whitepapers from www.microsoft.com/.../details.aspx

  • Anonymous
    January 31, 2013
    Do SSMA v5.2 support migrations from Sybase ASA 12.0 or higher?

  • Anonymous
    January 31, 2013
    The comment has been removed

  • Anonymous
    August 22, 2013
    I installed the ssma to convert mySQL to SQL Express, but, it doesn´t work. The button "convert" is not able and a message "SQL SERVER AGENT" is not ruuning. IT's obvisious thais is not running because sql express (2005) doens´t have it. What can I do? ivo@share.com.br

  • Anonymous
    September 17, 2013
    Hi, MS Access to SQL Server Why not support the extended property "Field Description" (of a table) and also automatically convert it ? Access and SQL Server support it both. Any plans to support the conversion of the multi-level Access Attach-fields ? best regards Klaus

  • Anonymous
    October 20, 2013
    The license key page is now 404.  I need a license file.  What is the correct URL?

  • Anonymous
    October 27, 2013
    Scott is right, license registration page is still a 404 error page... Dead in the water until I can get a license. Just sent an email to ssmahelp@microsoft.com though.

  • Anonymous
    November 01, 2013
    The comment has been removed

  • Anonymous
    November 04, 2013
    The comment has been removed

  • Anonymous
    November 08, 2013
    Where can I obtain the license file? The link to the license file from the setup program brings me to a 404 error page.

  • Anonymous
    November 08, 2013
    On the Connect to Sql Server Window, the list of Server names is blank.  Why can't SSMA find any Sql Server instances on my machine?

  • Anonymous
    November 21, 2013
    Trying to register license produced a 500 - Internal Server Error.  Tried both Typical and Complete installation options.  Cannot register license.

  • Anonymous
    November 25, 2013
    to get a license, one should login with a live id.

  • Anonymous
    December 23, 2013
    After looking at the threads for the license piece, it's no wonder people are disliking your products.  Jeez!  Such a simple thing to give simple directions on where to install the license.  Can't find anything close to where you describe where the license should go. Goodbye Gates, Ballmer, and soon Microsoft....TIme to go!!!

  • Anonymous
    January 04, 2014
    The comment has been removed

  • Anonymous
    January 09, 2014
    The license Link for SSMA (Sybase) is giving me a 4040 error.

  • Anonymous
    January 27, 2014
    Website show you have a SSMA for migrating from IBM DB2 to SQL, but only get sent to an empty link.  Is SSMA available for DB2 or not?

  • Anonymous
    January 30, 2014
    I have downloaded the tool and the license to migrate from Oracle (11g) to SQL Server (2012).  I am running Windows Server 2008R2.  When I try to install the Migration Assistant for Oracle Extension Pack, and get to the step of choosing/entering the master password, once I enter the pw and hit enter, I get a "windows has experienced a fatal error and will restart".  I have tried using different pw's and no pw.  I have tried putting the license file in different spots.  It still kills the server every time.  Is this the best MS can do??  Please post solution.

  • Anonymous
    February 26, 2014
    The comment has been removed

  • Anonymous
    March 11, 2014
    SSMA team is doing a lousy job. It simply does not work.

  • Anonymous
    April 19, 2014
    I want to add my voice to the existing comments. There are a lot of hard working developers out there that through their good work are making Microsoft look good. When we have to waste time on already busy schedules to get software tools to work, like this whole license thing, it is extremely disappointing. If the SSMA team doesn't have the resources to get the job done, then someone in the team needs to get the resources and do this right. I am angry. I don't want to be. I want to get on with my work.

  • Anonymous
    May 07, 2014
    I hope the procedure to migrate as not chagned for SQL 2012. I have done it earlier with ssma 5.2 for 2008 R2.

  • Anonymous
    May 12, 2014
    Link to the download is broken again. Is this project dead?

  • Anonymous
    May 14, 2014
    I too am having issues downloading SSMA 5.2.  The link is broken.  Does anyone have an alternate download link?

  • Anonymous
    May 15, 2014
    After emailing the "Product Support" staff managing the blog, I was directed to another blog posting.  It appears that SSMA v5.3 is out and available.  Cruise on over to: blogs.msdn.com/.../sql-server-migration-assistant-ssma-v5-3-is-now-available.aspx Enjoy.

  • Anonymous
    May 18, 2014
    ... except that v5.3 says you can't connect to an older vsersion database. So if you got SQL 2012, yur stuffed! Good! Well done, Microsoft!

  • Anonymous
    August 03, 2014
    The comment has been removed

  • Anonymous
    August 06, 2014
    Employees are more worried about Networking than actually doing something productive!

  • Anonymous
    August 18, 2014
    The comment has been removed

  • Anonymous
    September 01, 2014
    Same request as Klaus Oberdalhoff : "Why not support the extended property "Field Description" (of a table) and also automatically convert it ? Access and SQL Server support it both." Small companies usually start building their applications in Access. The only rapid/practical way to document the database is to use the Description feature (when necessary) for tables' fields. Designing a database even for small to medium database (100-200 tables) in Access (Ralationships diagrams) is problematic since the layout is sometimes lost. There are 3rd party tools that support importing Descriptions (MSVisio and ModelRight) but there are nowhere near perfect in this respect.

  • Anonymous
    September 04, 2014
    Hi Mr. Sam, We r trying to migrate Oracle8i db to Sql Server 2012 using SSMA. The error msg says "Connection to this server version are no longer supported". Please advise remedy. Thanks.

  • Anonymous
    October 09, 2014
    The comment has been removed

  • Anonymous
    December 25, 2014
    this is compatible for SQL 2008r2.. pls download . microsoft-sql-server-migration-assistant8.software.informer.com/download

  • Anonymous
    May 31, 2015
    The comment has been removed