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

SQL Server Migration Assistant v5.0 is now available

SQL Server Migration Assistant v5.0 is now available

  • Comments 3

Migrate from Sybase, Oracle, MySQL and Microsoft Access to SQL Azure and SQL Server with ease! 

 

Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v5.0, a family of products to further simplify the user experience in automating the migration of Oracle, Sybase, MySQL and Microsoft Access databases to SQL server or SQL Azure.

 

In this release, SSMA family of products has been improved to further to reduce the cost and the risk of migration from Sybase, Oracle, MySQL and Microsoft Access. Our recent SSMA survey showed that 94% of SSMA downloader’s would recommend the tool to others. SSMA products are available for free download and are supported for free over email.

 

In recent months, there has been an uptick in migration to SQL Azure and/or SQL Server, Microsoft has observed more than 8,000 downloads/month of SSMA family of products in recent months.

Dollar Thrifty Auto Group, PEMEX, Eli Lily, Lockheed Martin,  CSR Limited, Florida Department of Education, Forest Oil, The Wyoming Department of Health Vital Statistics Services Program, Landratsamt Landshut, Horowhenua District Council, and Volvo Aero are just a few of the customers that have downloaded and used the SQL Server Migration Assistant toolkit to migrate to Microsoft SQL Server.

 

What’s New in this Release?

With this wave of release, customers can now migrate to any edition of SQL Server including the free Express edition.

 

 

Migrating To:

Migrating From:

Using SSMA Tool:

SQL Server all editions
(2008 R2, 2008, 2005, “Denali”)

SQL Azure

Sybase

SSMA for Sybase


(New in SSMA 5.0)

Oracle

SSMA for Oracle

 

MySQL

SSMA for MySQL

Access

SSMA for Access

 

·         Support for migrating to SQL Server “Denali”

·         Multi-thread data migration for improved scale and performance.

·         Globalization support for migrating non-English databases to SQL Server.

·         Support for installation for SSMA Extension Pack on clustered SQL Server environments.

·         Sybase migration enhancements:

o   Support for migration to SQL Azure

o   Extended data access connectivity to Sybase ASE ADO.NET and ASE ODBC providers

o   Support for conversion of case sensitive Sybase database to case sensitive SQL Server

o   Extended support for conversion of Non-ANSI joins for DELETE and UPDATE statements

o   Removed dependency on separate SYSDB database on target SQL Server

·         Report use of Oracle’s User Defined Type in the database object and inside PL/SQL

 

 

Free Downloads:

1.       SSMA for Access v5.0

2.       SSMA for MySQL v5.0

3.       SSMA for Oracle v5.0

4.       SSMA for Sybase v5.0

 

Customers and partners can provide feedback or obtain free SSMA product support from Microsoft Customer Service and Support (CSS) at ssmahelp@microsoft.com. 

 

Resources:

SSMA Team Blog: http://blogs.msdn.com/b/ssma 

SQL Server Migrations Page: http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx

MSDN Forum: http://social.msdn.microsoft.com/Forums/en-US/sqlservermigration

Feedback: ssmahelp@microsoft.com

Product Support: ssmahelp@microsoft.com

  • SSMA requires SQL Server Native Client version 10.5 or later. Where can I get it from, please?

  • Hi Alan,

    You can download the SNAC 10.5 from this location :

    x86 version - go.microsoft.com/fwlink

    x64 version - go.microsoft.com/fwlink

    regards,

    Ajay

  • Hi,

    Any plans or prospects for SSMA for DB2 in near future?

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