Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available
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 optionAnonymous
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, AnweshAnonymous
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. -SamAnonymous
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 removedAnonymous
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 removedAnonymous
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 pleaseAnonymous
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 removedAnonymous
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. -SamAnonymous
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.2Anonymous
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, ChiragAnonymous
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.aspxAnonymous
January 31, 2013
Do SSMA v5.2 support migrations from Sybase ASA 12.0 or higher?Anonymous
January 31, 2013
The comment has been removedAnonymous
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.brAnonymous
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 KlausAnonymous
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 removedAnonymous
November 04, 2013
The comment has been removedAnonymous
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 removedAnonymous
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 removedAnonymous
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 removedAnonymous
August 06, 2014
Employees are more worried about Networking than actually doing something productive!Anonymous
August 18, 2014
The comment has been removedAnonymous
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 removedAnonymous
December 25, 2014
this is compatible for SQL 2008r2.. pls download . microsoft-sql-server-migration-assistant8.software.informer.com/downloadAnonymous
May 31, 2015
The comment has been removed