Release: SQL Server Migration Assistant (SSMA) v8.24

Published Jan 20 2022 08:10 AM 2,154 Views
Microsoft

Overview

SQL Server Migration Assistant (SSMA) Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE) allows users to convert a database schema to a Microsoft SQL Server schema, deploy the schema, and then migrate data to the target SQL Server (see below for supported versions).

 

What's new?

The latest release of SSMA enhances  the assessment and conversion capabilities of the tool with a targeted set of fixes designed to improve quality and conversion metrics. This release includes the following:

 

  • SSMA for DB2 has been enhanced to fix issues with:
    • Add support for ORDER BY clause in subquery
    • Add support for ROW_NUMBER function
    • Improve conversion for UNION/UNION ALL statements
  • SSMA for Oracle has been enhanced to:
    • Add support for LISTAGG function
    • Add support for Oracle compound triggers
    • Improve detection logic for JOIN clause and PIPELINED functions
  • SSMA for Mysql has been enhanced to:
    • Add support for YEAR datatype
    • Improve conversion of comment styles
  • Improve naming for "Save As" statements for all the flavors of SSMA.

We're continuing our effort to improve the accessibility of SSMA. In this release,  we have made it easier for Windows Narrator and other assistive technology to read more elements of SSMA components, and improved contrast and keyboard support.

 

Downloads

Supported sources and target versions

Source: For the list of supported sources, please review the information on the Download Center for each of the above SQL Server Migration Assistant downloads.

Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, an Azure SQL Database managed instance, and  Azure SQL Data Warehouse (Azure Synapse Analytics)*.

*Azure SQL Data Warehouse (Azure Synapse Analytics) is supported as a target only when using SSMA for Oracle.

 

Resources

SQL Server Migration Assistant documentation

