Release notes for AWS SCT - AWS Schema Conversion Tool

Release notes for AWS SCT

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

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 for database migration.

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 SCT.

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 Managing mapping rules.

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 Using IBM Db2 for z/OS as a source.

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 Converting 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 for database migration.

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 Converting 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 Database

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 Using data extraction agents.

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 later 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 Database.

  •  

  • 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.