Release notes for AWS Schema Conversion Tool - AWS Schema Conversion Tool

Release notes for AWS Schema Conversion Tool

This section contains release notes for AWS SCT, starting with version 1.0.640.

Release notes for AWS SCT Build 676

Source Target What's new, enhanced, or fixed Availability in AWS DMS Schema Conversion Tool (SCT) Availability in AWS DMS Schema Conversion
Oracle PostgreSQL/ Aurora PostgreSQL New built-in function emulation for the following functions:
  • SYS.UTL_RAW.BIT_AND(RAW,RAW)

  • XDB.DBMS_XSLPROCESSOR.CLOB2FILE(CLOB)

  • XDB.DBMS_XSLPROCESSOR.READ2CLOB(VARCHAR2)

  • SYS.UTL_RAW.BIT_OR(RAW,RAW)

  • SYS.UTL_RAW.BIT_COMPLEMENT(RAW)

No Yes
MS SQL Server Amazon RDS SQL Server Removed Database Mail not supported message from PDF report Yes Yes
Oracle PostgreSQL/ Aurora PostgreSQL Implemented constraints conversion for partitioned tables. Yes Yes
Oracle MySQL Review of AI-602 applicability in table conversion Yes Yes
MS SQL Server PostgreSQL/ Aurora PostgreSQL now supports the MERGE Statement in PostgreSQL 15.x Yes Yes
All All Implemented JDBC Connections: Advanced properties Yes No
All All CLI: Fixed PrintOLAPTaskStatus command failure Yes No
Teradata Amazon Redshift Implemented Teradata-style data type cast. Yes No
Teradata Amazon Redshift Fixed Incorrect MERGE conversion in SQL/BTEQ. Yes No
Teradata Amazon Redshift Implemented Teradata-style data type cast. Yes No
Teradata Amazon Redshift Implemented LEAD/LAG function conversions. Yes No
Teradata Amazon Redshift Fixed error AI-9996 Transformer error occurred in statement. Yes No
Teradata Amazon Redshift Fixed error AI-9996 Transformer error in selectItem. Yes No
Teradata Amazon Redshift Implemented conversion for partial stored procedure: XbiDQM.SpCmprsnDly Yes No
Teradata Amazon Redshift Implmented UNPIVOT statement with alias. Yes No
Teradata Amazon Redshift Implemented Delete statement with several source tables. Yes No
Teradata Amazon Redshift Fix for AI-9996 Transformer error occurred in functionCallExpression. Yes No
Teradata Amazon Redshift Implemented NORMALIZE clause conversion. Yes No
Teradata Amazon Redshift Fixed incorrect conversion in DELETE statements with subqueries. Yes No
Teradata Amazon Redshift Fixed error AI-9996 Transformer error occurred in tableOperatorSource. Yes No
Teradata Amazon Redshift Fixed error AI-9996 Transformer error occurred in additiveExpression. Yes No
Teradata Amazon Redshift Implemented DBC system object conversion. Yes No
Teradata Amazon Redshift Implemented workaround of update with implicit join predicates. Yes No
Netezza Amazon Redshift Fixed CREATE MATERIALIZED VIEW statement conversion error. Yes No
Db2luw PostgreSQL/ Aurora PostgreSQL JDBC Extended Options connection: Added additional connection options. Yes No
Db2luw PostgreSQL/ Aurora PostgreSQL Added support for MERGE Statement in PostgreSQL 15.x Yes No
Db2luw PostgreSQL/ Aurora PostgreSQL Implemented GLOBAL TEMPORARY TABLE conversion. Yes No
Db2luw PostgreSQL/ Aurora PostgreSQL Implemented USER DEFINED TYPES conversion. Yes No
Db2luw MySQL Implemented GLOBAL TEMPORARY TABLE conversion. Yes No
Db2luw MySQL Implemented USER DEFINED TYPES conversion. Yes No
Db2luw MySQL Implemented USER DEFINED FUNCTIONS conversion. Yes No
Db2luw MariaDB Implemented GLOBAL TEMPORARY TABLE conversion. Yes No
Db2luw MariaDB Implemented USER DEFINED TYPES conversion. Yes No
Sybase All Added support for Kerberos authentication Yes No
Db2luw PostgreSQL/ Aurora PostgreSQL Added support for multi-version conversion for the targets Yes No
Azure SQL/ Microsoft SQL Server PostgreSQL/ Aurora PostgreSQL Added support for multi-version conversion for the targets Yes No
Db2luw PostgreSQL/ Aurora PostgreSQL Added support for MERGE statement in PostgreSQL 15.x. Yes No
Teradata Amazon Redshift Fixed unsupported function change conversion. Yes No
All Amazon Redshift Data Extractors: Implemented partitioning by an indexed column. Yes No

Release notes for AWS SCT Build 675

Source Target What's new, enhanced, or fixed Availability in AWS DMS Schema Conversion

Cassandra

DynamoDB

Fixed a bug where Cassandra installation would fail on the target Datacenter.

No

DB2 LUW

PostgreSQL

DYNAMIC SQL: PREPARE statement: Resolve and Conversion without Dynamic SQL.

No

DB2 LUW

PostgreSQL

Added support for SPECIAL REGISTER.

No

DB2 LUW

PostgreSQL

Extension pack update

No

Hadoop

Amazon EMR

Added support for connecting to a Hadoop cluster via the rsa-sha2 protocol.

No

Microsoft SQL Server

Amazon Redshift

Fix for JDBC Driver forcing TLS despite not being configured.

No

Netezza

Amazon Redshift

Added support for Materialized views conversion.

No

Oracle

Amazon Redshift

Added support for recursive queries in Amazon Redshift.

Yes

Oracle

PostgreSQL, Aurora PostgreSQL

Fix for incorrect conversion of NUMBER datatype.

Yes

Oracle

Amazon Redshift

Data migration. Oracle auto-partitioning. Added expiration time for the table fragments value. Expiration time is 72h. When expiration occurs, data fagments are rebuilt when a data migration task is created.

No

Oracle

Amazon Redshift

SCT Data Extractor: Changed the approach of uploading data to Amazon Redshift. By default, the extractor doesn't create staged tables. Instead, after all the data files are in the Amazon S3 bucket, the extractor copies them to the target table using a single COPY command.

No

Oracle

Amazon Redshift

Added migration of RAW data type to VARBYTE column.

No

Oracle

PostgreSQL, Aurora PostgreSQL

Multi-version conversion

No

Oracle

PostgreSQL

Added support for MERGE Statement in PostgreSQL 15.x.

Yes

Oracle

PostgreSQL

Added support for new regular expression functions in PostgreSQL 15.x.

Yes

Oracle

PostgreSQL, Aurora PostgreSQL

ON CONFLICT DO UPDATE statement is converted without excluded alias.

Yes

Teradata

Amazon Redshift

Added conversion support for LEAD/LAG functions.

No

Teradata

Amazon Redshift

Enhanced data type casting with explicit indication of data format.

No

Teradata

Amazon Redshift

Improved conversion of AT 'TIME ZONE' clause in time/timestamp expressions.

No

Teradata

Amazon Redshift

AI-9996 during conversion procedures with MERGE statements.

No

Release notes for AWS SCT Build 674

Source Target What's new, enhanced, or fixed Availability in AWS DMS Schema Conversion

All

All

Various bug fixes and performance improvements

Partial (only for supported source and target pairs)

Azure SQL/ Microsoft SQL Server

Amazon Redshift

Removed "AI 18066: Unable to convert schema name" message that was misleading users during schema assessment/conversion

No

Azure SQL/ Microsoft SQL Server

Amazon RDS for MySQL / Amazon Aurora MySQL

Incorrect conversion of the procedure without assigning a return code

Partial (Schema Conversion does not currently support Azure SQL as a source)

Azure SQL/ Microsoft SQL Server

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Fixed AI9997 for some cases of FOR XML PATH clause conversion

Partial (Schema Conversion does not currently support Azure SQL as a source)

Azure SQL/ Microsoft SQL Server

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Value is rounded to original scale in procedure/function body

Partial (Schema Conversion does not currently support Azure SQL as a source)

Azure SQL/ Microsoft SQL Server

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Various improvements to the conversion of EXECUTE statements

Partial (Schema Conversion does not currently support Azure SQL as a source)

Azure SQL/ Microsoft SQL Server/ Azure Synapse

Amazon Redshift

Improved conversion of the following statements and modes:

  • EXCEPTION BLOCK

  • AUTOCOMMIT

  • NONATOMIC

  • GROUPING SET

  • CUBE

  • ROLLUP

No

DB2 LUW

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Various fixes in metadata load sql-queries

No

DB2 LUW

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

AI 9996 is not expected on triggers

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

ROWNUMBER analytic function

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Hexadecimal string constant support

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Various fixes in metadata load sql-queries.

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

NEXT VALUE FOR sequence reference support

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

GET DIAGNOSTICS statement DB2_NUMBER_ROWS option support

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

GET DIAGNOSTICS Multiple statements

No

DB2 z/OS

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Fixed bugs in FOR statement conversion.

No

Oracle

Amazon RDS for MySQL / Amazon Aurora MySQL

Fixed bug when package function's parameter node is not defined.

Yes

Oracle

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Fixed bugs in extension pack's function AWS_ORACLE_EXT.NEXT_DAY

Yes

Oracle

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Fixed various bugs with conversion "(+)" in Oracle's outer joins

Yes

Oracle

Support Kerberos Authentication

No

SAP ASE

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Fixed bug when converting more than one identifier in FROM clause in UPDATE statement

No

SAP ASE

Amazon RDS for PostgreSQL / Amazon Aurora PostgreSQL

Fixed bug with multi-line comments and statements conversion

No

SAP ASE

Added support for the ENCRYPT_PASSWORD parameter when connecting

No

Teradata

Amazon Redshift

Improved convertion of VOLATILE table with specified schema name

No

Teradata

Amazon Redshift

Incorrect conversion WHERE CLAUSE in complex CTE

No

Teradata

Amazon Redshift

Added support for the INTERVAL datatype when migrating data using SCT Data Extraction Agents.

No

Teradata BTEQ scripts

Amazon Redshift RSQL scripts

Incorrect conversion out parameters in procedure executed by BTEQ

No

Release notes for AWS SCT Build 673

Source Target What's new, enhanced, or fixed

All

All

General bug fixes and performance improvements

Azure SQL/ Microsoft SQL Server

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed incorrect function call conversion

Azure SQL/ Microsoft SQL Server

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Implemented conversion of FOR XML clause

Azure SQL/ Microsoft SQL Server

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Conversion of FOR XML clause with wrong alias.

Azure SQL/ Microsoft SQL Server

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed bug when AWS SCT doesn't convert EXECUTE statements that run a character string with procedure parameters.

Azure SQL/ Microsoft SQL Server

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Improved conversion of UPDATE statements with inner joins.

Azure Synapse

Amazon Redshift

Fixed incorrect conversion of the OBJECT_ID built-in function.

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Implemented the conversion of the following statements and objects:

  • DECLARE TEMPORARY TABLE statement

  • DROP TABLE statement

  • PK and UNIQUE constraints on partitioned tables

  • TIMESTAMPDIFF function

  • TO_DATE function

  • EBCDIC_STR function

  • VARCHAR_FORMAT function

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed bug when function based index skips the functions after conversion.

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed bug where the REPEAT statement closed with AI 9996 after conversion

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed bug where the FINAL TABLE clause closed with 9996.

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

LOADER | Partitioning key in references constraint. AWS SCT can now convert primary keys and unique constraints in partitioned tables as secondary indexes.

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

PostgreSQL.VARCHAR_FORMAT function support

IBM DB2 for z/OS

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Implemented the collation change in CreateTransformationRule and ModifyTransformationRule SCT CLI commands.

Greenplum

Amazon Redshift

Fixed bug with incorrect call of stored procedure after conversion

Hadoop

Amazon EMR

Added support for connecting to a Hadoop cluster using the rsa-sha2 protocol.

Hadoop

Amazon EMR

Added support for Amazon EMR with non-Glue Hive metastore,

Oracle

Amazon Redshift

Fixed bug with incorrect conversion of recursive query where PRIOR column was not in the SELECT list.

Oracle

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Implemented returning an element of an associative array

Oracle

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed unexpected AI 9996 in UNPIVOT with brackets

Oracle

Aurora PostgreSQL/ Amazon RDS PostgreSQL

Fixed unexpected AI 9996 in UNPIVOT with UNION ALL

Oracle

Aurora PostgreSQL/ Amazon RDS PostgreSQL

improvements for Number data type conversions

Oracle

Amazon Redshift Data Extractor

Support for auto-partitioning for Oracle tables. Optimization for creating migration tasks.

Teradata

Amazon Redshift

Implement conversion of EXCEPTION BLOCK statement

Teradata

Amazon Redshift

Support for conversion of ALL, ANY, and SOME predicates to Amazon Redshift.

Teradata

Amazon Redshift

Added native support for QUALIFY predicate.

Teradata

Amazon Redshift

Improved conversion of the following:

  • Recursive queries

  • GROUPING SET

  • CUBE

  • ROLLUP

  • UPDATE statement with implicit join

OLAP sources

Amazon Redshift Data Extractor

Implemented CLI commands for Stop/Resume for Amazon Redshift Data Extractor tasks.

OLAP sources

Amazon Redshift Data Extractor

Added the ability to select the table columns that need to be migrated during configuration of the migration task.

Release notes for AWS SCT Build 672

Source Target What's new, enhanced, or fixed

All

Amazon RDS for PostgreSQL

Implemented support of PostgreSQL major version 15 as a migration target.

All

Amazon Redshift

Added a new PrintTaskStatus command in the AWS SCT command line interface (CLI) to display the status of the data migration task.

All

Amazon Redshift

Improved the configuration flow for the data extraction agents.

All

Amazon Redshift

Resolved an error where the data extraction agents didn't display the information about subtasks.

Apache Oozie

AWS Step Functions

Added an option to save state machine definitions as a script in the converted code.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of COALESCE, DATEADD, GETDATE, and SUM functions.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved the conversion of UPDATE statements with JOIN and OUTPUT clauses.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an error that occurred during the conversion of the SELECT TOP 1 WITH TIES statement.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved multiple issues that occurred during the conversion of the FOR XML clauses in built-in functions.

Greenplum

Amazon Redshift

Implemented the conversion of GET DIAGNOSTICS and RAISE statements by using a native Amazon Redshift EXCEPTION block.

Greenplum

Amazon Redshift

Improved the conversion of stored procedures by adding support of an EXCEPTION block in the converted code.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Fixed an error where TO_CHAR function with time format templates were incorrectly converted.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of nested table expressions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of the GOTO, MERGE, REPEAT, and SIGNAL statements.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of FETCH statements with BEFORE and AFTER orientation keywords.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of the FINAL TABLE and OLD TABLE table references.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of the following functions.

  • ADD_MONTHS

  • DAY with parameters of the character data type

  • DAYOFWEEK

  • DAYS

  • DECODE

  • HOUR

  • LAST_DAY

  • LOCATE_IN_STRING

  • MICROSECOND

  • MINUTE

  • MONTH

  • ROUND

  • TIME

  • TIMESTAMP

  • TIMESTAMP_FORMAT

  • TRANSLATE

  • UNICODE_STR

  • XMLCAST

  • XMLELEMENT

  • XMLQUERY

  • XMLSERIALIZE

  • YEAR

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of an alias of a subquery in JOIN clauses.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of COALESCE functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of EXPLICIT indexes.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of column names in compound expressions to resolve an issue where action item 9997 unexpectedly appears during the conversion.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of primary keys and unique constraints.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of XMLTABLE statements in INSERT statements to resolve an issue where action item 9996 unexpectedly appears during the conversion.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of functions with the SUBSTR argument.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of the CURRENT TIMESTAMP special register.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of MERGE statements, unsupported statements, and unsupported built-in functions.

Microsoft SQL Server

All

Added support of Microsoft SQL Server version 2022 as a source.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved the conversion of SELECT statements that use string concatenation operators. AWS SCT uses the STRING_AGG function in the converted code.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Implemented support of the new version 3.1.0 of the Babelfish features configuration file. This file defines SQL features that are supported and not supported by specific Babelfish versions.

Netezza

Amazon Redshift

Resolved an issue where the data extraction agents didn't start data migration from the specified CDC point.

Oracle

All

Updated the assessment report for Oracle databases version 19 as a source.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of the DBMS_OUTPUT package by adding new functions to the AWS SCT extension pack.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of functions and procedures that use associative arrays as arguments or parameters.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved the conversion of DISTINCT clauses in SELECT statements.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved the conversion of tables where the primary key constraint has the same name as the table.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved the conversion of the RAISE_APPLICATION_ERROR procedure with the third parameter.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where the migration rule didn't automatically change the NUMERIC data type to INTEGER where applicable.

Oracle DW

Amazon Redshift

Implemented support of native Amazon Redshift CONNECT BY clauses in the converted code.

Oracle DW

Amazon Redshift

Improved the data migration by automatically adding a subtask for each table or partition in the migration scope. This approach prevents data loss for inserted data after partitioning.

Teradata

Amazon Redshift

Implemented the conversion of recursive views.

Teradata

Amazon Redshift

Improved the conversion of stored procedures that use BTET and ANSI transaction modes by adding support of native Amazon Redshift AUTOCOMMIT transaction mode.

Teradata

Amazon Redshift

Improved the conversion of stored procedures that use TERADATA transaction semantic by adding the NONATOMIC keyword in the converted code.

Teradata

Amazon Redshift RSQL

Resolved an issue where the converted code included the AWS access key ID and secret access key.

Release notes for AWS SCT Build 671

Source Target What's new, enhanced, or fixed

All

All

Fixed an error where AWS SCT didn't have permissions to save a project file in Windows.

All

All

Updated the following AWS SCT command line interface (CLI) templates.

  • BTEQScriptConversion

  • ConversionApply

  • HadoopMigration

  • HadoopResumeMigration

  • Informatica

For more information about the AWS SCT CLI templates, see Getting CLI scenarios.

All

Amazon Redshift

Fixed an error where AWS SCT didn't create an extension pack in the command line interface (CLI).

All

Amazon Redshift

Resolved an issue where AWS SCT data extraction agents didn't use the AWS Snowball configuration in the command line interface (CLI).

Apache Oozie

AWS Step Functions

Implemented support for the migration from Apache Oozie to AWS Step Functions in the command line interface (CLI) mode. After migrating your Hadoop workloads to Amazon EMR, you can now migrate the workflow scheduling system to the AWS Cloud. For more information, see Converting Oozie workflows;.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a resolver error that occurred for tables and aliases.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of INDEX ON clauses.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved the conversion of the following objects to avoid unexpected action items.

  • Batch statements

  • Lists of expressions

  • Table aliases

  • Temporary tables

  • Triggers

  • User variables

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved a parsing error that occurred for procedures.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed an error where AWS SCT used incorrect names of temporary tables in the converted code for OBJECT_ID functions.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved issues where action item 9996 unexpectedly appears during the conversion of the following code elements.

  • CONVERT functions

  • DATEADD functions

  • DELETE statements inside inline functions

  • IF statements

  • INSERT or UPDATE actions on a column

  • RETURN statements

  • UPDATE statements with complex queries or functions

BigQuery

Amazon Redshift

Added support for BigQuery as a source for the multiserver assessment process. For more information, see Multiserver assessment report.

Hadoop

Amazon EMR

Updated the version of the supported Apache Hive JDBC driver that you use to connect to your source databases. For more information, see Installing JDBC drivers for AWS Schema Conversion Tool.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Enhanced the source metadata loader to make sure that AWS SCT loads source database objects such as primary keys, implicit indexes, and so on.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Fixed a resolver error that occurred for columns in implicit cursors.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the ability to keep the formatting of column names, expressions, and clauses in DML statements in the converted code.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of cross schema foreign keys.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of LENGTH and VARCHAR functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of LABEL ON and DECLARE CONDITION statements.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of SELECT statements with OPTIMIZE FOR clauses.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of CREATE TABLE statements by adding default values for all supported data types.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of INCREMENT BY attributes.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of partitioned tables by adding the ability to exclude table partitions from the conversion scope.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of primary key definitions with INCLUDE columns.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of the SUBSTRING function.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of SET and DECLARE HANDLER FOR statements.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of variable data types.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of XMLTABLE functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the migration flow by implementing the following order of applying converted objects to the target database: tables, partitions, indexes, constraints, foreign keys, and triggers.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of comments in the source code.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9997 unexpectedly appears during the conversion of aliases in FROM clauses.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9997 unexpectedly appears during the conversion of cursor aliases.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed an error where the converted code returned different results for SELECT statements with ORDER BY clauses. Because SQL Server and PostgreSQL treat NULL values differently, the converted code now includes NULLS FIRST or NULLS LAST clauses that make sure that your converted code returns results in the same order as your source code.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where data types in table functions were incorrectly converted.

MySQL

Amazon RDS for MySQL

Resolved an issue where single quotation marks (' ') unexpectedly appeared around the database object names in the converted code.

Oracle

Aurora PostgreSQL

PostgreSQL

Added new views to the extension pack to emulate Oracle system views that you use to display information about partitions and subpartitions.

Oracle

Aurora PostgreSQL

PostgreSQL

Updated two functions in the extension pack to add schema names as arguments in the converted code.

Oracle

Aurora PostgreSQL

PostgreSQL

Fixed an error where AWS SCT didn't use the correct parameters for the conversion of C++ applications after refreshing the application code in the user interface.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved the conversion of CREATE TYPE statements to avoid unexpected exceptions.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved the conversion of nested tables.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved a parsing error that occurred for package objects.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where AWS SCT unexpectedly trimmed object names in the converted code when the name length exceeds 60 characters.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where row-level triggers for partitioned tables were incorrectly converted.

Oracle DW

Amazon Redshift

Implemented support of automatic table partitioning for data migration. To speed up data migration, AWS SCT can automatically partition large tables or partitions based on the values in the ROWID pseudocolumn. For more information, see Using native partitioning.

Teradata

Amazon Redshift

Implemented support of native MERGE commands in the converted Amazon Redshift code. For more information about the MERGE command in Amazon Redshift, see MERGE in the Amazon Redshift Database Developer Guide.

Teradata

Amazon Redshift

Improved the conversion of DELETE and UPDATE statements that don't use explicit table names.

Teradata

Amazon Redshift

Resolved an issue where IN and NOT IN statements were incorrectly converted.

Release notes for AWS SCT Build 670

Source Target What's new, enhanced, or fixed

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved issues where action item 9996 unexpectedly appears during the conversion of the following code elements.

  • CREATE INDEX statements inside INCLUDE statements

  • DECLARE statements

  • DECLARE ... TABLE statements

  • DECLARE with default values inside LOOP statements

  • DELETE statements

  • DROP CONSTRAINT statements inside ALTER TABLE statements

  • EXECUTE AS CALLER and REVERT

  • IIF statements

  • Lists of expressions

  • MONTH() functions

  • UPDATE statements

  • YEAR() functions

Azure Synapse Analytics

Amazon Redshift

Added support for Azure Synapse Analytics as a source for the multiserver assessment process. For more information, see Multiserver assessment report.

Hadoop

Amazon EMR

Implemented support for the migration of Hadoop clusters to Amazon EMR in the command line interface (CLI) mode. For more information, see Migrating big data frameworks.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Fixed a resolver error that occurred for source tables and columns.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of CASE expressions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of CURRENT_DATE references to special registers. A reference to a special register in Db2 for z/OS is a reference to a value provided by the current server.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented the conversion of DATE and POSSTR functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of datetime constants.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of default values for columns of the following data types: DATE, TIME, TIMESTAMP, and TIMESTAMP WITH TIME ZONE.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of SELECT INTO statements.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved the conversion of DATEDIFF functions.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed an error where ISNULL functions were converted to NULLIF. As a result, the converted code produced different results compared to the source code. Now, AWS SCT converts ISNULL functions to COALESCE.

Netezza

Amazon Redshift

Improved data extraction agents to resolve an issue where the failed status was set for tasks that were completed successfully.

Netezza

Amazon Redshift

Added the ability to change endpoints in subtasks after starting a data migration with data extraction agents.

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

Aurora MySQL

Aurora PostgreSQL

MySQL

PostgreSQL

Added the ability to connect to databases using an IPv6 address protocol.

Oracle

Amazon RDS for Oracle

Implemented conversion of the DBMS_JOB package which schedules and manages jobs in the job queue.

Oracle

Aurora PostgreSQL

PostgreSQL

Added new functions to the extension pack to improve the conversion of the global nested tables. These new functions emulate DELETE, EXTEND, and TRIM functions in your source Oracle code.

Oracle

Aurora PostgreSQL

PostgreSQL

Added the ability to specify the conversion scope for SQL code that is embedded in Java applications. You can now exclude the subsets of the source application project from the conversion scope. For more information, see Converting your Java application SQL code in AWS SCT.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of concatenation operators (||) inside functional indexes.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of IN conditions where your source code doesn't include parentheses for a single expression.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of MERGE statements to INSERT ON CONFLICT in PostgreSQL.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved a parsing error that occurred for packages of procedures.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 5072 unexpectedly appears during the conversion of packages.

Oracle DW

Amazon Redshift

Fixed an error where AWS SCT didn't apply the extension pack when applying the converted code to the target database.

Oracle DW

Amazon Redshift

Fixed an error where AWS SCT didn't apply some of the extension pack files when using the extension pack wizard.

Oracle DW

Amazon Redshift

Resolved an issue where AWS SCT couldn't process the data migration to AWS Snowball with more than 500 tasks running in parallel.

Oracle DW

Amazon Redshift

Resolved an issue where user-defined functions with user-defined types were incorrectly converted.

Release notes for AWS SCT Build 669

Source Target What's new, enhanced, or fixed

All

All

Improved the multiserver assessment process, which helps determine the optimal target database platform for your source databases. Now, AWS SCT ignores the AWS Secrets Manager key if you provide database credentials in the input comma separated values (CSV) file. For more information, see Multiserver assessment report.

All

All

Resolved an issue where the multiserver assessment report included the IP address of your source database when using a secret from AWS Secrets Manager to connect to the database.

All

Amazon Redshift

Implemented automatic configuration of Java virtual machine (JVM) settings depending on the operating system and available RAM. AWS SCT uses this JVM to run data extraction agents work.

All

Amazon Redshift

Resolved an issue where the data extraction agents don't start in Ubuntu.

All

Amazon Redshift

Resolved an issue where the data extraction tasks don't start after running the StartAgent.bat file in Windows.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where column names were incorrectly converted with the Generate unique names for indexes option turned on.

Greenplum

Amazon Redshift

Implemented conversion of functions that return VOID to procedures.

Greenplum

Amazon Redshift

Resolved an issue where data migration failed when the source database included not a numeric (NaN) values in numeric columns. AWS SCT data extraction agents now replace NaN values with NULL.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Added a new conversion setting to specify the DATE FORMAT and TIME FORMAT options during the conversion of CHAR built-in functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Added an action item 8534 for the conversion of predefined cursors that were declared with the WITHOUT RETURN clause. If your cursor doesn't return result sets, AWS SCT assigns a NULL value to your cursor name in the converted code and raises an action item.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Edited the CURRENT CLIENT_APPLNAME property that identifies AWS SCT during the connection to the source database.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented a new conversion setting to specify the DATE FORMAT and TIME FORMAT options during the conversion of CHAR built-in functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented conversion of LEAVE statements in BEGIN...END block statements.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented conversion of XMLPARSE, XMLTABLE, and XMLNAMESPACES functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved conversion of CHAR built-in functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved conversion of cursors.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of FOR loop statements.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of the table types usage in SELECT statements.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Implemented support of the new version 2.2.0 of the Babelfish features configuration file. This file defines SQL features that are supported and not supported by specific Babelfish versions.

Netezza

Amazon Redshift

Improved data extraction agents to resolve an issue where one row wasn't deleted from the target table during ongoing data replication.

Oracle

Amazon RDS for Oracle

Improved conversion of Oracle Database Enterprise Edition features.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented conversion of GROUPING_ID functions.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved SQL code conversion in C# applications by adding support of custom data type mapping in the command line interface (CLI) mode.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of nested tables to avoid an unexpected action item 9996.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where the call of an object constructor was incorrectly converted.

Oracle DW

Amazon Redshift

Implemented support of existing table partitions for data migration. To speed up data migration, AWS SCT creates subtasks for each partition of the source table that isn't empty. For more information, see Using native partitioning.

Teradata

Amazon Redshift

Improved conversion of CAST functions with TIME WITH TIME ZONE AS TIMESTAMP, TIME WITH TIME ZONE AS CHAR, and TIMESTAMP AS TIME WITH TIME ZONE arguments.

Teradata

Amazon Redshift

Improved conversion of CAST functions with the FORMAT option.

Teradata

Amazon Redshift

Resolved an issue where CEIL functions weren't converted.

Teradata

Amazon Redshift

Resolved an issue where MERGE statements with DELETE clauses were incorrectly converted.

Teradata

Amazon Redshift

Resolved an issue where TO_CHAR functions with date and format arguments were incorrectly converted.

Release notes for AWS SCT Build 668

Source Target What's new, enhanced, or fixed

All

Amazon Redshift

Resolved an issue where multiplication operators in migration rules didn't work correctly. These operators make it possible to change the length of char, varchar, nvarchar, and string data types. For more information, see Creating migration rules.

Azure Synapse Analytics

Amazon Redshift

Implemented support of CONVERT functions with VARCHAR arguments.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of SELECT statements with NOLOCK clauses.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of UPDATE statements with aliases or with SET and FROM clauses.

Greenplum

Amazon Redshift

Implemented automatic virtual partitioning for data migration. AWS SCT uses the GP_SEGMENT_ID system column to create partitions.

Greenplum

Amazon Redshift

Implemented support of RETURN QUERY and RETURN SETOF clauses.

Greenplum

Amazon Redshift

Implemented support of SUBSTRING functions with three parameters.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved conversion of SUBSTR functions with LOCATE parameters.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Added an option to use an array of REFCURSOR variables to return dynamic result sets. When you select this option in conversion settings, AWS SCT adds an additional OUT parameter in the converted code.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented support of FOR loop statements.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Implemented support of XMLPARSE functions. Added an action item 8541 for the white space striping in XMLPARSE functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved the conversion of multiple exception handlers in a single BEGIN ... END block.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of INSERT and DELETE triggers.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of nested procedure calls.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of table types.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where bitwise logical NOT operations were incorrectly converted for integer values.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where local arrays were not initialized in PostgreSQL version 8.0.2 and lower.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where MERGE statements with WHEN NOT MATCHED BY SOURCE clauses were incorrectly converted.

MySQL

Aurora MySQL

Resolved an issue where AWS SCT incorrectly determined the user permissions that were granted by the rds_superuser_role role.

Netezza

Amazon Redshift

Enhanced the source metadata loader to ensure that AWS SCT correctly loads database objects with names in lowercase.

Oracle

Aurora PostgreSQL

PostgreSQL

Added new functions to the extension pack to improve conversion of local nested tables. These new functions emulate PRIOR, NEXT, LIMIT, FIRST, LAST, EXISTS, EXTEND, TRIM, DELETE, and SET functions in your source Oracle code. For more information, see Extension packs.

Oracle

Aurora PostgreSQL

PostgreSQL

Added the ability to specify the conversion scope for C# applications. Users can now exclude the subsets of the source application project from the conversion scope.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented support of COUNT methods in collections.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented support of variables and constructors in nested tables.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented support of RATIO_TO_REPORT and STANDARD_HASH functions.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of large objects (LOBs) as part of the AWS SCT extension pack.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of local collections.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of JOIN statements with USING clauses where column names don't include the table name.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented conversion of EMPTY_BLOB and EMPTY_CLOB functions.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented conversion of positional bind variables in C# applications.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Implemented conversion of multi-event triggers.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Implemented conversion of recursive triggers.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Improved conversion of triggers with the @@rowcount global variable.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Resolved an issue where aggregate functions in the SET clause of UPDATE statements were incorrectly converted.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Resolved an issue where action item 42702 unexpectedly appears during the conversion of UPDATE statements.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Resolved an issue where CONVERT functions with CHAR arguments were incorrectly converted.

Snowflake

Amazon Redshift

Added support of Snowflake as a source for data migration with AWS SCT data extraction agents. For more information, see Migrating data from on-premises data warehouse to Amazon Redshift with AWS Schema Conversion Tool.

Teradata

Amazon Redshift

Improved conversion of CAST functions with TIMESTAMP AS TIME WITH TIMEZONE arguments.

Release notes for AWS SCT Build 667

Source Target What's new, enhanced, or fixed

All

All

Implemented support of Informatica extract, transform, and load (ETL) scripts in the command line interface (CLI) mode. AWS SCT automatically redirects your Informatica ETL scripts to the new target database. Also, AWS SCT converts object names and SQL code that is embedded in your Informatica objects. For more information, see Informatica ETL scripts.

All

Amazon Redshift

Increased the minimum supported driver version for Amazon Redshift to 2.1.0.9. For more information, see Installing JDBC drivers for AWS Schema Conversion Tool.

Azure Synapse Analytics

Amazon Redshift

Added a new function to the extension pack to improve conversion of the CONVERT function with three date and time arguments.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of the DATEDIFF function.

Azure Synapse Analytics

Microsoft SQL Server DW

Amazon Redshift

Updated the extension pack version. Make sure that you apply the latest version of the extension pack in your existing AWS SCT projects. For more information, see Extension packs.

BigQuery

Amazon Redshift

Resolved an issue where the filtered objects weren't converted in the command line interface (CLI) mode.

Greenplum

Amazon Redshift

Fixed an error where AWS SCT didn't convert temporary tables that are declared in a stored procedure.

Greenplum

Amazon Redshift

Fixed an error where column encoding attributes were missing in the converted code.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Implemented conversion of UPDATE statements for self-referencing tables that have more than one INNER JOIN clauses.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Implemented support of inserted and deleted temporary tables that SQL Server uses for DML triggers.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of user-defined types in stored procedures that were created in different database schemas. Resolved an issue where AWS SCT couldn't find the data type and displayed an action item 9996.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where square brackets ([ ]) unexpectedly appeared around the database object names in the converted code.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where @@ROWCOUNT functions were incorrectly converted.

Microsoft SQL Server DW

Amazon Redshift

Implemented support of geometry and geography data types.

Microsoft SQL Server DW

Amazon Redshift

Implemented support of the MAX keyword in data type declarations in the converted code.

Microsoft SQL Server DW

Amazon Redshift

Improved conversion of DATEADD functions.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved SQL code conversion in Java applications by adding support for the MyBatis framework. For more information, see SQL code in Java.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved SQL code conversion in Java applications that use the MyBatis framework. Added an action item 30411 for SQL code with unsupported syntax.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved SQL code conversion in Pro*C applications by adding support for typedef struct declarations.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented support of CROSS JOIN and LEFT JOIN statements.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of MERGE statements. Resolved an issue where values to insert were missing in the converted code.

Teradata

Amazon Redshift

Changed the default column compression encoding settings that AWS SCT uses in the converted code to match the default Amazon Redshift settings. For more information, see Compression encodings in the Amazon Redshift Database Developer Guide.

Teradata

Amazon Redshift

Resolved an issue where mathematical operations that use the TIME data type were incorrectly converted.

Teradata

Amazon Redshift RSQL

Implemented conversion of FastExport code that is inside shell scripts.

Teradata BTEQ

Amazon Redshift RSQL

Fixed an error where AWS SCT didn't convert COALESCE and %data statements.

Vertica

Amazon Redshift

Improved conversion optimization suggestions when a user selects one optimization strategy.

Release notes for AWS SCT Build 666

Source Target What's new, enhanced, or fixed

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved a parsing error that occurred for ON clauses that are inside JOIN statements.

Azure Synapse Analytics

Amazon Redshift

Added three new functions to the extension pack to improve conversion of the CONVERT function with date and time arguments.

Azure Synapse Analytics

Amazon Redshift

Enhanced the source metadata loader to ensure that AWS SCT loads system database schemas.

Azure Synapse Analytics

Amazon Redshift

Fixed a resolver error that occurred for columns of temporary tables.

Azure Synapse Analytics

Amazon Redshift

Implemented conversion of BINARY and VARBINARY data types to the VARBYTE data type.

Azure Synapse Analytics

Amazon Redshift

Implemented support of the TIME data type in the converted code.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of COLLATE clauses. Resolved an issue where action item 31141 unexpectedly appears during the conversion of columns with the default database collation.

BigQuery

Amazon Redshift

Implemented conversion of procedures that change input parameters.

Greenplum

Amazon Redshift

Resolved an issue where AWS SCT used a query that isn't compatible with Greenplum 6.x databases.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved conversion of EXCEPTION sections by transferring exception handlers from Db2 for z/OS to PostgreSQL.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Improved conversion of OPEN CURSOR statements.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Implemented conversion of IIF functions by using CASE expressions.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where procedures with table-valued parameters were incorrectly converted when the CREATE PROCEDURE statement didn't include a BEGIN...END block.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where the SCOPE_IDENTITY function was incorrectly converted.

Oracle

Amazon RDS for Oracle

Fixed a loader error that occurred with the SELECT_CATALOG_ROLE role when using Oracle 10g as a source.

Oracle

Amazon RDS for Oracle

Improved the loader to support Oracle Scheduler jobs.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented conversion of JOIN statements with USING clauses.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved performance of the converted code where the source code includes global variables in WHERE clauses.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved SQL code conversion in Java applications by adding support for the MyBatis framework. For more information, see SQL code in Java.

Oracle DW

Amazon Redshift

Implemented conversion of the PIVOT and UNPIVOT relational operators.

Teradata

Amazon Redshift

Fixed an error where source code that uses JSON objects wasn't converted.

Teradata

Amazon Redshift

Fixed an error where the tables created by a dropped user weren't correctly loaded.

Teradata

Amazon Redshift

Implemented conversion of INSTR functions to native Amazon Redshift STRPOS functions.

Teradata

Amazon Redshift

Implemented conversion of the NVP and TRANSLATE functions.

Teradata

Amazon Redshift

Improved conversion of COALESCE expressions.

Teradata

Amazon Redshift

Improved conversion of DECLARE CONDITION statements.

Teradata

Amazon Redshift

Improved conversion of EXTRACT functions with the SECOND syntax element.

Teradata

Amazon Redshift

Improved conversion of the SQLSTATE and SQLCODE variables inside the LOOP statements.

Teradata

Amazon Redshift

Improved conversion of unique indexes.

Teradata

Amazon Redshift

Resolved an issue where action item 9996 unexpectedly appears during the conversion of CURRENT_TIMESTAMP statements with fractional precision set to 3.

Teradata

Amazon Redshift

Resolved an issue where backslashes were incorrectly converted in string literals.

Teradata

Amazon Redshift

Resolved an issue where converted EXEC statements included an incorrect field name in the ADD CONSTRAINT statement.

Teradata

Amazon Redshift

Resolved an issue where converted QUALIFY subqueries included an incorrect subquery name.

Teradata

Amazon Redshift

Resolved an issue where converted views weren't applied. Added an explicit cast to a specific data type for NULL values in the converted code.

Teradata

Amazon Redshift

Resolved an issue where date and time functions were incorrectly converted.

Teradata

Amazon Redshift

Resolved an issue where hexadecimal string literals weren't converted.

Release notes for AWS SCT Build 665

Source Target What's new, enhanced, or fixed

Azure Synapse Analytics

Amazon Redshift

Implemented conversion of CONCAT functions with VARCHAR arguments.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of CREATE TABLE statements that create temporary tables and don't include the schema name. AWS SCT creates the dbo schema to store these temporary tables in the target database.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of DROP TABLE statements that you run on temporary tables.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of OBJECT_ID statements with the BEGIN...END blocks.

Azure Synapse Analytics

Amazon Redshift

Resolved an error where the AWS SCT couldn't convert stored procedures with block comments.

BigQuery

Amazon Redshift

Implemented conversion of BigQuery data warehouses to Amazon Redshift. For more information, see Connecting to Google BigQuery with AWS Schema Conversion Tool.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of triggers that handle multiple events and work with inserted and deleted system tables in SQL Server.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a resolver error that occurred for inserted and deleted system tables in SQL Server.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Implemented support of the new version 2.1.0 of the Babelfish features configuration file. This file defines SQL features that are supported and not supported by specific Babelfish versions.

Oracle

Aurora MySQL

MariaDB

MySQL

Resolved an issue where the varchar2 data type was incorrectly converted.

Oracle

Aurora MySQL

Aurora PostgreSQL

MariaDB

MySQL

PostgreSQL

For Oracle databases version 12c and higher, AWS SCT supports the following extended data types:

  • VARCHAR2

  • NVARCHAR2

  • RAW

AWS SCT increased the maximum supported column length from 8,000 to 32,767 bytes for these data types.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved a parsing error that occurred for the Oracle Event Processing package.

Teradata

Amazon Redshift

Added an action item 13214 for multiple RESET WHEN clauses in a single SELECT statement.

Teradata

Amazon Redshift

Added an action item for SQLSTATE variables that are located outside of an exception handling block.

Teradata

Amazon Redshift

Implemented conversion of ACTIVITY_COUNT variables to ROW_COUNT.

Teradata

Amazon Redshift

Implemented conversion of the built-in geometry ST_TRANSFORM function.

Teradata

Amazon Redshift

Improved conversion of delete statements in views without the WHERE clause.

Teradata

Amazon Redshift

Improved conversion of CAST operators in expressions.

Teradata

Amazon Redshift

Improved conversion of GROUP BY clauses.

Teradata

Amazon Redshift

Improved conversion of INSTR and REGEXP_INSTR built-in functions.

Teradata

Amazon Redshift

Resolved an issue where lateral column alias references were incorrectly converted.

Teradata

Amazon Redshift

Resolved an issue where column names were incorrectly converted in the QUALIFY subquery.

Teradata

Amazon Redshift

Implemented conversion of .QUIT commands with the ERRORCODE status value keyword.

Teradata BTEQ

Amazon Redshift RSQL

Resolved an issue where action item 9996 unexpectedly appears during the conversion of CREATE statements.

Teradata BTEQ

Amazon Redshift RSQL

Resolved an issue where action item 9998 unexpectedly appears during the conversion of END statements.

Release notes for AWS SCT Build 664

Source Target What's new, enhanced, or fixed

All

All

Added support of Amazon Redshift Serverless as a source and target for database migration projects in AWS SCT. To connect to Amazon Redshift Serverless, make sure that you use the Amazon Redshift JDBC driver version 2.1.0.9 or higher.

All

All

Improved the user interface of the Conversion settings window. AWS SCT now displays settings only for database conversion pairs with created mapping rules. For more information, see Data type mapping.

All

All

Updated the assessment report to remove duplicate information about the line and position of the action item.

All

Amazon Redshift

Implemented automatic memory balancing in data extracting tasks.

All

Amazon Redshift

Resolved an error where the data extraction agents couldn't connect to AWS Snowball devices.

Azure SQL Database

IBM Db2 for z/OS

IBM Db2 LUW

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

SAP ASE

Aurora MySQL

Aurora PostgreSQL

MariaDB

MySQL

PostgreSQL

Implemented support of SUSE Linux 15.3 as a platform to run data extraction agents.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of DATEADD functions.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Added the ability to change column collation in migration rules.

Microsoft SSIS

AWS Glue

AWS Glue Studio

Resolved an unexpected error that occurred when users select a source script.

Oracle

Aurora MySQL

MariaDB

MySQL

Implemented conversion of the usage of stored functions as generated column expressions. AWS SCT creates triggers to emulate this behavior because MySQL doesn't support the usage of stored functions as generated column expressions.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented conversion of functions from the UTL_MATCH package as part of the AWS SCT extension pack.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented conversion of the REGEXP_LIKE function with the NULL parameter.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of the SYS_EXTRACT_UTC function.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved SQL code conversion in C++ applications by implementing support of Wcscats, Wcscpys, and Wcsncats functions. For more information, see Converting SQL code in C++ applications with AWS Schema Conversion Tool.

Oracle DW

Snowflake

Amazon Redshift

Resolved an issue where converted statements don't include explicit conversion of values to the column data type. This issue occurred in statements that use query results from other tables.

Teradata

Amazon Redshift

Added the ability to change column collation between case sensitive and case insensitive in migration rules. For more information, see Applying migration rules.

Teradata

Amazon Redshift

Fixed a resolver error that occurred for CREATE TABLE AS statements.

Teradata

Amazon Redshift

Fixed an error where the built-in P_INTERSECT function with a COALESCE expression wasn't converted.

Teradata

Amazon Redshift

Implemented conversion of columns named OID to _OID to avoid the usage of a reserved keyword in Amazon Redshift.

Teradata

Amazon Redshift

Implemented conversion of RENAME statements for functions, procedures, views, and macros.

Teradata

Amazon Redshift

Implemented conversion of the STROKE function to the SPLIT_PART function in Amazon Redshift.

Teradata

Amazon Redshift

Improved conversion of the INSTR and REGEXP_INSTR system functions.

Teradata

Amazon Redshift

Improved conversion of the TIME data type.

Teradata

Amazon Redshift

Improved emulation of the SET and MULTISET tables by implementing conversion of primary and secondary unique indexes.

Teradata

Amazon Redshift

Resolved a parsing error that occurred for the CHARACTER function.

Teradata BTEQ

Amazon Redshift RSQL

Resolved an error that occurred when users removed Teradata Basic Teradata Query (BTEQ) scripts from the AWS SCT project.

Release notes for AWS SCT Build 663

Source Target What's new, enhanced, or fixed

All

All

Added the ability to change the length of char, varchar, nvarchar, and string data types using the multiplication operator in a migration rule. For more information, see Applying migration rules.

All

All

Implemented support of three new columns in the multiserver assessment report and updated the format of the input file. Make sure that you use the updated template of the input file with the latest version of AWS SCT. For more information, see Creating a multiserver assessment report in AWS Schema Conversion Tool.

Azure Synapse Analytics

Amazon Redshift

Improved conversion of OBJECT_ID statements.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Added support for Babelfish for Aurora PostgreSQL 1.2.0 as a target platform for database migration assessment reports. For more information, see Supported functionality in Babelfish by version in the Amazon Aurora User Guide.

Microsoft SQL Server DW

Amazon Redshift

Added support for AT TIME ZONE clauses.

Microsoft SQL Server DW

Amazon Redshift

Resolved an issue where a statement outside the BEGIN/END block was incorrectly converted.

Netezza

Amazon Redshift

Improved conversion of the TIME data type and implemented conversion of related built-in functions, expressions, and literals.

Oracle

Aurora PostgreSQL

PostgreSQL

Fixed a loader error that occurred when using Oracle 10g as a source.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of OFFSET and FETCH clauses.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where procedures with OUT parameters with default values were incorrectly converted.

Oracle DW

Amazon Redshift

Improved conversion of Oracle functions to Amazon Redshift user-defined functions.

Snowflake

Amazon Redshift

Improved conversion of WITH clauses.

Teradata

Amazon Redshift

Added a new action item 13209 for unsupported multibyte characters for the CHAR data type.

Teradata

Amazon Redshift

Fixed a loader error where the tables weren't fully loaded.

Teradata

Amazon Redshift

Fixed a transformer error where the built-in P_INTERSECT function in a JOIN condition wasn't converted.

Teradata

Amazon Redshift

Fixed an issue where the name of a view was converted in wrong case when the SELECT statement was run on a table with special characters in its name.

Teradata

Amazon Redshift

Improved conversion of INSERT statements with the UNTIL_CHANGED value in the PERIOD(DATE) data type.

Teradata

Amazon Redshift

Improved conversion of the built-in FORMAT function using the TO_CHAR function in Amazon Redshift.

Teradata

Amazon Redshift

Improved conversion of the built-in RANK function to make sure that the converted code returns NULL values in the same order as the source code.

Teradata

Amazon Redshift

Improved conversion of unique constraints such as primary or secondary unique indexes.

Release notes for AWS SCT Build 662

Source Target What's new, enhanced, or fixed

All

All

Added the ability to automatically create AWS SCT projects for each source database when creating the multiserver assessment report. With this option turned on, AWS SCT can add mapping rules to these projects and save conversion statistics for offline use. For more information, see Creating a multiserver assessment report in AWS Schema Conversion Tool.

All

All

Implemented support of the percent (%) as a wildcard in database and schema names when creating the multiserver assessment report.

All

Aurora MySQL

Aurora PostgreSQL

Updated the runtime of all AWS Lambda functions to Python version 3.9.

All

Amazon Redshift

Upgraded all data extraction agents to use AWS SDK for Java 2.x.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of DELETE statements with NON EXISTS clauses.

Azure Synapse Analytics

Amazon Redshift

Resolved an error where the connection to a source database failed.

IBM Db2 for z/OS

Aurora PostgreSQL

PostgreSQL

Resolved an error where the converted code of a trigger included two mentions of the object alias.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of objects with names in mixed case when the Treat database object name as case sensitive option is turned on.

Microsoft SQL Server DW

Teradata

Amazon Redshift

Implemented conversion of the PIVOT and UNPIVOT relational operators.

Netezza

Amazon Redshift

Implemented conversion of the TIME data type.

Oracle

Aurora MySQL

Aurora PostgreSQL

MySQL

PostgreSQL

Implemented the UTL_TCP.CRLF package constant conversion.

Oracle

Aurora PostgreSQL

PostgreSQL

Fixed an extension pack issue where the length of data types for columns of variable length wasn't maintained during conversion.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented SQL code conversion in C++ applications. For more information, see Converting SQL code in C++ applications with AWS Schema Conversion Tool.

Oracle

Aurora PostgreSQL

PostgreSQL

Implemented support of case sensitive naming for the conversion of global variables and associative arrays.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of the TO_CHAR, TO_DATE, and TO_NUMBER functions in the extension pack.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of the TABLE() operator.

Oracle DW

Amazon Redshift

Added support for conversion of primary keys and other constraints.

Oracle DW

Amazon Redshift

Fixed a problem where action item 12054 doesn't appear during the conversion of conditional statements.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Resolved an error when an object with an empty name was created in the target tree during the conversion of tables with columns of user-defined type.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Fixed a loader error for stored objects such as scripts, routines, and so on.

Snowflake

Amazon Redshift

Fixed a problem where action item 22152 doesn't appear when required and AWS SCT displays the conversion result as a comment.

Snowflake

Amazon Redshift

Improved conversion of the date and time functions; implemented support of time zones.

Snowflake

Amazon Redshift

Resolved an issue where non-recursive common table expressions (CTEs) with a WITH clause were converted as recursive CTEs.

Teradata

Amazon Redshift

Improved conversion of UPDATE statements with table links in condition.

Teradata

Amazon Redshift

Improved conversion of RENAME TABLE statements.

Teradata

Amazon Redshift

Resolved an issue where empty columns appeared in the comma-separated value (CSV) file with an assessment report.

Teradata

Amazon Redshift RSQL

Fixed an error where a semicolon was missing in the end of the converted a Basic Teradata Query (BTEQ) macro.

Teradata

Amazon Redshift RSQL

Improved conversion of multiple data type values in CASE statements.

Teradata

Amazon Redshift RSQL

Improved conversion of the LIKE ANY clause with an ESCAPE character.

Teradata

Amazon Redshift RSQL

Improved conversion of the CAST function in INSERT statements.

Teradata

Amazon Redshift RSQL

Improved conversion of the time zones, implemented time zone region mapping.

Teradata

Amazon Redshift RSQL

Resolved an issue where action item 9998 unexpectedly appears during the conversion of shell scripts with BTEQ scripts.

Teradata

Amazon Redshift RSQL

AWS Glue

Implemented the limit of 500 characters for the values of substitution variables.

Vertica

Amazon Redshift

Implemented conversion of the BINARY, VARBINARY, LONG BINARY, BYTEA, and RAW data types to the VARBYTE data type.

Vertica

Amazon Redshift

Improved conversion of the built-in functions and literals.

Release notes for AWS SCT Build 661

Source Target What's new, enhanced, or fixed

All

All

Added filters to search for mapping rules in the mapping view. When you apply a filter, AWS SCT displays rules that match the filtering conditions in the Server mappings list. For more information, see Editing data type mappings in the AWS Schema Conversion Tool.

All

All

Upgraded Apache Log4j to version 2.17.1.

All

Amazon Redshift

Added support of data migration to Amazon Redshift using the ENCRYPTED clause in the COPY command.

All

Amazon Redshift

Enhanced the REST API of the data extraction agents. The updated REST API adds support of new properties such as encryption key, encryption type, and so on.

All

Amazon Redshift

Implemented role assuming in the data extraction agents. This update improves the distribution of subtasks, and enables AWS SCT to assign tasks to free agents of the specified role.

All

Amazon Redshift

Implemented a check that all required components are installed before the extension pack is applied to Amazon Redshift.

Azure Synapse Analytics

Microsoft SQL Server DW

Amazon Redshift

Improved conversion of the ERROR_LINE, ERROR_MESSAGE, ERROR_NUMBER, ERROR_PROCEDURE, ERROR_SEVERITY, and ERROR_STATE system functions for error handling.

IBM Db2 for z/OS

Aurora MySQL

Aurora PostgreSQL

MySQL

PostgreSQL

Added support of IBM Db2 for z/OS version 12 as a source for database migration projects in AWS SCT. For more information, see Connecting to IBM DB2 for z/OS.

IBM Db2 LUW

All

Enhanced the source metadata loader to ensure that AWS SCT loads routine parameters that duplicate column names.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a transformer error for procedures with the SET NOCOUNT ON set statement.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of the CONCAT function when an input value is a variable of the user-defined type.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where the DATEPART function was incorrectly converted.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Implemented support of the new version of the Babelfish features configuration file. This file defines SQL features that are supported and not supported by specific Babelfish versions.

Microsoft SQL Server DW

Amazon Redshift

Resolved an issue where procedures with an EXECUTE statement were incorrectly converted.

Microsoft SSIS

AWS Glue

Improved the user interface of the job configuration wizard. AWS SCT now displays only available connections in the connection configuration section.

Microsoft SSIS

AWS Glue

Resolved an issue where the transformation rules weren't applied to package tasks and variable rules.

Microsoft SSIS

AWS Glue

AWS Glue Studio

Added a new action item 25042 for unsupported components.

Microsoft SSIS

AWS Glue Studio

Implemented conversion of Microsoft SQL Server Integration Services (SSIS) extract, transform, and load (ETL) packages to AWS Glue Studio. For more information, see SSIS to AWS Glue Studio.

Oracle

MariaDB

Fixed a problem with conversion of the MINUS operator.

Oracle

MariaDB

Improved conversion of the ROWNUM, SYS_GUID, TO_CHAR, and ADD_MONTHS functions when the sql_mode system variable in MariaDB is to Oracle.

Oracle

PostgreSQL

Added an option to avoid conversion of bind variables types to SQL types in generic application conversion projects.

Oracle

PostgreSQL

Added an option to avoid adding the schema name to the name of the converted object in generic application conversion projects.

Oracle

PostgreSQL

Added support of the ?x bind variable format for application SQL code conversion.

Oracle DW

Amazon Redshift

Implemented conversion of the RAW data type to the VARBYTE data type.

Teradata

Amazon Redshift

Added an option to emulate SET tables in the converted code. For this emulation, AWS SCT supports MIN and MAX conditions.

Teradata

Amazon Redshift

Improved conversion of join operations that have parameters of different data types. This update enables AWS SCT to apply transformation rules during conversion of such operations.

Teradata

Amazon Redshift

Resolved an issue where the GROUP BY clause was incorrectly converted.

Teradata

Amazon Redshift

Resolved an issue where the QUALIFY clause was incorrectly converted.

Teradata

Amazon Redshift

Resolved an unexpected error occurred during FastExport scripts import.

Teradata

Amazon Redshift RSQL

Implemented the ability to edit the values of variables in Teradata BTEQ and shell scripts.

Teradata

Amazon Redshift RSQL

Resolved an issue where the manifest script was missing for the converted Teradata FastLoad sessions.

Teradata

Amazon Redshift RSQL

Resolved an issue where the extension of the manifest file was missing in the uniform resource locator (URL) for the converted FastLoad scripts.

Teradata BTEQ

Amazon Redshift RSQL

Fixed a loader error for scripts with substitution variables.

Teradata BTEQ

Amazon Redshift RSQL

Fixed a problem where action item 27022 doesn't appear when required.

Release notes for AWS SCT Build 660

Source Target What's new, enhanced, or fixed

All

All

Added support of AWS Secrets Manager and Secure Sockets Layer (SSL) in the multiserver assessment report. For more information, see Creating a multiserver assessment report in AWS Schema Conversion Tool.

All

All

Improved statistics collection for converted objects.

All

PostgreSQL

Implemented support of PostgreSQL major version 14 and MariaDB 10.6 as migration targets.

Azure Synapse Analytics

Amazon Redshift

Improved transformation logic for the names of converted objects.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

Improved conversion of the XML data type.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where NOT LIKE clauses were incorrectly converted.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a transformer error for procedures with INSERT, DELETE, and UPDATE statements that include the OUTPUT clause.

Microsoft Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a transformer error for procedures with the RETURN @@ROWCOUNT statement.

Microsoft SQL Server

All

Improved conversion of procedures that use linked servers.

Microsoft SQL Server

All

Added support of Microsoft Windows Authentication in the multiserver assessment report.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a transformer error for table value constructors.

Microsoft SQL Server DW

Amazon Redshift and AWS Glue

Improved conversion of extract, transform, and load (ETL) scripts to include the correct path to the converted scripts.

Microsoft SQL Server DW

Amazon Redshift

Resolved an issue where different converted scripts were generated for virtual and real target database platforms.

Oracle

PostgreSQL

Aurora PostgreSQL

Added support for conversion of indexes for materialized views.

Oracle

PostgreSQL

Aurora PostgreSQL

Fixed a problem where action item 5982 doesn't appear when converting PRIMARY KEY and UNIQUE constraints with the NOVALIDATE option.

Oracle DW

Amazon Redshift

Resolved an issue where additional categories were displayed in the converted schema.

Teradata

Amazon Redshift

Fixed a problem where action item 13185 doesn't appear when converting an unresolved column as an argument of the CAST function.

Teradata

Amazon Redshift

Improved conversion of DELETE and DELETE ALL statements to use the TRUNCATE command in the converted code.

Teradata

Amazon Redshift

Improved conversion of SET tables.

Teradata

Amazon Redshift

Improved conversion of NORMALIZE condition.

Teradata

Amazon Redshift

Updated the assessment report to remove the database schema conversion statistics from the list of database storage objects.

Teradata

Amazon Redshift

Improved conversion of the UPDATE statement without the FROM clause.

Teradata

Amazon Redshift

Implemented support of the VARBYTE data type in the converted code.

Teradata BTEQ

AWS Glue

Resolved an issue where the Convert to AWS Glue option was deactivated in the context menu.

Teradata BTEQ

Amazon Redshift RSQL

Resolved an issue where data types were missing in the converted code.

Teradata BTEQ

Amazon Redshift RSQL

Resolved an issue where substitution variables were incorrectly quoted in the converted code.

Teradata BTEQ

Amazon Redshift RSQL

Fixed a problem with conversion of substitution variables with values in FastLoad scripts.

Vertica

Amazon Redshift

Implemented support of the TIME data type in the converted code.

Vertica

Amazon Redshift

Improved conversion of SELECT DISTINCT and ORDER BY expressions.

Vertica

Amazon Redshift

Added support for conversion of constraints.

Vertica

Amazon Redshift

Resolved an error where an assessment report wasn't saved as a comma-separated value (CSV) file.

Release notes for AWS SCT Build 659

Source Target What's new, enhanced, or fixed

All

All

Improved the New project wizard that generates a combined assessment report for multiple source databases.

All

All

Fixed an issue where the extension pack wasn't created in projects that include multiple source and target databases.

All

All

Improved conversion of SQL code that is embedded in application source code.

All

All

Added the ability to run scripts from different folders in the AWS SCT command-line interface.

All

Amazon Redshift

Improved the warning message provided when users choose Run optimization in migration projects with the Amazon Redshift virtual target database platform.

All

Aurora PostgreSQL

Implemented support of PostgreSQL major version 13 on Aurora PostgreSQL-Compatible Edition as a migration target.

All

Amazon RDS for MySQL

Implemented the case insensitive code conversion by default.

Azure Synapse Analytics

Amazon Redshift

Resolved an error where the connection to a source database failed in the command-line interface.

Microsoft SQL Server

PostgreSQL

Aurora PostgreSQL

Improved conversion of procedures that include UPDATE statements with join conditions.

Microsoft SQL Server

PostgreSQL

Aurora PostgreSQL

Improved conversion of triggers, stored procedures, and functions that include the value after the equal sign.

Microsoft SQL Server

PostgreSQL

Aurora PostgreSQL

Fixed a transformer error for procedures with the DELETE statement and the OR operator.

Microsoft SQL Server

PostgreSQL

Aurora PostgreSQL

Improved conversion of the OUTPUT clause.

Microsoft SQL Server DW

Amazon Redshift and AWS Glue

Improved conversion of the NUMERIC data type.

Microsoft SQL Server DW

Amazon Redshift

Improved conversion of views which have a table alias with same name as the original table.

Microsoft SSIS

AWS Glue

Fixed an issue where the AWS Glue connection credentials weren't displayed in the Configure connections window.

Netezza

Amazon Redshift

Added the ability to repeat the run of change data capture (CDC) data migration tasks every day.

Netezza

Amazon Redshift

Fixed an issue where the Tasks tab becomes inactive after unregistering a data extraction agent.

Netezza

Amazon Redshift

Fixed an issue where the confirmation of the registration of the data migration agent didn't display in the user interface.

Netezza

Amazon Redshift

Fixed an issue where a connection to a source database failed with a Loader error.

Netezza

Amazon Redshift

Resolved an error where data migration agents failed to run after opening a saved project.

Oracle

Amazon RDS for Oracle

Implemented support of Oracle Unified Auditing.

Oracle

PostgreSQL

Aurora PostgreSQL

Implemented SQL code conversion in C# applications. For more information, see SQL code in C# applications.

Oracle

PostgreSQL

Aurora PostgreSQL

Implemented a new transformation logic for case-sensitive object names to improve the visibility of code conversion changes. AWS SCT converts object names in uppercase to lowercase. The opposite is also true; AWS SCT converts object names in lowercase to uppercase. Other object names and reserved words are converted without changes.

Oracle

PostgreSQL

Aurora PostgreSQL

Improved conversion of hash partitions without the NOT NULL constraint.

Oracle

Aurora PostgreSQL

Added support for conversion of Oracle CHECK, FOREIGN KEY, and NOT NULL constraints with the ENABLE NOVALIDATE clause.

Oracle DW

Amazon Redshift

Fixed an issue where the incorrect values for floating point numbers were migrated.

Oracle DW

Amazon Redshift and AWS Glue

Resolved an issue with empty columns in the database migration assessment report in a comma-separated value (CSV) file.

SAP ASE

PostgreSQL

Aurora PostgreSQL

Fixed an issue with an unexpected conversion interruption.

Snowflake

Amazon Redshift

Improved conversion of the VARIANT data type.

Teradata

Amazon Redshift

Improved conversion of the COLLECT STATISTICS statement.

Teradata

Amazon Redshift

Fixed a problem where action item 9998 doesn't appear when converting nested views with PERIOD columns.

Teradata

Amazon Redshift and AWS Glue

Fixed an issue where a virtual AWS Glue target platform didn't display in the UI after opening a saved project.

Teradata BTEQ

AWS Glue

Fixed an issue where the conversion to a virtual AWS Glue target platform wasn't supported after opening a saved project.

Teradata BTEQ

Amazon Redshift RSQL

Improved syntax highlighting of the converted code.

Teradata BTEQ

Amazon Redshift RSQL

Implemented checking parameter values after upload. Unsupported values are highlighted on the Variables tab.

Vertica

Amazon Redshift

Implemented conversion of aggregate functions.

Vertica

Amazon Redshift

Implemented conversion of projections to materialized views and improved the UI that displays the source code of projections.

Release notes for AWS SCT Build 658

Source Target What's new, enhanced, or fixed

All

All

Provided integration with AWS Secrets Manager. You can now use database connection credentials that are stored in Secrets Manager.

All

All

Added support for scripts in the YAML format in the AWS SCT command-line interface.

All

Amazon Redshift

Implemented support of Amazon S3 interface endpoints (VPCE) in data extraction agents.

All

Amazon Redshift

Added support for the Amazon Redshift virtual target database platform in addition to the already supported Amazon Redshift and AWS Glue combination.

Greenplum

Amazon Redshift

Fixed an issue where the Save as SQL option didn't save converted SQL code to a file.

IBM Db2 LUW

Microsoft Azure SQL Database

Microsoft SQL Server

Oracle

SAP ASE

Aurora MySQL

Improved conversion to support new features of Amazon Aurora MySQL-Compatible Edition with MySQL 8.0 compatibility.

Microsoft SQL Server

Aurora MySQL

Aurora PostgreSQL

MySQL

PostgreSQL

Fixed a problem where action item 810 doesn't appear when required.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of procedures with UPDATE, DELETE, and INSERT statements.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a problem where action item 7810 doesn't appear when required.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of an EXEC statement that is nested inside an IF...ELSE statement.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of indexed views.

Netezza

Amazon Redshift

Improved data migration agents by tracking live transactions during full load in the change data capture (CDC) operation. You can now stop data migration tasks if the CDC session is scheduled to start at a certain time. Also, you can see the error logging level in the console after you stop a task with CDC.

Oracle

All

Enhanced the table loader to ensure that AWS SCT loads objects with sharing options.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of the SYSDATE function and added the ability to change the time zone in Conversion settings.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue where dynamic statements weren't converted.

Oracle

Aurora PostgreSQL

PostgreSQL

Fixed an issue where the converted code doesn't include system-generated names.

Oracle

Oracle DW

Aurora PostgreSQL

PostgreSQL

Improved conversion of SELECT statements that are nested inside triggers.

Oracle DW

Amazon Redshift

Improved conversion of the TO_DATE, TO_TIMESTAMP, and TO_TIMESTAMP_TZ functions in the extension pack.

Snowflake

Amazon Redshift

Added an option to save converted SQL code in different files for each object or for each statement.

Teradata

Amazon Redshift

Improved conversion of the CONCAT function.

Teradata

Amazon Redshift

Improved conversion of a SELECT statement that is nested inside a WHERE clause.

Teradata

Amazon Redshift

Resolved an issue when SET and MULTISET tables were incorrectly converted after users drop and recreate a table.

Teradata

Amazon Redshift

Improved conversion of the procedures that include a WITH clause.

Teradata

Amazon Redshift

Improved conversion of the DATE data type.

Teradata

Amazon Redshift RSQL

Resolved an issue where an unexpected transformer error occurred during FastExport scripts conversion.

Teradata BTEQ

Amazon Redshift RSQL

Added support for conversion of a join index to a materialized view.

Teradata BTEQ

Amazon Redshift RSQL

Added support for conversion of a TITLE definition that includes multiple lines.

Teradata BTEQ

Amazon Redshift RSQL

Resolved an issue where the size of a geospatial data type wasn't converted.

Teradata BTEQ

Amazon Redshift RSQL

Fixed a problem where the parameter names were converted to lowercase characters.

Teradata BTEQ

Amazon Redshift RSQL

Fixed an issue when a stored procedure that is nested inside a MACRO statement wasn't converted.

Vertica

Amazon Redshift

Improved conversion of the ALL operator.

Vertica

Amazon Redshift

Resolved an issue where the Use Union all view? option in Conversion settings wasn't applied.

Vertica

Amazon Redshift

Improved conversion of the TIME and TIME WITH TIMEZONE data types.

Vertica

Amazon Redshift

Resolved an issue with loading of flex tables.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 657

Source Target What's new, enhanced, or fixed

All

All

Upgraded Apache Log4j to version 2.17 to address security vulnerability issues.

All

Amazon Redshift

Improved schema optimization projects, where key management statistics weren't saved in the AWS SCT project.

Amazon Redshift

Amazon Redshift

Fixed a problem with the server information update.

Apache Cassandra

Amazon DynamoDB

Fixed an issue with mapping rules when using the AWS SCT command-line interface.

Apache Cassandra

Amazon DynamoDB

Resolved an issue when the migration task wasn't created because of an updated title in the certificate.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed a problem so that action item 7672 doesn't appear during the conversion of Microsoft SQL Server procedures with dynamic SQL.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of table-valued functions.

Azure SQL Database

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Resolved an issue where the OUT argument in a stored procedure with the default return value wasn't converted to the INOUT argument.

Greenplum

Amazon Redshift

Improved optimization strategies by finding the most used tables and columns from the QueryLog table.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed problems with conversion of the following:

  • String concatenation assignment operator (+=)

  • SCOPE_IDENTITY function

  • varchar(max) data type

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Improved conversion of views with unsupported functions.

Microsoft SQL Server

Aurora PostgreSQL

PostgreSQL

Fixed an issue where unsupported functions as an argument to another function were incorrectly converted.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Improved conversion of transition table references.

Microsoft SQL Server DW

Amazon Redshift

Added the aggregate functions category to the source database metadata tree.

Microsoft SQL Server DW

Amazon Redshift

Improved conversion of the TIME data type.

Azure Synapse Analytics

Greenplum

Netezza

Microsoft SQL Server DW

Snowflake

Teradata

Amazon Redshift

Fixed an issue where DROP and CREATE scripts weren't saved when using a virtual target database platform.

Microsoft SQL Server Integration Services

AWS Glue

Resolved an issue where the scripts of source objects didn't display in the UI.

Netezza

Amazon Redshift

Improved optimization strategies by choosing the fact table and appropriate dimensions for collocation.

Oracle

Aurora PostgreSQL

PostgreSQL

Resolved an issue to correctly convert Oracle triggers, which use sequence numbers.

Oracle

Aurora PostgreSQL

PostgreSQL

Improved conversion of views with public database links.

Oracle DW

Amazon Redshift

Improved optimization strategies by analyzing the cardinality of index columns.

Oracle DW

Amazon Redshift

Fixed an issue where custom user-defined scalar functions with string concatenation were incorrectly converted.

Snowflake

Amazon Redshift

Fixed an issue where the Save as SQL option didn't display in the UI.

Teradata

Amazon Redshift

Fixed an issue where statistic collection failed with the LOADER ERROR exception.

Teradata

Amazon Redshift

Fixed an issue where the Create report option didn't display in the UI.

Teradata

Amazon Redshift

Improved conversion of the CAST function.

Teradata

Amazon Redshift

Fixed a broken conversion for ST_Line_Interpolate_Point.

Teradata

Amazon Redshift

Removed an unexpected value from the Python library path.

Teradata

Amazon Redshift RSQL

Fixed a resolver error that appeared during the conversion of multiple FastLoad scripts.

Teradata BTEQ

Amazon Redshift RSQL

Improved conversion of the DATABASE command and geometry data types.

Teradata BTEQ

AWS Glue

Fixed an issue with an incorrect synchronization of the source and target scripts in the UI.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 656

Source Target What's new, enhanced, or fixed

All

All

Added support of multiple source and target databases within one project. Users can now create mapping rules to match different database schemas and target platforms in the same project.

All

All

Added support of virtual target database platforms. Users now don't need to connect to a target database to see how AWS SCT converts their source database schema.

All

All

UI improvements:

  • Added the Connect to the server and Disconnect from the server options to the source and target metadata trees.

  • Added an option to remove a database server from the AWS SCT project.

Cassandra

Amazon DynamoDB

Resolved a search issue where the CASSANDRA_HOME variable didn't include a slash (/) after cassandra.yaml or the conf folder.

Cassandra

Amazon DynamoDB

Added support of the Amazon Machine Image (AMI) for Amazon Linux 2.

Cassandra

Amazon DynamoDB

Improved error message provided when an incorrect key is given for Cassandra.

Cassandra

Amazon DynamoDB

Improved conversion by changing a property in the cassandra-env.yaml file depending on the version of the target database.

Cassandra

Amazon DynamoDB

Increased the Java version on the target Cassandra Datacenter to 1.8.0.

Greenplum

Amazon Redshift

Improved optimization strategies in Project Settings.

Greenplum

Amazon Redshift

Resolved a data migration issue where objects weren't applied to database with this error: An I/O error occurred while sending to the backend.

Greenplum

Microsoft SQL Server DW

Amazon Redshift

Resolved an issue where the Apply RTRIM to string columns option didn't display in the UI.

Microsoft SQL Server

Babelfish for Aurora PostgreSQL

Added support for Babelfish for Aurora PostgreSQL as a target platform. Users can now create an assessment report to estimate the migration from SQL Server to Babelfish for Aurora PostgreSQL.

Netezza

Amazon Redshift

Improved optimization strategies in Project Settings.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Implemented the ability to generate unique names for indexes.

SAP ASE

Aurora PostgreSQL

PostgreSQL

Fixed an issue with a duplicate index column in the target script.

Snowflake

Amazon Redshift

Resolved a problem where Hide empty schemas, Hide empty databases, and Hide system databases/schemas options weren't displayed in the UI.

Teradata

Amazon Redshift RSQL

Added support for conversion of Teradata MultiLoad job scripts to Amazon Redshift RSQL scripts.

Teradata

Amazon Redshift RSQL

Fixed a problem with conversion of substitution variables in FastLoad and FastExport scripts.

Teradata

Amazon Redshift RSQL

Fixed an issue where action items didn't display in the Action Items tab after switching from the Summary tab.

Teradata

Amazon Redshift RSQL

Resolved an issue where an error occurs after generating report during FastExport scripts conversion.

Teradata

Amazon Redshift RSQL

Resolved formatting issues after shell scripts conversion.

Teradata

Amazon Redshift RSQL

Fixed a problem so that AI 13177 is now commented in converted script.

Teradata

Amazon Redshift

Fixed a broken conversion of temporal tables.

Teradata

Amazon Redshift

Improved conversion of the SET QUERY_BAND statement.

Teradata

Amazon Redshift

Fixed a broken conversion of the NORMALIZE operation.

Vertica

Amazon Redshift

Improved the description of AI 17008.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 655

Source Target What's new, enhanced, or fixed

Teradata

Amazon Redshift RSQL

Fixed a problem to ensure all assessment issues appear in reports when FastLoad or MultiLoad is used.

Teradata

Amazon Redshift RSQL

Added support for conversion of Teradata FastExport job scripts to Amazon Redshift RSQL scripts.

Teradata

Amazon Redshift RSQL

Fixed a problem to ensure the Save manifest to S3 action is enabled in offline mode when using FastLoad.

Teradata

Amazon Redshift RSQL

Fixed an issue to ensure mapping rules are applied for scripts like FastLoad.

Greenplum

Amazon Redshift

Increased the minimum supported driver version for Greenplum to 42.2.5.

Greenplum

Amazon Redshift

Added a connection to Greenplum via SSL with driver version 42.2.5 or higher.

Oracle DW

Amazon Redshift

Improved support for executing custom user-defined scalar functions (UDF) within another UDF.

Oracle DW

Amazon Redshift

Fixed an issue where functions weren't applied to database with this error: Failed to compile udf.

Oracle DW

Amazon Redshift

Improved conversion by using appropriate type declarations such as, pls-type for %ROWTYPE parameters.

Teradata

Amazon Redshift RSQL

Resolved an issue where information type assessment issues didn't display in the report.

Teradata

Amazon Redshift RSQL

Resolved a transformer error after converting some scripts.

Teradata

Amazon Redshift RSQL

Fixed a problem so that an issue is now commented in converted script.

Teradata

Amazon Redshift

Resolved an issue where FastExport ->EXPORT -> 'null' displayed instead 'CAST' after conversion.

Teradata

Amazon Redshift

Resolved a problem where some functions of an extension pack failed when applied with Cause:[JDBC Driver]String index out of range: 0 if using driver version 1.2.43

Teradata

Amazon Redshift

SET table conversion—SET table emulation added for insert-select statements.

Teradata

Amazon Redshift

CAST—support additional data type casting.

Teradata

Amazon Redshift

Fixed a broken conversion for "other_current_time_01"

Teradata

Amazon Redshift

Teradata FastExport – Amazon Redshift RSQL: Improved conversion of Teradata FastExport commands—FIELD

Teradata

Amazon Redshift

Teradata FastExport – Amazon Redshift RSQL: Improved conversion of Teradata FastExport commands—LAYOUT

Oracle

PostgreSQL

Aurora PostgreSQL

Resolved an issue where target script of objects with SAVE EXCEPTIONS STATEMENT changed after reconversion.

Oracle

PostgreSQL

Aurora PostgreSQL

Resolved an issue where wrong field was specified in the ORDER BY clause after proc_cursor_with_calc_columns conversion.

Oracle

PostgreSQL

Aurora PostgreSQL

Resolved: an extra aws_oracle_ext$array_id$temporary variable declaration is required in an ASSOCIATIVE COLLECTION conversion.

Oracle

PostgreSQL

Aurora PostgreSQL

Resolved: the wrong conversion of a PRIMARY KEY with the same name of an INDEX owned by the same table.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 654

Source Target What's new, enhanced, or fixed

Oracle

PostgreSQL

Aurora PostgreSQL

Resolved an issue with Hierarchical Query Pseudocolumns, PRIOR columns parsing error.

Oracle

PostgreSQL

Aurora PostgreSQL

Resolved an issue to correctly convert a multi-line comment containing a slash and asterisk (/*).

Oracle

PostgreSQL

Aurora PostgreSQL

Added system view USER_COL_COMMENTS emulation to the extension pack.

Oracle

PostgreSQL

Aurora PostgreSQL

Improved conversion of quoted literals.

DB2 LUW

PostgreSQL

Aurora PostgreSQL

Improved conversion of LABEL statements that add or replace labels in the descriptions of tables, views, aliases, or columns.

Oracle

None

Substituted SYS.USER$ system table with DBA_USERS view, and improved queries.

Oracle DW

Amazon Redshift

Updated Oracle DW metadata queries.

Teradata

Amazon Redshift RSQL

Added support for conversion of shell, Teradata FastLoad, and Teradata Basic Teradata Query (BTEQ) scripts to Amazon Redshift RSQL scripts.

Teradata BTEQ

Amazon Redshift RSQL

Resolved issue where "merge_01" was incorrectly converted.

Teradata BTEQ

Amazon Redshift RSQL

Resolved issue so that End or Identify (EOI) appears at the end of a script on a new line.

Azure Synapse

Amazon Redshift

Improved error message provided when an incorrect password given for Azure Synapse.

Teradata

Amazon Redshift

Improved UPDATE statement conversion to carry forward the right alias name per Teradata standard.

Teradata

Amazon Redshift

Resolved a cursor conversion error where actions weren't received.

Teradata

Amazon Redshift

Resolved an issue where a TD_NORMALIZE_OVERLAP conversion was dropping rows.

Teradata

Amazon Redshift

Now supports strict date checking for the enhanced TO_DATE function.

Teradata

Amazon Redshift

Improved conversion of Built-in function TO_NUMBER(n).

Teradata

Amazon Redshift

Resolved an issue where the Schemas category was absent from metadata tree.

Greenplum

Amazon Redshift

Added GP_SEGMENT_ID selection to list when creating virtual partition for a Greenplum table.

Greenplum

Amazon Redshift

Resolved an issue where functions weren't applied on target.

MS SQL Server DW

Amazon Redshift

Resolved an issue where a transform error occurs after conversion without AI 9996.

MS SQL Server DW

Amazon Redshift

Resolved an issue where an error was logged when opening the extension pack wizard.

MS SQL Server DW

Amazon Redshift

Resolved an issue when an incorrect style of comments was used for Redshift Python functions.

Netezza

Amazon Redshift

Resolved an issue where a Netezza–Redshift extension pack with an AWS profile failed to create.

Teradata

Amazon Redshift RSQL

Improved conversion of FastLoad SESSIONS command.

Teradata

Amazon Redshift RSQL

Improved FastLoad scripts assessment reports.

Teradata

Amazon Redshift RSQL

Implemented FastLoad WRITER Save to S3 action.

Teradata

Amazon Redshift RSQL

Resolved an issue where FastLoad Save Script\Save manifest to s3 buttons weren't active.

Teradata

Amazon Redshift RSQL

Resolved an issue where FastLoad multifile_script only created one manifest file after conversion instead of the expected three files.

Teradata

Amazon Redshift RSQL

Resolved an issue where FastLoad had extra folders displayed in an S3 path.

Teradata

Amazon Redshift RSQL

Resolved an issue where FastLoad had the incorrect name of the manifest file in an S3 path.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 653

Source Target What's new, enhanced, or fixed

Oracle

PostgreSQL

Aurora PostgreSQL

Implemented the ability to convert dynamic SQL created in called functions or procedures.

Oracle

PostgreSQL

Aurora PostgreSQL

Improved Dynamic SQL conversion: In-parameters as bind variables.

Oracle DW 18, 19

Amazon Redshift

Oracle to Redshift conversion improvements implemented: enhanced conversion built-ins. Aggregate LISTAGG; Analytic LISTAGG.

Oracle DW 18,19

Amazon Redshift

Oracle to Redshift conversion improvements implemented: Query new features.

Vertica

Amazon Redshift

Vertica to Redshift conversion improvements implemented: SSL to JDBC connection with SSL=true.

MS SQL Server DW

Amazon Redshift

MS SQL Server to Redshift conversion improvements: External Tables.

Teradata

Amazon Redshift

Teradata to Redshift conversion improvements: INTERVAL data types arithmetic operations.

Teradata

Amazon Redshift

Teradata to Redshift conversion improvements: Support for lateral column aliases.

Oracle

None

The following Loader queries now use DBA_USERS instead of SYS.USER$:

  • get-tree-path-list-by-name-path.sql

  • estimate-table-or-view-constraints-by-schema.sql

  • estimate-table-or-view-constraints-by-selected-schemas.sql

Teradata

Amazon Redshift

Improved alignment of comments when SCT converts Teradata macros to Redshift stored procedures.

Oracle DW

Amazon Redshift

Improved conversion of Date/Timestamp format elements: TO_DATE, TO_TIMESTAMP, and TO_TIMESTAMP_TZ

Teradata

Amazon Redshift

Resolved Teradata cursor conversion error.

Teradata

Amazon Redshift

Resolved issue that caused attributes of TD_NORMALIZE_OVERLAP to be dropped during conversion.

Teradata

Amazon Redshift

Resolved an issue where MAX function was ignored when SCT converted a query.

Teradata

Amazon Redshift

SCT now converts Teradata CHARACTERS function to Redshift LENGTH function.

Teradata

Amazon Redshift

SCT now supports conversion of FORMAT to TO_CHAR for most commonly used formats.

All

All

Improved conversion of encrypted routines.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 652

Source Target What's new, enhanced, or fixed

Microsoft SQL Server

PostgreSQL

Added app locking for sp_getapplock and sp_releaseapplock functions.

None

Amazon Redshift

Command Line Interface (CLI) improvement: implemented Script Command mode.

Oracle

PostgreSQL

Aurora PostgreSQL

Implemented routine parameters sampling inside dynamic SQL.

Oracle

PostgreSQL

Aurora PostgreSQL

Conversion improvements to dynamic SQL created in called functions or procedures.

Microsoft SQL Server

Oracle

DB2 LUW

Aurora PostgreSQL

Each lambda function is deployed and configured via policy only once, and common lambda functions are reused for all possible sources.

DB2 LUW

PostgreSQL

Resolved issue that caused error message, "9996 — Severity critical — Transformer error occurred" when using DB2 LUW as source.

Teradata

Amazon Redshift

Support for recursive table expressions in forthcoming Amazon Redshift launch.

Azure Synapse

Amazon Redshift

Implemented schema optimization rules.

Teradata

Amazon Redshift

Support Time Zone conversion from Teradata macros to Redshift stored procedures.

Teradata

Amazon Redshift

Support arithmetic on PERIOD values.

Teradata

Amazon Redshift

Support conversion of Teradata recursive common table expressions (RECURSIVE CTE).

Teradata

Amazon Redshift

Support case sensitive identifiers via the user setting, enable_case_sensitive_identifier. So, "COLUMN_NAME" and "Column_Name" become different column names.

Teradata

Amazon Redshift

Resolved Decimal data type issue so that Decimal fields convert with the same precision.

Teradata

Amazon Redshift

Resolved issue with interval arithmetic conversion so that interval arithmetic subtraction converts correctly.

Teradata

Amazon Redshift

Improved Teradata NUMBER to DATE type casting.

Teradata

Amazon Redshift

Improved Teradata DATE to NUMBER type casting

Teradata BTEQ

Amazon Redshift

Improved PERIOD data type conversion.

Teradata

Amazon Redshift

Resolved issue with loading metadata for a table with GEOMETRY columns so that it now loads from Teradata correctly.

Teradata

Amazon Redshift

Support conversion of merge statements when converting Teradata macros to Redshift stored procedures.

Teradata

Amazon Redshift

Improved conversion of simple macros when migrating from Teradata to Redshift.

Teradata

Amazon Redshift

Ensured the conversion of Teradata UPDATE statements carry forward the right alias name per Teradata standard.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 651

Source Target What's new, enhanced, or fixed

All

All

Enhanced AWS SCT reports to update links to the recommended conversion action items listed.

MS SQL Server

PostgreSQL

Added support for conversion of STR() function.

MS SQL Server

PostgreSQL

Added support for converting the bitwise EXOR operator (^ in Microsoft SQL Server) to PostgreSQL as the # operator.

Oracle

PostgreSQL

Resolved an issue where the AWS SCT extension pack aws_oracle_ext.UNISTR(null) function hung for NULL on a PostgreSQL target. AWS SCT now handles the NULL.

Teradata BTEQ

Amazon Redshift RSQL

Conversion improvements made to resolve an issue where conversion of Amazon Redshift RSQL MERGE gave a transform error.

Oracle DW

Amazon Redshift

Implemented enhanced built-ins.

Oracle DW

Amazon Redshift

Added metadata feature driven enhancements, including Auto-List partitioning (TBL_PART_LIST_AUTO), Multi-column List (TBL_PART_MULTI_LIST) and Interval-Reference (TBL_PART_RANGE_INTVAL_REF).

none

Amazon Redshift

Increased partition table limits of physical partitions used for UNION ALL conversions.

Teradata

Amazon Redshift

Conversion improvements made to the scope of Assessment reports.

Teradata

Amazon Redshift

Conversion improvements made to complex Teradata MACRO conversions.

Teradata

Amazon Redshift

Improved conversion of Teradata macros to Amazon Redshift stored procedures while commenting out unsupported SQL.

Teradata

Amazon Redshift

Resolved an issue where conversion of Teradata macros to Amazon Redshift stored procedures resulted in the wrong alias name references.

Teradata

Amazon Redshift

Improved conversion of Teradata QUALIFY statement.

Teradata

Amazon Redshift

Improved conversion to carry forward comments to Amazon Redshift and retain a history of changes performed on the view.

Teradata

Amazon Redshift

Resolved an issue where the RESET WHEN clause didn't result in the correct conversion.

Teradata BTEQ

Amazon Redshift

Improved conversion of BTEQ scripts that contain MERGE statements.

Teradata

Amazon Redshift

Added built-in functions to improve conversion of PERIOD data type fields.

Microsoft SQL Server

Amazon Redshift

Enhanced transformation data type mapping for TIME data type.

All

All

Added access to the initial publication of the AWS Schema Conversion Tool CLI Reference manual in PDF format. See AWS Schema Conversion Tool CLI Reference.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 650

Source Target What's new, enhanced, or fixed

All

All

Updated and enhanced use of extractor agents, including:

  • A configuration for use with shared storage and a dedicated copying agent.

  • Exporting and importing data extraction tasks from one project to another.

  • Support for Azure SQL Data Warehouse (Azure Synapse) as source.

  • Using native Netezza partitioning.

For more information, see Migrating data from on-premises data warehouse to Amazon Redshift with AWS Schema Conversion Tool.

All

Amazon RDS PostgreSQL 13

AWS SCT now supports Amazon RDS PostgreSQL 13 as target.

Microsoft SQL Server

Aurora PostgreSQL

Improved conversion of a result set from an Microsoft SQL Server procedure to an Aurora PostgreSQL target.

Oracle DW

Amazon Redshift

Implemented Oracle to Amazon Redshift conversion improvements.

Oracle DW

Amazon Redshift

Implemented improvements to converting dynamic SQL statements.

Oracle DW

Amazon Redshift

Implemented improvements to SQL UDF conversion.

Oracle DW

Amazon Redshift

Clarified message that AWS SCT doesn't support conversion of EXTERNAL TABLES.

Oracle DW

Amazon Redshift

Enhanced built-in conversion functions.

Teradata BTEQ

Amazon Redshift RSQL

Improved handling substitution parameters inside BTEQ scripts while using AWS SCT GUI.

Microsoft SQL Server DW

Microsoft SQL Server

Azure

Azure Synapse

All

Upgraded the minimum supported JDBC driver version for Microsoft SQL Server, Azure, Azure Synapse.

Issues resolved:
  • Teradata: Macro conversion additional improvements [RESOLVED]

  • Special characters escaped in the target causing SQL errors and re-work needed to place them back [RESOLVED]

  • General improvements

Release notes for AWS SCT Build 649

Source Target What's new, enhanced, or fixed

Microsoft SQL Server DW

Amazon Redshift

MSSQL to Amazon Redshift conversion improvements to support temporal tables.

Oracle DW

Amazon Redshift

Implemented built-in function enhancements, such as:

Conversion functions

  • TO_BINARY_DOUBLE

  • TO_BINARY_FLOAT

  • TO_NUMBER

  • TO_DATE

  • TO_TIMESTAMP

  • TO_TIMESTAMP_TZ

  • TO_DSINTERVAL

  • TO_YMINTERVAL

  • VALIDATE_CONVERSION

Oracle DW

Amazon Redshift

Implemented function enhancements for Approximate Query Processing, such as:

Aggregate functions

  • ANY_VALUE

  • APPROX_COUNT_DISTINCT

  • APPROX_COUNT_DISTINCT_DETAIL

  • APPROX_COUNT_DISTINCT_AGG

  • LISTAGG

  • TO_APPROX_COUNT_DISTINCT

Teradata

Amazon Redshift

Implemented conversion enhancements for Teradata auto sort and distribution key selection. The DB engine automatically selects distribution and sort keys. Introduced a radio button labeled Use Amazon Redshift automatic table tuning to Current projects settings > Optimization strategies > Initial Key Selection Strategy dialog.

Teradata

Amazon Redshift

Enhanced AWS SCT table loader to ensure AWS SCT loads all tables from Teradata.

Teradata

Amazon Redshift

Implemented conversion enhancements so that Amazon Redshift supports correlated subquery patterns that include a simple WHERE NOT EXISTS clause.

Teradata

Amazon Redshift

Added support for use of ECHO commands in macros.

DB2 LUW

PostgreSQL

Aurora PostgreSQL

Implemented support for DYNAMIC RESULTS SETS conversion, including:

  • Cursor clause WITH RETURN/WITH RETURN TO CLIENT

  • DYNAMIC RESULT SETS routine clause conversion

Microsoft SQL Server

Oracle

DB2 LUW

SAP ASE

Aurora PostgreSQL

Implemented support for current Aurora RDS PostgreSQL as target.

Microsoft SQL Server

Oracle

DB2 LUW

SAP ASE

MariaDB

Implemented support for MariaDB 10.5 as target.

Microsoft SQL Server

MariaDB

Implemented support of INSERT-RETURNING which returns a result set of the inserted rows.

Oracle

Aurora PostgreSQL

Added support of the XMLFOREST function for converting from Oracle to Aurora PostgreSQL.

Issues resolved:
  • General improvements.

Release notes for AWS SCT Build 648

Source Target What's new, enhanced, or fixed

Oracle

PostgreSQL

Amazon Aurora PostgreSQL-Compatible Edition

Aurora PostgreSQL extension pack custom apply mode implemented: operators for numeric/date and text types.

Oracle

Microsoft SQL Server

DB2 LUW

Aurora PostgreSQL

Aurora PostgreSQL Lambda Invoke configuration implemented: aws_lambda extension creation; IAM role assignment to the Aurora PostgreSQL cluster.

  • Oracle—Emails, Jobs, WebAgent, Queues, Files

  • DB2—Emails, Tasks, Files

  • Microsoft SQL Server— Emails, Agent

Oracle

PostgreSQL

FORALL statement conversion refactoring implemented:

  • FORALL statement

  • FORALL ... SAVE EXCEPTIONS

  • RETURNING INTO with BULK COLLECT

  • SQL%BULK_EXCEPTIONS system collection

Oracle DW 18, 19

Amazon Redshift

Oracle to Amazon Redshift conversion improvements implemented: enhanced conversion built-ins. Aggregate LISTAGG; Analytic LISTAGG.

Oracle DW 18,19

Amazon Redshift

Oracle to Amazon Redshift conversion improvements implemented: Query new features.

Vertica

Amazon Redshift

Vertica to Amazon Redshift conversion improvements implemented: SSL to JDBC connection with SSL=true.

Microsoft SQL Server DW

Amazon Redshift

Microsoft SQL Server to Redshift conversion improvements: External Tables.

Teradata

Amazon Redshift

Teradata to Redshift conversion improvements: INTERVAL data types arithmetic operations.

Teradata

Amazon Redshift

Teradata to Redshift conversion improvements: Support for lateral column aliases.

Issues resolved:
  • General improvements

Release notes for AWS SCT Build 647

Source Target What's new, enhanced, or fixed

Microsoft SQL Server

Microsoft SQL Server

RDS now supports Database Mail feature.

Microsoft SQL Server

MySQL

Implementing the maximum name of each type of identifier — The maximum length of object names (for example, tables, constraints, columns) in SQL Server is 128 characters. The maximum length of object names in MySQL is 64 characters. To write converted objects to the MySQL database you need to shorten their names. To prevent duplicate names after cutting, you need to add "checksum" of the original object name to the new names.

Cut names longer than 64 characters as follows:

[first N chars]() + "" + [checksum]()

[first N chars] = 64 - 1 - [length of checksum string]

For example:

example_of_a_test_schema_with_a_name_length_greater_than_64_characters ?? example_of_a_test_schema_with_a_name_length_greater_than_64_9703

Oracle

MySQL/Aurora MySQL

Implemented load and conversion of comments on storage objects. For example, processing of comments on Tables, and processing of comments on Table/View columns.

Teradata

Amazon Redshift

Added support for TIME data type conversion.

Teradata

Amazon Redshift

Conversion improvements — TD_NORMALIZE_OVERLAP implemented.

Microsoft SQL Server DW

Amazon Redshift

Conversion improvements — SELECT with WITH clause; SELECT without FROM

All

All

AWS SCT Data Migration Service Assessor (DMSA) — This new feature enables you to evaluate multiple servers and receive a summary report that shows the best target direction for your environment.

All

All

AWS SCT Wizard — Target comparison now shows differences between targets in a single table view.

All

All

Tree Filter UI — Redesigned metadata filter handles more complex filtering patterns.

All

All

Assessment Report — Redesigned Warning section provides a better description and clearer understanding of an issue.

Issues resolved:
  • General improvements

  • Data Extractors — Subtask failed with ConcurrentModificationException [RESOLVED].

  • Microsoft SQL Server to MySQL — max identifier lengths [RESOLVED].

Release notes for AWS SCT Build 646

Source Target What's new, enhanced, or fixed

Oracle

PostgreSQL

Improved TM format model implementation.

Oracle

PostgreSQL

SP format mask implementation provides basic support for SP suffix, only for the English language.

Oracle

PostgreSQL

Oracle long object names handling — AWS SCT now handles Oracle long object names according to target max identifier length attribute.

Amazon Redshift

Amazon Redshift encoding AZ64 with AWS SCT — Added compression encoding AZ64 for some data types

Teradata

Amazon Redshift

Added support for Implicit transactions conversion.

Teradata

Amazon Redshift

Added support for Teradata geospatial built-in functions: ST_LineString Methods

Greenplum

Amazon Redshift

Greenplum sequence conversion — Added the next items to the Properties tabs: min value, max value, increment, cycle.

Greenplum

Amazon Redshift

Resolver — Added "char" data type resolving.

Greenplum

Amazon Redshift

Character conversion length — Updated PL/pgSQL conversion for character type.

Greenplum

Amazon Redshift

Resolved an issue with Greenplum distribution key selection where a table had DISTRIBUTION KEY but AWS SCT couldn't recognise and fetch table as RANDOMLY DISTRIBUTED.

Teradata

Amazon Redshift

Teradata cursor support — Added support for cursors conversion.

Teradata

Amazon Redshift

Identity columns — Added support for Identity columns conversion.

Teradata

Amazon Redshift

INTERVAL data types — Added support for INTERVAL data types conversion.

Issues resolved:
  • General improvements

  • Greenplum: Unable to run conversion due to the error in the log [RESOLVED].

  • MSSQL — PostgreSQL: Transformer error when converting LAG function [RESOLVED].

  • MSSQL — PostgreSQL: SCOPE_IDENTITY [RESOLVED].

  • AWS SCT hanging in DW projects [RESOLVED].

  • Need mapping rule to remove additional space on the column name in AWS SCT [RESOLVED].

Release notes for AWS SCT Build 645

Source Target What's new, enhanced, or fixed

Teradata

Amazon Redshift

Provide solution to resolve Teradata non-fully qualified views (view names or non-fully qualified objects within the view).

Teradata

Amazon Redshift

Added support of ASCII function to compute nodes.

Teradata

Amazon Redshift

When AWS SCT spots multi-byte data in a Teradata CHAR defined as CHAR(N), it is converted to VARCHAR(3*N) in Amazon Redshift.

Teradata

Amazon Redshift

Provide Teradata CAST conversion between dates and numbers.

  • SELECT Cast('2020-07-17' AS BIGINT)

  • SELECT Cast(20200630 - 19000000 AS DATE)

Teradata

Amazon Redshift

Support conversion of Teradata PERIOD data types into two Amazon Redshift TIMESTAMP columns:

  • PERIOD(TIMESTAMP)

  • PERIOD(TIMESTAMP WITH TIMEZONE)

Teradata

Amazon Redshift

Support conversion of Teradata RANK function with RESET WHEN clause.

Teradata

Amazon Redshift

Improved support of CAST in explicit data type conversions, and implicit CASTs on expressions.

Teradata

Amazon Redshift

Report unsupported correlated subquery patterns. For more information, see Correlated subqueries in the Amazon Redshift Database Developer Guide.

none

Amazon Redshift

Improved tables limit support for RA3 node types.

Teradata

Amazon Redshift

Added support for Teradata geospatial data extraction. For more information, see Querying spatial data in Amazon Redshift in the Amazon Redshift Database Developer Guide.

Microsoft SQL Server

PostgreSQL

Added the option, convert_procedures_to_function.

Issues resolved:
  • General improvements

Release notes for AWS SCT Build 644

Changes for AWS SCT releases 1.0.643 are merged into AWS SCT 1.0.644 release.

Source Target What's new, enhanced, or fixed

Teradata

Amazon Redshift

Multiple conversion improvements.

  • Improved conversions with QUALIFY with the table alias.

  • Improved conversions with the IN operator.

  • Improved conversion with the LIKE operator.

  • Improved conversions with highlighting issues in converted code.

  • Improved conversions with unusual order of WHERE, QUALIFY clauses in SQL.

  • Fixed transformer errors occurred during JOIN() constructions conversion of procedure UPD_FT_SVC_TRANS_BH_CBH_IND.

  • Improved conversion of macros to stored procedures.

Added special AWS SCT CLI commands that can parse the provided sql/bteq scripts and generate a report on the number of syntax structures encountered in the source code.

  • Count of BTEQ commands

  • Count of HANDLERS

  • Count of CAST cases

  • Count of DML/DDL cases

  • Count of DMLs on updatable views

Added an assessment report action item: Teradata columns with custom date formats are not supported in Amazon Redshift.

Oracle

PostgreSQL/Aurora PostgreSQL

Added functionality to save extension pack installation scripts.

Changed severity level for AI 5334.

Improved performance of using a record as package variable IMPLEMENTATION.

Added XMLAGG aggregation function support

IBM Db2

PostgreSQL/Aurora PostgreSQL

Added load and conversion of comments on storage objects implementation.

MS SQL DW

Amazon Redshift

Conversion improvement: Resolved issue with PATINDEX.

UI improvements:

  • Save as SQL for source tree implementation.

  • Added additional logic to script generation for multiple files.

Vertica

Amazon Redshift

UI improvement: Save as SQL for source tree implementation.

Issues resolved:
  • General improvements to conversions between Teradata and Amazon Redshift

  • General bug fixing and UI improvements

Release notes for AWS SCT Build 642

Changes for AWS Schema Conversion Tool release 1.0.642.

Note

AWS Schema Conversion Tool (AWS SCT) build 1.0.642 changes are applicable to Windows, Ubuntu, and Fedora. There is no 1.0.642 build for macOS.

Source Target What's new, enhanced, or fixed

Microsoft SSIS

AWS Glue

Implemented conversion of Microsoft SQL Server Integration Services (SSIS) ETL packages to AWS Glue. For more information, see Converting SSIS to AWS Glue with AWS SCT.

Oracle

MariaDB/SQL MODE=ORACLE/MySQL/Amazon Aurora MySQL

Implemented the PL/SQL declaration section in the WITH clause.

Oracle

PostgreSQL/Aurora PostgreSQL

Added support for DBMS_SESSION.RESET_PACKAGE and DBMS_SESSION.MODIFY_PACKAGE.

Vertica

Amazon Redshift

Enable exporting of SQL scripts from a Vertica database to Amazon Redshift.

Issues resolved:
  • Assessment Report Enhancement.

  • Assessment Report UI Enhancement.

  • Add the ability to change JVM settings from UI.

  • General improvements.

Release notes for AWS SCT build 641

Changes for AWS Schema Conversion Tool release 1.0.641.

Note

AWS Schema Conversion Tool (AWS SCT) build 1.0.641 changes are applicable to Windows, Ubuntu, and Fedora. There is no 1.0.641 build for macOS.

Source Target What's new, enhanced, or fixed

Oracle/MS SQL/MySQL/PostgreSQL/Db2 LUW

All

Produce Time Report calculations in the .csv file.

Teradata

Amazon Redshift

Added support for CSUM function.

Added support for Teradata geospatial data types.

Teradata

All

Added support for converting IDENTITY columns.

Greenplum

Amazon Redshift

Added support for distribution style AUTO during Greenplum table conversion.

SAP ASE

All

Produce Time Report calculations in the .csv file.

Resolved:

  • Various bug fixes.

  • Various performance improvements.

Release notes for AWS SCT Build 640

Changes for AWS SCT releases 1.0.633, 1.0.634, 1.0.635, 1.0.636, 1.0.637, 1.0.638, 1.0.639, and 1.0.640 are merged into AWS SCT 1.0.640 release.

Note

AWS SCT build 1.0.640 changes are applicable to Windows, Ubuntu, and Fedora. They don't apply to macOS.

You can't install AWS SCT version 1.0.640 or higher on Apple macOS. AWS SCT version 1.0.632 was the last version to support installation on Apple macOS.

In the following tables, you can find lists of the features and bug fixes for the AWS Schema Conversion Tool versions that have been combined into release 1.0.640. These tables group features and bug fixes by the source engine.

Release 1.0.640 Oracle changes

The following table lists build 1.0.640 changes in which Oracle is the source engine.

Source Target What's new, enhanced, or fixed

Oracle

PostgreSQL

Aurora PostgreSQL

Implemented SQL code conversion in Java and Pro*C applications.

Oracle

PostgreSQL

Aurora PostgreSQL

Improved performance of the following functions when used in a WHERE clause:

  • aws_oracle_ext.to_date

  • aws_oracle_ext.to_char

  • aws_oracle_ext.to_number

  • aws_oracle_ext.sysdate

  • aws_oracle_ext.sys_context

Oracle

RDS MariaDB 10.4

Added RDS MariaDB 10.4 support for all online transactional processing (OLTP) vendors.

Oracle

PostgreSQL/Aurora PostgreSQL

Added support for DBMS_UTILITY.GET_TIME.

Added the following emulations:

  • DBMS_UTILITY.GET_TIME

  • DBMS_UTILITY.FORMAT_CALL_STACK

  • DBMS_UTILITY.CURRENT_INSTANCE

Oracle

MariaDB/MySQL/Aurora MySQL/Microsoft SQL Server Mode=Oracle/PostgreSQL/Aurora PostgreSQL/RDS Oracle

Added sharing clause support for TABLE(DATA,EXTENDED DATA), VIEW(DATA,EXTENDED DATA), and SEQUENCE(DATA)

Oracle

PostgreSQL/Aurora PostgreSQL/Oracle RDS

The DEFAULT definition of a column can be extended to have the DEFAULT being applied for explicit NULL insertion.

The DEFAULT clause has a new ON NULL clause. This new clause instructs the database to assign a specified default column value when an INSERT statement attempts to assign a value that evaluates to NULL.

Oracle

MariaDB/MariaDB (SQL MODE=ORACLE)

Added support for "Identity Columns," which automatically increment at the time of insertion.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

Oracle

MariaDB 10.2/MariaDB 10.3/MySQL/Aurora MySQL/PostgreSQL/Aurora PostgreSQL

The DEFAULT clause has a new ON NULL clause, which instructs the database to assign a specified default column value when an INSERT statement attempts to assign a value that evaluates to NULL.

Oracle

Oracle RDS/MySQL/Aurora MySQL/PostgreSQL/Aurora PostgreSQL

Added support for IDENTITY columns.

Oracle

MySQL 8.x

Added support for CHECK constraint.

Oracle

PostgreSQL/Aurora PostgreSQL

Implemented checking ANYDATA IS NULL/IS NOT NULL using extension pack routine.

Implemented the emulation of the VALUE function used in a query based on the TABLE function of XMLSequence.

Added DBMS_LOB support for the following built-in routines:

  • DBMS_LOB.CREATETEMPORARY

  • DBMS_LOB.FREETEMPORARY

  • DBMS_LOB.APPEND

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

Oracle

Amazon Redshift

Implemented conversion of cursor attributes in nested blocks.

Amazon Redshift doesn't support collections. Related variables are converted as VARCHAR. All collection operations other than assigning one variable to another are rejected, including initiation and collection elements access.

Implemented Amazon Redshift distribution style = AUTO.

Oracle

PostgreSQL/Aurora PostgreSQL

If a nonreserved word in Oracle is reserved in PostgreSQL, then the following is true:

  • If the word is quoted, it retains its case and stay quoted.

  • If the word is unquoted, it is cast to uppercase and quoted.

Implemented the ability to use functions as input to LTRIM, RTRIM, and TRIM functions.

SELECT DISTINCT, ORDER BY expressions must appear in select list.

For cursor parameters that follow after a parameter with a DEFAULT value, AWS SCT adds DEFAULT IS NULL clause

Source OUT cursor parameters are converted to IN cursor parameters.

Reimplemented package variable by adding the "Package variables logic implementation" option under "Conversion settings". Available settings are: "session variables" and "plv8 global objects". The default is "session variables".

Implemented AUTONOMOUS_TRANSACTION pragma support with dblink and pg_background.

Oracle

All

Implemented view SYS_%_TAB_COMMENTS.

Oracle

PostgreSQL

Variable inputs to filters aren't supported in PostgreSQL. When converting from Oracle to PostgreSQL, if a variable filter is encountered an exception is now reported.

Oracle

Amazon Redshift

Implemented stored code FOR..LOOP Cursor conversion improvements.

Implemented stored code invocation of function/procedures with default parameters.

Implemented stored code ability to UPDATE with alias without WHERE clause.

Implemented stored code functions preform additional cases with SELECT FROM dual.

Implemented stored code Table%ROWTYPE parameters and package variables.

Implemented stored code used of JAVA and external procedures.

Implemented standard Oracle package in stored code.

Release 1.0.640 Microsoft SQL Server changes

The following table lists build 1.0.640 changes in which Microsoft SQL Server is the source engine.

Source Target What's new, enhanced, or fixed

Microsoft Azure/ Microsoft SQL Server

PostgreSQL/Aurora PostgreSQL/MySQL/Aurora MySQL

Added support for COLUMN STORE indexes.

Microsoft SQL Server

RDS MariaDB 10.4

Added RDS MariaDB 10.4 support for all online transactional processing (OLTP) vendors.

Azure/SQL Server

MariaDB/MySQL/Aurora MySQL/PostgreSQL/Aurora PostgreSQL

Added support for the OPTIMIZE_FOR_SEQUENTIAL_KEY index attribute.

Azure/SQL Server

MySQL/Aurora MySQL/PostgreSQL/Aurora PostgreSQL

Added support for Databases Node and Edge table types.

Azure/SQL Server

MariaDB/MySQL/Aurora MySQL/PostgreSQL/Aurora PostgreSQL

Added support for TEMPORAL TABLES.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

Azure/SQL Server

MySQL/Aurora MySQL/PostgreSQL/Aurora PostgreSQL/MariaDB

Added support for DML processing for SQL Server Graph Architecture.

SQL Server

Aurora PostgreSQL

Added option to convert parameters without the par_ prefix.

Azure/SQL Server

MySQL 8.x

Added support for CHECK constraint.

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

SQL Server

AWS Glue (Python shell)

Conversion improvements, including:

  • Implemented built-in functions conversion to Python.String.

  • Implemented EXECUTE and EXEC in stored code.

  • Implemented using table types.

Azure/SQL Server

PostgreSQL/Aurora PostgreSQL

Implemented making $TMP procedures optional.

SQL Server

MySQL/Aurora MySQL

Extended arithmetic operations with dates.

Construction emulation 'TOP (expression) WITH TIES.

After calling procedures with the generated refcursor out, the refcursor now closes.

Setting a GLOBAL isolation level isn't supported in Aurora MySQL. Only the session scope can be changed. The default behavior of transactions is to use REPEATABLE READ and consistent reads. Applications designed for use with READ COMMITTED may need to be modified. Alternatively, they can explicitly change the default to READ COMMITTED.

SQL Server

AWS Glue (Python shell)

SQL Server statements produce a complete result set, but there are times when the results are best processed one row at a time. Opening a cursor on a result set allows processing the result set one row at a time. You can assign a cursor to a variable or parameter with a cursor data type.

Implemented enclosing a series of Transact-SQL statements for stored code so that a group of Transact-SQL statements can be run even though Python doesn't support SQL Server's BEGIN and END as control-of-flow.

SQL Server LABEL and GOTO statements aren't supported by AWS Glue. If AWS SCT encounters a label in the code, it is skipped. If AWS SCT encounters a GOTO statement, it is commented.

SQL Server

Amazon Redshift

Implemented conditional processing of Transact-SQL statements for stored code by implementing the IF ... ELSE control.

Implemented enclosing a series of Transact-SQL statements for stored code so that a group of Transact-SQL statements can be run as a block. Supports nested BEGIN ... END blocks.

Implemented SET and SELECT in stored code.

Implemented CREATE INDEX in Amazon Redshift (which doesn't support indexes) by creating a user-specified sort key on the tables.

Release 1.0.640 MySQL Changes

The following table lists build 1.0.640 changes in which MySQL is the source engine.

Source Target What's new, enhanced, or fixed

MySQL

PostgreSQL 12.x

Added support for generated columns.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

MySQL

PostgreSQL/Aurora PostgreSQL 11.

Added support for the following:

  • Embedded transactions inside SQL stored procedures.

  • The ability to CALL SQL stored procedures.

  • The ability to create SQL stored procedures.

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

Release 1.0.640 PostgreSQL changes

The following table lists build 1.0.640 changes in which PostgreSQL is the source engine.

Source Target What's new, enhanced, or fixed

PostgreSQL

MySQL 8.x

MySQL now supports creation of functional index key parts that index expression values rather than column values. Functional key parts enable indexing of values, such as JSON values, that can't be indexed otherwise.

MySQL now supports Now CTE and Recursive CTE.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

PostgreSQL 11.x

PostgreSQL/Aurora PostgreSQL 11.

Added support for the following:

  • Embedded transactions inside SQL stored procedures.

  • The ability to CALL SQL stored procedures.

  • The ability to create SQL stored procedures.

PostgreSQL

MySQL 8.x

Added MySQL support for descending indexes. DESC in an index definition is no longer ignored, but causes storage of key values in descending order.

Added MySQL support the use of expressions as default values in data type specifications, including expressions as default values for the BLOB, TEXT, GEOMETRY, and JSON data types.

Several existing aggregate functions can now be used as window functions:

  • AVG()

  • BIT_AND()

  • BIT_OR()

  • BIT_XOR()

  • COUNT()

  • JSON_ARRAYAGG()

  • JSON_OBJECTAGG()

  • MAX()

  • MIN()

  • STDDEV_POP()

  • STDDEV()

  • STD()

  • STDDEV_SAMP()

  • SUM()

  • VAR_POP()

  • VARIANCE()

  • VAR_SAMP()

MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row.

  • CUME_DIST()

  • DENSE_RANK()

  • FIRST_VALUE()

  • LAG()

  • LAST_VALUE()

  • LEAD()

  • NTH_VALUE()

  • NTILE()

  • PERCENT_RANK()

  • RANK()

  • ROW_NUMBER()

PostgreSQL

MySQL 8.x

Added support for CHECK constraint.

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

PostgreSQL/Aurora PostgreSQL

All

Added system view sysindexes emulation.

If there is a SELECT statement in a procedure without specifying INTO, the parameter INOUT p_refcur of type refcursor is created for a procedure on the target.

Release 1.0.640 Db2 LUW changes

The following table lists build 1.0.640 changes in which DB2 LUW is the source engine.

Source Target What's new, enhanced, or fixed

DB2 LUW

RDS MariaDB 10.4

Added RDS MariaDB 10.4 support for all online transactional processing (OLTP) vendors.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

DB2 LUW

MySQL 8.0.17

Added CHECK constraint support.

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

Release 1.0.640 Teradata changes

The following table lists build 1.0.640 changes Teradata source engines.

Source Target What's new, enhanced, or fixed

Teradata

Amazon Redshift

Added support for the MERGE and QUALIFY statements.

Removed LOCKING ROWS FOR ACCESS clause from Teradata statements.

Added support for CAST function.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

Teradata

Teradata

Implemented improvements in REGEXP_INSTR() and REGEXP_SUBSTR().

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

Teradata

All

Added support for REGEXP_INSTR() and REGEXP_SUBSTR().

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

Teradata

Amazon Redshift

Implemented the ability to save SQL of the source tree into single file or multiple files by stage using the settings in Project Settings, Save as SQL and Apply, Dropdown list: Single file/Multiple files.

Implemented improvements in views and procedures conversions.

Teradata

All

Added support for Teradata version 16.20

Release 1.0.640 changes for other engines

The following table lists build 1.0.640 changes for other source engines.

Source Target What's new, enhanced, or fixed

Sybase

RDS MariaDB 10.4

Added RDS MariaDB 10.4 support for all online transactional processing (OLTP) vendors.

SAP ASE

MariaDB

Implemented the following:

  • MariaDB 10.4

  • EXECUTE IMMEDIATE statement

  • DEFAULT definitions

  • CHECK constraint support

SAP ASE

PostgreSQL 12.x

Added support for generated columns.

All

All

Upgrade to Amazon Corretto JDK 11 from JDK 8. For more information, including download links, see What is Amazon Corretto 11? in the Amazon Corretto 11 User Guide.

All

All

Added information to the assessment report about possible inconsistencies in the user's database.

SAP ASE

MySQL 8.0.17

Added CHECK constraint support.

All

SQL Server

SQL Server 2019: Added support for new index attribute OPTIMIZE_FOR_SEQUENTIAL_KEY.

SQL Server 2017: Added support for Graph Databases Node and Edge table types.

SQL Server 2016: Added support for TEMPORAL TABLES.

Vertica

Amazon Redshift

Added support for distribution style = AUTO.

All

All

Implemented the ability to override physical partitions with virtual partitions. Data warehouse extractors extract data according to created virtual partitions.

Amazon Redshift

Amazon Redshift

Unsupported built-in functions in DML statements are replaced with NULL as a placeholder.

Sybase

PostgreSQL

Added support for native functions.

SAP ASE

MySQL/Aurora MySQL

The default isolation level for Aurora MySQL is REPEATABLE READ. Setting a GLOBAL isolation level isn't supported in Aurora MySQL. Only session scope can be changed. The default behavior of transactions is to use REPEATABLE READ and consistent reads. Applications designed to run with READ COMMITTED may need to be modified. Or you can explicitly change the default to READ COMMITTED.

SAP ASE

PostgreSQL

Added support for the CONVERT function(optimistic) without the extension pack.

SAP ASE

All

Added system view sysindexes emulation.

If there is a SELECT statement in a procedure without specifying INTO, the parameter INOUT p_refcur of type refcursor is created for a procedure on the target.

Greenplum

Amazon Redshift

Implemented CREATE TEMPORARY TABLE as follows:

  • Greenplum temporary tables have parameters GLOBAL and LOCAL. These keywords are present for SQL standard compatibility, but have no effect in a Greenplum.

  •  

  • The new table is created as a temporary table. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction (see ON COMMIT). Existing permanent tables with the same name aren't visible to the current session while the temporary table exists, unless they are referenced with schema-qualified names. Any indexes created on a temporary table are automatically temporary as well.