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

Published 05-31-2021 10:49 AM 1,423 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 enables automatic partition conversion for Oracle partitioned tables while migrating to Azure SQL and SQL on-premises. You can leverage your Oracle partition strategy and accelerate your migration by retaining the partition model even when there is no direct type mapping in SQL. Moreover you can now automatically convert SKIP LOCKED clause and save significant development time.

Follow us on Data Exposed  for a dedicated  episode to the new partition table support  feature 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 MySQL, SSMA for Access and SSMA for SAP ASE surface minor performance improvements and bug fixes
  • SSMA for DB2 is enhanced with:
    • Improved VARCHAR_FORMAT emulation function
    • Fixed table discovery issues for DB2 for i

 

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

Enabling Automatic Conversions for Partitioned Tables (Ep. 5) | Data Exposed

%3CLINGO-SUB%20id%3D%22lingo-sub-2401651%22%20slang%3D%22en-US%22%3ERelease%3A%20SQL%20Server%20Migration%20Assistant%20(SSMA)%20v8.20%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401651%22%20slang%3D%22en-US%22%3E%3CH3%20id%3D%22toc-hId-2029264944%22%20id%3D%22toc-hId-2054977338%22%20id%3D%22toc-hId-2054976400%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-247522875%22%20id%3D%22toc-hId-247521937%22%3E%3CSTRONG%3EWhat's%20new%3F%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EThe%20latest%20releases%20of%20SSMA%20for%20Oracle%20enables%20automatic%20partition%20conversion%20for%20Oracle%20partitioned%20tables%20while%20migrating%20to%20Azure%20SQL%20and%20SQL%20on-premises.%20You%20can%20leverage%20your%20Oracle%20partition%20strategy%20and%20accelerate%20your%20migration%20by%3CSPAN%3E%26nbsp%3Bretaining%20the%20partition%20model%20even%20when%20there%20is%20no%20direct%20type%20mapping%20in%20SQL.%20Moreover%20you%20can%20now%20automatically%20convert%26nbsp%3B%3CCODE%3ESKIP%20LOCKED%3C%2FCODE%3Eclause%20and%20save%20significant%20development%20time.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EFollow%20us%20on%20%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%20%3C%2FA%3E%26nbsp%3Bfor%20a%20dedicated%20%26nbsp%3Bepisode%20to%20the%20new%20%3CSTRONG%3Epartition%20table%20support%20%3C%2FSTRONG%3E%26nbsp%3Bfeature%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%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20MySQL%2C%20SSMA%20for%20Access%20and%20SSMA%20for%20SAP%20ASE%20surface%20minor%20performance%20improvements%20and%20bug%20fixes%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20DB2%20is%20enhanced%20with%3A%3C%2FLI%3E%0A%3CUL%3E%0A%3CLI%3EImproved%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%3EVARCHAR_FORMAT%3C%2FCODE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eemulation%20function%3C%2FLI%3E%0A%3CLI%3EFixed%20table%20discovery%20issues%20for%20DB2%20for%20i%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CH3%20id%3D%22toc-hId--1585643982%22%20id%3D%22toc-hId--1559931588%22%20id%3D%22toc-hId--1559932526%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-901868851%22%20id%3D%22toc-hId-927581245%22%20id%3D%22toc-hId-927580307%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--879873218%22%20id%3D%22toc-hId--879874156%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-1607639615%22%20id%3D%22toc-hId-1607638677%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%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F6BNYxNLLn2g%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EEnabling%20Automatic%20Conversions%20for%20Partitioned%20Tables%20(Ep.%205)%20%7C%20Data%20Exposed%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2401651%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ELooking%20for%20a%20way%20to%20preserve%20your%20Oracle%20partition%20strategy%20while%20modernizing%20to%20Azure%20SQL%3F%20SQL%20Server%20Migration%20Assistant's%20new%20automatic%20partition%20conversion%20allows%20you%20to%20retain%20your%20current%20partition%20model%20even%20when%20there%20is%20no%20direct%20type%20mapping.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎Jun 01 2021 07:21 AM
Updated by: