Export (0) Print
Expand All

What's New in SSMA for MySQL (MySQLToSql)

SQL Server 2012

This topic lists SSMA for MySQL changes in each release.

The July 2014 release of SSMA for MySQL contains the following changes:

  1. Improved Azure SQL DB code conversion

  2. Extension pack functionality moved to schema to support Azure SQL DB

  3. Performance improvements tested for databases with over 10k objects

  4. UI improvements for dealing with large number of objects

  5. Highlighting of “well known” LOB schemas (so they can be ignored in conversion)

  6. Conversion speed improvements

  7. Show object counts in UI

  8. Report size reduction by more than 25%

  9. Improved error messages for unparsed constructs.

The July 2011 release of SSMA for MySQL contains the following changes:

  1. Added support of MS SQL Server 2014.

  2. Fixed bugs regarding conversion to Azure

  3. Fixed bugs regarding invisible report pages in IE 10.

The July 2011 release of SSMA for MySQL contains the following changes:

  • Support for conversion of LIMIT to SQL Server “Denali” OFFSET.

  • Improved error reporting during data migration.

The April 2011 release of SSMA for MySQL contains the following changes:

  • Single Installable of “SSMA for MySQL”, which supports SQL Server 2005, SQL Server 2008, SQL Server “Denali” and SQL Azure.

  • The ability to connect SQL Server “Denali”.

  • Enhanced client side data migration engine, supporting parallel migration of data.

  • Improved data migration performance with Simple and Bulk logged recovery models.

  • SSMA for MySQL Console version supports backward compatibility. You will be able to open the projects created by versions earlier to SSMA v5.0.

  • SSMA for MySQL v5.0 product can be installed side by side (SxS) with older versions of SSMA Product.

The July 2010 release of SSMA for MySQL contains the following features:

  1. Improvements to User Interface:

    • ‘SQL Modes’ Tab for MySQL Database objects

    • ‘Settings’ Tab for MySQL Database objects

    • ‘Data’ Tab for MySQL Tables

    • Updated Project Settings in Conversion and Migration Pages

    • ‘Data Migration Settings’ at Table level

  2. Improvements to Connect to MySQL and SQL Server:

    • SSL Connectivity in MySQL

    • Encrypted Connectivity in SQL Server

  3. Improvements to MySQL Metabase Explorer:

    • Loading all the MySQL Database Objects and their respective Tabs.

  4. Improvements to Object Conversion:

    • Conversion of MySQL Metabase objects – Procedures, Functions, Views, Triggers and Statements.

    • Limited support for Spatial Data Types in Tables.

    • Option to convert MySQL functions to SQL Server Stored Procedures

    • Option to apply SQL Modes and Charset mapping during Object Conversion

  5. Improvements to Data Migration:

    • Support for Data Migration using both Server Side and Client Side Data Migration Engines

    • Support for Spatial Data Migration

    • Custom SQL for Data Migration for Tables

  6. SSMA for MySQL Console:

    • Support Console Feature for SSMA for MySQL

    • Support for Script-Level Interfacing

The January 2010 release of SSMA for MySQL was the initial release. It contained the following features:

  • Migration to both on-premise SQL Server and SQL Azure are supported.

  • Feature Snapshot: Schema and Data migration of MySQL Tables/Indexes/Constraints.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft