%3CLINGO-SUB%20id%3D%22lingo-sub-1121241%22%20slang%3D%22en-US%22%3ERelease%3A%20SQL%20Server%20Migration%20Assistant%20(SSMA)%20v8.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121241%22%20slang%3D%22en-US%22%3E%3CH3%20id%3D%22toc-hId-1083428438%22%20id%3D%22toc-hId-1083428438%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%20upload%20the%20schema%2C%20and%20then%20migrate%20data%20to%20the%20target%20SQL%20Server%20(see%20below%20for%20supported%20versions).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--724026025%22%20id%3D%22toc-hId--724026025%22%3E%3CSTRONG%3EWhat's%20new%3F%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EIn%20addition%20to%20a%20targeted%20set%20of%20fixes%20designed%20to%20improve%20usability%20and%20performance%2C%20the%20latest%20release%20of%20SSMA%20enhances%20each%20%E2%80%9Cflavor%E2%80%9D%20of%20the%20tool%20by%20adding%20a%20setting%20that%20enables%20users%20to%20omit%20SSMA%20extended%20properties%20in%20the%20converted%20code.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20leverage%20this%20setting%2C%20in%20SSMA%2C%20navigate%20to%20%3CSTRONG%3ETools%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3EProject%20Settings%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3EGeneral%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3EConversion%3C%2FSTRONG%3E%2C%20and%20then%20under%20%3CSTRONG%3EMisc%3C%2FSTRONG%3E%2C%20set%20the%20value%20of%20the%20%3CSTRONG%3EOmit%20Extended%20Properties%3C%2FSTRONG%3E%20setting%20to%20%3CSTRONG%3EYes%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166400i95FEF6E3D08F9C5B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EImportant%3C%2FSTRONG%3E%3A%20SSMA%20v8.5%20and%20later%20have%20been%20updated%20to%20require%20.NET%20Framework%20version%204.7.2.%20If%20you%20don%E2%80%99t%20already%20have%20this%20version%20installed%2C%20download%20and%20install%20the%20runtime%20file%20from%20%3CA%20href%3D%22https%3A%2F%2Fdotnet.microsoft.com%2Fdownload%2Fdotnet-framework%2Fnet472%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%2C%20this%20release%20includes%20the%20following%20enhancements%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20DB2%20now%20provides%3A%3C%2FLI%3E%0A%3CUL%3E%0A%3CLI%3EA%20fix%20for%20conversion%20of%20functions%20that%20use%20default%20argument%20values%3C%2FLI%3E%0A%3CLI%3EImproved%20parsing%20of%20functions%20in%20the%20PARAMETER%20clause.%3C%2FLI%3E%0A%3CLI%3EThe%20ability%20to%20convert%20the%20LEAVE%20statement.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CLI%3ESSMA%20for%20Oracle%20now%20provides%20improved%20parsing%20of%20the%20XMLTABLE%20clause.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1763486808%22%20id%3D%22toc-hId-1763486808%22%3E%3CSTRONG%3EDownloads%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54255%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESSMA%20for%20Access%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54254%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESSMA%20for%20DB2%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54257%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESSMA%20for%20MySQL%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54258%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESSMA%20for%20Oracle%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54256%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%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--43967655%22%20id%3D%22toc-hId--43967655%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%20Azure%20SQL%20Data%20Warehouse*.%3C%2FP%3E%0A%3CP%3E%3CEM%3E*Azure%20SQL%20Data%20Warehouse%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--1851422118%22%20id%3D%22toc-hId--1851422118%22%3E%3CSTRONG%3EResources%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssma%2Fsql-server-migration-assistant%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%20Migration%20Assistant%20documentation%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1121241%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20pleased%20to%20announce%20the%20release%20of%20the%20latest%20version%20of%20SQL%20Server%20Migration%20Assistant%2C%20v8.6.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1121241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESSMA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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, upload the schema, and then migrate data to the target SQL Server (see below for supported versions).

 

What's new?

In addition to a targeted set of fixes designed to improve usability and performance, the latest release of SSMA enhances each “flavor” of the tool by adding a setting that enables users to omit SSMA extended properties in the converted code.

 

To leverage this setting, in SSMA, navigate to Tools > Project Settings > General > Conversion, and then under Misc, set the value of the Omit Extended Properties setting to Yes.

 

clipboard_image_0.png

Important: SSMA v8.5 and later have been updated to require .NET Framework version 4.7.2. If you don’t already have this version installed, download and install the runtime file from here.

 

In addition, this release includes the following enhancements:

  • SSMA for DB2 now provides:
    • A fix for conversion of functions that use default argument values
    • Improved parsing of functions in the PARAMETER clause.
    • The ability to convert the LEAVE statement.
  • SSMA for Oracle now provides improved parsing of the XMLTABLE clause.

 

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

 

Resources

SQL Server Migration Assistant documentation