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

Latest Update - Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.

Latest Update - Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.

  • Comments 6

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, Version  6.0 provides the following major enhancements:

 

  • Materialized View support for Oracle

  • Memory Optimized tables for Oracle
  • Improved Azure SQL DB code conversion
  • Extension pack functionality moved to schema to support Azure SQL DB
  • Performance improvements tested for databases with over 10k objects
  • UI improvements for dealing with large number of objects
  • Highlighting of “well known” LOB schemas (so they can be ignored in conversion)
  • Conversion speed improvements
  • Show object counts in UI
  • Report size reduction by more than 25%
  • Improved error messages for unparsed constructs.

 

 Download SQL Server Migration Assistant (SSMA) v.6.0

 

SSMA for Access:  http://www.microsoft.com/en-us/download/details.aspx?id=43690

SSMA for MySQL: http://www.microsoft.com/en-us/download/details.aspx?id=43688

SSMA for Oracle:  http://www.microsoft.com/en-us/download/details.aspx?id=43689

SSMA for Sybase: http://www.microsoft.com/en-us/download/details.aspx?id=43691

 

 

On the closing note , Yes ! We've heard several of your valuable feedbacks / inputs. Thank you... and we're rolling out with the SSMA for DB2 very soon. Watch out this space for more information.

 

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

  • Thnx for d update. Certain features look interesting. Will surely give'm a try. So far been very useful tool for my SMB.

  • Awesone news about the DB version. I will use it !

  • I was stuck at a problem using access migration in the older version. version six resolved my issue. Must use for more movement of data.

  • Thank you for the update AJ ! I worked with you couple of weeks back if you remember me...?

  • Oracle to SQL Server Migration ==>

    I just updated to version 6 but now I always gets error getting data.. and when I use the older version of SSMA I am able to connect to oracle correctly and it gets the data.

    can you help me what could be the issue ?

  • Are there any installation instructions for 'SSMA for Oracle Extension Pack v6' on SQL Server clustered database?

    Installation of Oracle ExtPack v6 on a standalone SQL Server is straight forward but not sure about the proper way to install it on the clustered environment.

    Thank!

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