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

Published Jul 01 2021 11:43 AM 1,754 Views

Overview

SQL Server Migration Assistant (SSMA) is a suite of 5 tools designed to automate migrations from Oracle, Access, DB2, MySQL and SAP ASE (formerly SAP Sybase ASE) to Microsoft SQL. It automates the conversion of database schemas to a Microsoft SQL Server schemas, deployment of  the schemas, data migration to the target SQL Server (see below for supported versions), and validation of migrated objects.

 

 

What's new?

The latest releases of SSMA for Oracle and SSMA for DB2 improve the automatic conversion by adding support for new functions and enhancing existing conversion logic. In addition, all tools use COUNT_BIG in row count queries for the target database.

Follow us on Data Exposed  for dedicated episodes on SSMA new features and subscribe to YouTube Channel: aka.ms/azuresqlyt  to find out more on the next features.

 

In addition, this release includes the following:

   

  • SSMA for DB2 is enhanced with:
    • Load aliases for old/new row/table within the triggers definition for DB2 for i
    • Add conversion for the LCASE, UCASE, LOWER, UPPER functions with two and three arguments
    • Add conversion for the LTRIM and RTRIM functions with two arguments
    • Improve conversion for LOCATE and POSITION functions
    • Fix return type of the ssma_db2.CHAR emulation function
    • Fix arguments of the ssma_db2.DECIMAL emulation function

 

  • SSMA for Oracle includes the following improvements:
    • Fix OLE DB connection string mode to respect the provider name
    • Add missing ssma_oracle.fn_getColEntryByRange emulation function
    • Add setting to emulate Oracle's empty string behavior in coalesce operations

 

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 SQL Pool) is supported as a target only when using SSMA for Oracle.

 

Resources

SQL Server Migration Assistant documentation

%3CLINGO-SUB%20id%3D%22lingo-sub-2508124%22%20slang%3D%22en-US%22%3ERelease%3A%20SQL%20Server%20Migration%20Assistant%20(SSMA)%20v8.21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508124%22%20slang%3D%22en-US%22%3E%3CH3%20id%3D%22toc-hId-2029264944%22%20id%3D%22toc-hId-2083809193%22%20id%3D%22toc-hId-2083809193%22%3E%3CSTRONG%3EOverview%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3ESQL%20Server%20Migration%20Assistant%20(SSMA)%20is%20a%20suite%20of%205%20tools%20designed%20to%20automate%20migrations%20from%20Oracle%2C%20Access%2C%20DB2%2C%20MySQL%20and%20SAP%20ASE%20(formerly%20SAP%20Sybase%20ASE)%20to%20Microsoft%20SQL.%20It%20automates%20the%20conversion%20of%20database%20schemas%20to%20a%20Microsoft%20SQL%20Server%20schemas%2C%20deployment%20of%26nbsp%3B%20the%20schemas%2C%20data%20migration%20to%20the%20target%20SQL%20Server%20(see%20below%20for%20supported%20versions)%2C%20and%20validation%20of%20migrated%20objects.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-221810481%22%20id%3D%22toc-hId-276354730%22%20id%3D%22toc-hId-276354730%22%3E%3CSTRONG%3EWhat's%20new%3F%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EThe%20latest%20releases%20of%20SSMA%20for%20Oracle%20and%20SSMA%20for%20DB2%20improve%20the%20automatic%20conversion%20by%20adding%20support%20for%20new%20functions%20and%20enhancing%20existing%20conversion%20logic.%20In%20addition%2C%20all%20tools%20use%20COUNT_BIG%20in%20row%20count%20queries%20for%20the%20target%20database.%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EFollow%20us%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%2FMigrating-to-SQL-Enabling-Automatic-Conversions-for-Partitioned-Tables-Ep5%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EData%20Exposed%26nbsp%3B%3C%2FA%3E%26nbsp%3Bfor%20dedicated%20episodes%20on%20SSMA%20new%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3Efeatures%20and%20subscribe%20to%20YouTube%20Channel%3A%20aka.ms%2Fazuresqlyt%20%26nbsp%3Bto%20find%20out%20more%20on%20the%20next%20features.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%2C%20this%20release%20includes%20the%20following%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20DB2%20is%20enhanced%20with%3A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ELoad%20aliases%20for%20old%2Fnew%20row%2Ftable%20within%20the%20triggers%20definition%20for%20DB2%20for%20i%3C%2FLI%3E%0A%3CLI%3EAdd%20conversion%20for%20the%26nbsp%3BLCASE%2C%26nbsp%3BUCASE%2C%26nbsp%3BLOWER%2C%26nbsp%3BUPPER%26nbsp%3Bfunctions%20with%20two%20and%20three%20arguments%3C%2FLI%3E%0A%3CLI%3EAdd%20conversion%20for%20the%26nbsp%3BLTRIM%26nbsp%3Band%26nbsp%3BRTRIM%26nbsp%3Bfunctions%20with%20two%20arguments%3C%2FLI%3E%0A%3CLI%3EImprove%20conversion%20for%26nbsp%3BLOCATE%26nbsp%3Band%26nbsp%3BPOSITION%26nbsp%3Bfunctions%3C%2FLI%3E%0A%3CLI%3EFix%20return%20type%20of%20the%26nbsp%3Bssma_db2.CHAR%26nbsp%3Bemulation%20function%3C%2FLI%3E%0A%3CLI%3EFix%20arguments%20of%20the%26nbsp%3Bssma_db2.DECIMAL%26nbsp%3Bemulation%20function%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20Oracle%20includes%20the%20following%20improvements%3A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EFix%20OLE%20DB%20connection%20string%20mode%20to%20respect%20the%20provider%20name%3C%2FLI%3E%0A%3CLI%3EAdd%20missing%20ssma_oracle.fn_getColEntryByRange%20emulation%20function%3C%2FLI%3E%0A%3CLI%3EAdd%20setting%20to%20emulate%20Oracle's%20empty%20string%20behavior%20in%20coalesce%20operations%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CH3%20id%3D%22toc-hId--1585643982%22%20id%3D%22toc-hId--1531099733%22%20id%3D%22toc-hId--1531099733%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-901868851%22%20id%3D%22toc-hId-956413100%22%20id%3D%22toc-hId-956413100%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%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--905585612%22%20id%3D%22toc-hId--851041363%22%20id%3D%22toc-hId--851041363%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%20SQL%20Pool)%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-1581927221%22%20id%3D%22toc-hId-1636471470%22%20id%3D%22toc-hId-1636471470%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-2508124%22%20slang%3D%22en-US%22%3E%3CP%3EHeterogenous%20database%20migrations%20target%20a%20high%20automatic%20conversion%20percentage%20for%20source%20objects.%20Download%20and%20test%20SSMA%208.21%20to%20leverage%20the%20latest%20conversion%20improvements.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎Jul 01 2021 11:43 AM
Updated by: