Home
%3CLINGO-SUB%20id%3D%22lingo-sub-778075%22%20slang%3D%22en-US%22%3ERelease%3A%20SQL%20Server%20Migration%20Assistant%20(SSMA)%20v8.3%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778075%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EOverview%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ESQL%20Server%20Migration%20Assistant%20(SSMA)%20for%20Oracle%2C%20MySQL%2C%20SAP%20ASE%20(formerly%20SAP%20Sybase%20ASE)%2C%20DB2%2C%20and%20Access%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%3CP%3E%3CSTRONG%3EWhat's%20new%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThe%20latest%20release%20of%20SSMA%20enhances%20each%20%E2%80%9Cflavor%E2%80%9D%20of%20the%20tool%20with%20a%20targeted%20set%20of%20fixes%20designed%20to%20improve%20quality%20and%20conversion%20metrics%2C%20as%20well%20as%20fixes%20that%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAddress%20accessibility%20issues%3C%2FLI%3E%0A%3CLI%3EAdd%20basic%20support%20for%20'hierarchyid'%20type%20in%20SQL%20Server%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIn%20addition%2C%20this%20release%20includes%20the%20following%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSMA%20for%20DB2%20has%20been%20enhanced%20to%3A%3C%2FLI%3E%0A%3CUL%3E%0A%3CLI%3EReplace%20TRIM%20function%20usage%20in%20z%2FOS%20discovery%20queries%20with%20RTRIM%2FLTRIM%3C%2FLI%3E%0A%3CLI%3EAllow%20user%20to%20specify%20Package%20Collection%20when%20connecting%20in%20%E2%80%9CStandard%20mode%E2%80%9D%20(defaults%20to%20NULLID)%3C%2FLI%3E%0A%3CLI%3EAdd%20conversion%20for%20CREATE%20TABLE%20AS%20SELECT%3C%2FLI%3E%0A%3CLI%3EImprove%20conversions%20for%20global%20temp%20tables%3C%2FLI%3E%0A%3CLI%3EFix%20object%20uniqueness%20check%20order%20to%20prioritize%20tables%20over%20constraints%2C%20if%20names%20collide%3C%2FLI%3E%0A%3CLI%3EFix%20loading%20of%20default%20column%20values%20for%20DATE%20and%20TIMESTAMP%20for%20z%2FOS%3C%2FLI%3E%0A%3CLI%3ESupport%20Unicode%20line%20feed%20character%20(aka%20NEL)%3C%2FLI%3E%0A%3CLI%3EFix%20cursor%20conversion%20with%20missing%20RETURN%20TO%20clause%3C%2FLI%3E%0A%3CLI%3EAdd%20support%20for%20labels%20and%20GOTO%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CLI%3ESSMA%20for%20Oracle%20has%20been%20enhanced%20to%3A%3C%2FLI%3E%0A%3CUL%3E%0A%3CLI%3EFix%20unknown%20return%20type%20for%20a%20function%20called%20through%20synonym%3C%2FLI%3E%0A%3CLI%3EUpdate%20ODP.NET%20to%20v19.3%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSTRONG%3EDownloads%3C%2FSTRONG%3E%3C%2FP%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%3CSTRONG%3ESupported%20sources%20and%20target%20versions%3C%2FSTRONG%3E%3C%2FP%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%3CP%3E%3CSTRONG%3EResources%3C%2FSTRONG%3E%3C%2FP%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-778075%22%20slang%3D%22en-US%22%3E%3CP%3ESQL%20Server%20Migration%20Assistant%20(SSMA)%20for%20Oracle%2C%20MySQL%2C%20SAP%20ASE%20(formerly%20SAP%20Sybase%20ASE)%2C%20DB2%2C%20and%20Access%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).%20Learn%20more%20about%20the%20latest%20release%20in%20this%20post.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

Overview

SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access 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?

The latest release of SSMA enhances each “flavor” of the tool with a targeted set of fixes designed to improve quality and conversion metrics, as well as fixes that:

  • Address accessibility issues
  • Add basic support for 'hierarchyid' type in SQL Server

In addition, this release includes the following:

  • SSMA for DB2 has been enhanced to:
    • Replace TRIM function usage in z/OS discovery queries with RTRIM/LTRIM
    • Allow user to specify Package Collection when connecting in “Standard mode” (defaults to NULLID)
    • Add conversion for CREATE TABLE AS SELECT
    • Improve conversions for global temp tables
    • Fix object uniqueness check order to prioritize tables over constraints, if names collide
    • Fix loading of default column values for DATE and TIMESTAMP for z/OS
    • Support Unicode line feed character (aka NEL)
    • Fix cursor conversion with missing RETURN TO clause
    • Add support for labels and GOTO
  • SSMA for Oracle has been enhanced to:
    • Fix unknown return type for a function called through synonym
    • Update ODP.NET to v19.3

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