%3CLINGO-SUB%20id%3D%22lingo-sub-3067148%22%20slang%3D%22en-US%22%3ERelease%3A%20SQL%20Server%20Migration%20Assistant%20(SSMA)%20v8.24%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3067148%22%20slang%3D%22en-US%22%3E%3CH3%20id%3D%22toc-hId-1285649616%22%20id%3D%22toc-hId--1461288776%22%20id%3D%22toc-hId--1459650240%22%3E%3CSTRONG%3EOverview%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3ESQL%20Server%20Migration%20Assistant%20(SSMA)%20Access%2C%20DB2%2C%20MySQL%2C%20Oracle%2C%20and%20SAP%20ASE%20(formerly%20SAP%20Sybase%20ASE)%20allows%20users%20to%20convert%20a%20database%20schema%20to%20a%20Microsoft%20SQL%20Server%20schema%2C%20deploy%20the%20schema%2C%20and%20then%20migrate%20data%20to%20the%20target%20SQL%20Server%20(see%20below%20for%20supported%20versions).%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1026224057%22%20id%3D%22toc-hId-1027862593%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId--521804847%22%20id%3D%22toc-hId--781230406%22%20id%3D%22toc-hId--779591870%22%3E%3CSTRONG%3EWhat's%20new%3F%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EThe%20latest%20release%20of%20SSMA%20enhances%26nbsp%3B%20the%20assessment%20and%20conversion%20capabilities%20of%20the%20tool%20with%20a%20targeted%20set%20of%20fixes%20designed%20to%20improve%20quality%20and%20conversion%20metrics.%26nbsp%3BThis%20release%20includes%20the%20following%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20DB2%20has%20been%20enhanced%20to%20fix%20issues%20with%3A%3CBR%20%2F%3E%3CUL%3E%0A%3CLI%3EAdd%20support%20for%20ORDER%20BY%20clause%20in%20subquery%3C%2FLI%3E%0A%3CLI%3EAdd%20support%20for%20ROW_NUMBER%20function%3C%2FLI%3E%0A%3CLI%3EImprove%20conversion%20for%20UNION%2FUNION%20ALL%20statements%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ESSMA%20for%20Oracle%20has%20been%20enhanced%20to%3A%3CUL%3E%0A%3CLI%3EAdd%20support%20for%20LISTAGG%20function%3C%2FLI%3E%0A%3CLI%3EAdd%20support%20for%20Oracle%20compound%20triggers%3C%2FLI%3E%0A%3CLI%3EImprove%20detection%20logic%20for%20JOIN%20clause%20and%20PIPELINED%20functions%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ESSMA%20for%20Mysql%20has%20been%20enhanced%20to%3A%3CUL%3E%0A%3CLI%3EAdd%20support%20for%20YEAR%20datatype%3C%2FLI%3E%0A%3CLI%3EImprove%20conversion%20of%20comment%20styles%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EImprove%20naming%20for%20%22Save%20As%22%20statements%20for%20all%20the%20flavors%20of%20SSMA.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EWe're%20continuing%20our%20effort%20to%20improve%20the%20accessibility%20of%20SSMA.%20In%20this%20release%2C%26nbsp%3B%20we%20have%20made%20it%20easier%20for%20Windows%20Narrator%20and%20other%20assistive%20technology%20to%20read%20more%20elements%20of%20SSMA%20components%2C%20and%20improved%20contrast%20and%20keyboard%20support.%3CSTRONG%3E%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1706282427%22%20id%3D%22toc-hId-1707920963%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-158253523%22%20id%3D%22toc-hId--101172036%22%20id%3D%22toc-hId--99533500%22%3E%3CSTRONG%3EDownloads%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fssmaforaccess%26amp%3Bdata%3D04%257C01%257Caciortea%2540microsoft.com%257C98ba3546ad0640876a6508d87d208428%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637396925916289451%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DwHsd44NI7ygfXTuFgqyhXrOHNFaiihZUQUTF2d9ebl8%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESSMA%20for%20Access%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fssmafordb2%26amp%3Bdata%3D04%257C01%257Caciortea%2540microsoft.com%257C98ba3546ad0640876a6508d87d208428%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637396925916289451%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DgwUjrS0KfH6Tu23Ac0YmcC8LKI3dnghhHdRCLhqpH9I%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESSMA%20for%20DB2%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fssmaformysql%26amp%3Bdata%3D04%257C01%257Caciortea%2540microsoft.com%257C98ba3546ad0640876a6508d87d208428%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637396925916299445%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DWCU2f9GEXVC33M5A8UOIXLyKGjOat17c%252FKrZ2DC1IzA%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESSMA%20for%20MySQL%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fssmafororacle%26amp%3Bdata%3D04%257C01%257Caciortea%2540microsoft.com%257C98ba3546ad0640876a6508d87d208428%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637396925916309440%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DyhNDl6vw%252BFC9Tc%252FcDwQSKnvb4i9pBT66GVm1gh0OPZE%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESSMA%20for%20Oracle%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fssmaforsybase%26amp%3Bdata%3D04%257C01%257Caciortea%2540microsoft.com%257C98ba3546ad0640876a6508d87d208428%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637396925916319436%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DBxjmeF37sD0NjcMZucDN5GZb507cCT3xHdDoEYCIx5k%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESSMA%20for%20SAP%20ASE%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH3%20id%3D%22toc-hId--1649200940%22%20id%3D%22toc-hId--1908626499%22%20id%3D%22toc-hId--1906987963%22%3E%3CSTRONG%3ESupported%20sources%20and%20target%20versions%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CSTRONG%3ESource%3C%2FSTRONG%3E%3A%20For%20the%20list%20of%20supported%20sources%2C%20please%20review%20the%20information%20on%20the%20Download%20Center%20for%20each%20of%20the%20above%20SQL%20Server%20Migration%20Assistant%20downloads.%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ETarget%3C%2FSTRONG%3E%3A%20SQL%20Server%202012%2C%20SQL%20Server%202014%2C%20SQL%20Server%202016%2C%20SQL%20Server%202017%2C%20SQL%20Server%202019%2C%20Azure%20SQL%20Database%2C%20an%20Azure%20SQL%20Database%20managed%20instance%2C%20and%20%26nbsp%3BAzure%20SQL%20Data%20Warehouse%20(Azure%20Synapse%20Analytics)*.%3C%2FP%3E%0A%3CP%3E%3CEM%3E*Azure%20SQL%20Data%20Warehouse%20(Azure%20Synapse%20Analytics)%20is%20supported%20as%20a%20target%20only%20when%20using%20SSMA%20for%20Oracle.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-838311893%22%20id%3D%22toc-hId-578886334%22%20id%3D%22toc-hId-580524870%22%3E%3CSTRONG%3EResources%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fsql%252Fssma%252Fsql-server-migration-assistant%26amp%3Bdata%3D04%257C01%257Caciortea%2540microsoft.com%257C98ba3546ad0640876a6508d87d208428%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637396925916319436%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DH%252BvAmbk%252FY2ldnaXYSde6nSsyOBJWLPdK4W2WjQd47f0%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESQL%20Server%20Migration%20Assistant%20documentation%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3067148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20are%20pleased%20to%20announce%20the%20release%20of%20the%20latest%20version%20of%20SQL%20Server%20Migration%20Assistant%2C%20v8.24.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3067148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzureSQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESSMA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 20 2022 08:07 AM
Updated by: