Document history
The following table describes the important changes to the AWS Schema Conversion Tool (AWS SCT) user guide after January 2018.
You can subscribe to an RSS feed to be notified of updates to this documentation.
| Change | Description | Date |
|---|---|---|
Build 1.0.672 provides support of Amazon RDS for PostgreSQL 15 as a target and Microsoft SQL Server version 2022 as a source. It also adds support for new Amazon Redshift features in the converted code, implements multiple conversion improvements for IBM Db2 for z/OS source, and resolves a number of conversion issues. | May 8, 2023 | |
Build 1.0.671 provides support of migrations from Apache Oozie to AWS Step Functions. It also adds support for BigQuery as a source for the multiserver assessment process. In addition, it adds new conversion settings for IBM Db2 for z/OS as a source and resolves a number of conversion issues. | March 8, 2023 | |
Build 1.0.670 provides support of migrations from Hadoop to Amazon EMR. It also adds support for Azure Synapse Analytics as a source for the multiserver assessment process. In addition, it improves the conversion of SQL code that is embedded in Java applications and resolves a number of conversion issues. | January 23, 2023 | |
Build 1.0.669 implements support of native partitioning for data migration from Oracle data warehouses. It also improves the multiserver assessment process, adds new features in data extraction agents, and resolves a number of conversion issues. | December 19, 2022 | |
Build 1.0.668 implements automatic virtual partitioning for data migration from Greenplum databases, and adds support of data migration from Snowflake databases to Amazon Redshift. It also improves the conversion of SQL code that is embedded in C# applications and resolves a number of conversion issues. | November 16, 2022 | |
Build 1.0.667 provides support for the Informatica extract, transform, and load (ETL) engine as a migration source. It also updates the extension pack version, increases the minimum supported driver version for Amazon Redshift, and resolves a number of conversion issues. | October 13, 2022 | |
Build 1.0.666 improves the conversion of Java applications by adding support for the MyBatis framework. It also adds new functions into extension packs, enhances the source metadata loader, and resolves a number of conversion issues. | September 20, 2022 | |
Build 1.0.665 provides support of BigQuery as a migration source. It also implements support of the new version of the Babelfish features configuration file. In addition, it improves the conversion of data warehouses to Amazon Redshift, and resolves a number of conversion issues. | August 29, 2022 | |
Build 1.0.664 provides support of Amazon Redshift Serverless as a migration source or target. It also implements automatic memory balancing in data extracting tasks, and fixes an error where AWS SCT couldn't connect to AWS Snowball devices. In addition, it adds the ability to change column collation in migration rules, improves the user interface, and resolves a number of conversion issues. | July 14, 2022 | |
Build 1.0.663 adds support for Babelfish for Aurora PostgreSQL 1.2.0 and improves the multiserver assessment report capabilities. It also adds new features in the migration rules, fixes two loader errors, and resolves a number of conversion issues. | June 20, 2022 | |
Build 1.0.662 implements SQL code conversion in C# applications and improves the multiserver assessment report workflow. It also adds multiple conversion improvements and resolves a number of conversion issues. | May 19, 2022 | |
Build 1.0.661 provides support of IBM Db2 for z/OS as a migration source. It also adds support for conversion of extract, transform, and load (ETL) scripts to AWS Glue Studio and resolves a number of conversion issues. | April 21, 2022 | |
Build 1.0.660 provides support of PostgreSQL major version 14 and MariaDB 10.6 as migration targets. It also adds support for conversion of Oracle indexes for materialized views, and resolves a number of conversion issues. | March 21, 2022 | |
Build 1.0.659 provides support of PostgreSQL major version 13 on Aurora PostgreSQL-Compatible Edition as a migration target. It implements SQL code conversion in C# applications, adds support of Oracle Unified Auditing, and resolves a number of conversion issues. | February 21, 2022 | |
Build 1.0.658 provides integration with AWS Secrets Manager and adds support of Amazon Redshift virtual target database platform. It also adds a number of conversion improvements and bug fixes. | January 20, 2022 | |
Build 1.0.657 improves conversion from Microsoft SQL Server to Aurora PostgreSQL-Compatible Edition, Amazon RDS for PostgreSQL, and other migration destinations. It also adds a number of user interface improvements and bug fixes. | December 20, 2021 | |
Build 1.0.656 provides support of multiple source and target databases in one project. It also adds conversion, optimization strategy, and general improvements and a number of bug fixes. | November 22, 2021 | |
Build 1.0.655 implements conversion of Teradata FastExport job scripts to Amazon Redshift RSQL and increases the minimum supported driver version for Greenplum to 42.2.5. It also adds a number of improvements and bug fixes. | October 18, 2021 | |
Build 1.0.654 implements conversion of Shell, Teradata FastLoad, and Teradata Basic Teradata Query (BTEQ) scripts to Amazon Redshift RSQL. It also resolves a number of conversion issues and adds a number of improvements and bug fixes. | September 16, 2021 | |
Build 1.0.653 implements conversion of dynamic SQL created in called functions or procedures. It also improves conversion of encrypted routines and adds a number of improvements and bug fixes. | August 10, 2021 | |
Build 1.0.652 implements script command mode in the command-line interface and implements schema optimization rules. It also adds a number of conversion and performance improvements and bug fixes. | June 30, 2021 | |
Build 1.0.651 adds a number of improvements and bug fixes. It also provides access to the initial copy of the AWS Schema Conversion Tool CLI Reference. | June 4, 2021 | |
Build 1.0.650 implements support of Amazon RDS for PostgreSQL 13 as a target database, updates extractor agents. It also upgrades the minimum supported JDBC driver version for Microsoft SQL Server, Azure, and Azure Synapse. In addition, it adds a number of conversion improvements and bug fixes. | April 30, 2021 | |
Build 1.0.649 implements support of MariaDB 10.5 as a target database and implements function enhancements for conversion of Oracle built-in functions. It also adds a number of conversion and performance improvements and bug fixes. | March 29, 2021 | |
Build 1.0.648 adds a number of conversion improvements and bug fixes. | February 22, 2021 | |
Build 1.0.647 adds support of the Database Mail feature on Amazon RDS, implements load and conversion of comments on storage objects. It also adds AWS SCT Data Migration Service Assessor and AWS SCT Wizard and implements the tree filter user interface. In addition, it adds a redesigned section in the Assessment Report and a number of improvements and bug fixes. | January 15, 2021 | |
Build 1.0.646 adds support for INTERVAL data types, Identity columns, and cursors conversion, and adds a number of improvements and bug fixes. | December 28, 2020 | |
Build 1.0.645 adds support for ETL SSIS to AWS Glue conversion and a number of improvements and bug fixes. | November 16, 2020 | |
Build 1.0.644 adds a number of conversion, performance, and user-interface improvements and bug fixes. | October 14, 2020 | |
Build 1.0.642 implements conversion of ETL packages from Microsoft SQL Server Integration Services to AWS Glue and adds a number of improvements and bug fixes. | August 28, 2020 | |
Added SSL support for data extractors. Build also includes a number of improvements and fixes. | July 17, 2020 | |
Upgraded from JDK 8 to Amazon Corretto JDK 11. Added tables identifying other upgrades, changes, and fixes. | June 22, 2020 | |
AWS SCT is no longer providing the AWS Workload Qualification Framework (AWS WQF) tool for download. | June 19, 2020 | |
SCT UI - Added new tab to show errors that happen when applying scripts. You can now save the source tree as SQL when converting from SAP ASE. Improvements for conversions to PostgreSQL or Aurora PostgreSQL or Redshift. | November 19, 2019 | |
Better support ROWIDs in Oracle, and for system objects in Microsoft SQL Server and SAP ASE. Better handling for missing specifiers of SQL Server schemas. Better support for conversions from Greenplum to Redshift. Improved support for conversion of stored code when moving to Amazon Redshift, MariaDB, MySQL, and PostgreSQL. | September 30, 2019 | |
Support for stored procedures for conversions from Netezza. Improved support for conversions to Amazon Redshift, DynamoDB, MySQL, and PostgreSQL. Added support for SAP ASE 12.5 as a source. | August 20, 2019 | |
Support for service emulation for conversions from DB2, SQL Server and Oracle. Enhancements for conversions to Amazon Redshift, including more support for cursors and stored procedures. | June 22, 2019 | |
Support for conversions from SQL Server to stored procedures in Amazon Redshift. Enhancements for converting to PostgreSQL 11 and MySQL 8.0. | May 31, 2019 | |
PostgreSQL 11 and MySQL 8.0 are now supported as targets. SAP ASE 15.5 is now supported as a source. | April 26, 2019 | |
Updates include the ability to convert Teradata BTEQ to AWS Glue, support for conversions to MariaDB 10.3 with Oracle compatibility mode support, support for SAP ASE 15.7, and service substitutions to emulate missing functionality. | March 25, 2019 | |
Updates include the ability to convert Oracle ETL to AWS Glue, and support for conversions from Microsoft SQL Server, Oracle, and IBM Db2 LUW to Amazon RDS for MariaDB. We also added support for conversions from SAP ASE to RDS for MySQL and Amazon Aurora with MySQL compatibility. In addition, we added support for the Orafce extension during Oracle conversion to PostgreSQL. | February 22, 2019 | |
Updates include the ability to convert SAP ASE databases, and the ability to convert T-SQL scripts, DML, and DDL to equivalent code or components. We also added Oracle and Microsoft SQL Server emulations to improve conversions. | January 25, 2019 | |
Updates include the Workload Qualification Framework, which analyzes the workload for an entire migration, including database and app modifications. | December 20, 2018 | |
Updates include support for Aurora PostgreSQL 10 as a target, and the ability to migrate from Netezza using external table options. | November 21, 2018 | |
Updates include the ability to save SQL scripts, and support for Oracle global cursors when migrating to MySQL. | October 22, 2018 | |
Updates include support for migrating from Apache Cassandra to DynamoDB, and support for Vertica 9 as a source. | September 20, 2018 | |
Updates include expanded assessment reports, support for converting Oracle ROWIDs, and support for SQL Server user-defined tables. | August 24, 2018 | |
Updates include expanded assessment reports, support for converting Oracle ROWIDs, and support for SQL Server user-defined tables. | July 24, 2018 | |
Updates include support for RDS when converting from Oracle to Amazon RDS for Oracle, converting Oracle schedule objects, and support for Oracle jobs. partitioning, and Db2 LUW version 10.1. | June 26, 2018 | |
Updates include support for SQL Server to PostgreSQL GOTO statements, PostgreSQL 10 partitioning, and Db2 LUW version 10.1. | May 24, 2018 | |
Updates include support for Oracle to Oracle DB Links, SQL Server to PostgreSQL inline functions, and emulation of Oracle system objects. | April 25, 2018 | |
Updates include support for Db2 LUW, conversion of SQL*Plus files, and SQL Server Windows Authentication. | March 28, 2018 | |
Updates include support for custom data type mapping, schema compare for Oracle 10, and Oracle to PostgreSQL conversion of global variables. | February 22, 2018 | |
Updates include support for Oracle to PostgreSQL dynamic statements, opening the log file by selecting an error message, and the ability to hide schemas in tree view. | January 23, 2018 |
Earlier updates
The following table describes the important changes to the AWS Schema Conversion Tool (AWS SCT) user guide prior to January 2018.
| Version | Change | Description | Date changed |
|---|---|---|---|
|
1.0.608 |
FIPS endpoint support for Amazon S3 |
You can now request AWS SCT to connect to Amazon S3 and Amazon Redshift by using FIPS endpoints to comply with Federal Information Processing Standard security requirements. For more information, see Storing AWS credentials. |
November 17, 2017 |
|
1.0.607 |
FIPS endpoint support for Amazon S3 |
You can now request AWS SCT to connect to Amazon S3 and Amazon Redshift by using FIPS endpoints to comply with Federal Information Processing Standard security requirements. For more information, see Storing AWS credentials. |
October 30, 2017 |
|
1.0.607 |
Data extraction tasks can ignore LOBs |
When you create data extraction tasks, you can now choose to ignore large objects (LOBs) to reduce the amount of data that you extract. For more information, see Creating, running, and monitoring an AWS SCT data extraction task. |
October 30, 2017 |
|
1.0.605 |
Data extraction agent task log access |
You can now access the data extraction agent task log from a convenient link in the AWS Schema Conversion Tool user interface. For more information, see Creating, running, and monitoring an AWS SCT data extraction task. |
August 28, 2017 |
|
1.0.604 |
Converter enhancements |
The AWS Schema Conversion Tool engine has been enhanced to offer improved conversions for heterogeneous migrations. |
June 24, 2017 |
|
1.0.603 |
Data extraction agents support filters |
You can now filter the data that the extraction agents extract from your data warehouse. For more information, see Creating data migration rules in AWS SCT. |
June 16, 2017 |
|
1.0.603 |
AWS SCT supports additional data warehouse versions |
You can now use the AWS Schema Conversion Tool to convert your Teradata 13 and Oracle Data Warehouse 10 schemas to equivalent Amazon Redshift schemas. For more information, see Converting data warehouse schemas to Amazon Redshift using AWS SCT. |
June 16, 2017 |
|
1.0.602 |
Data extraction agents support additional data warehouses |
You can now use data extraction agents to extract data from your Microsoft SQL Server data warehouses. For more information, see Migrating data from an on-premises data warehouse to Amazon Redshift. |
May 11, 2017 |
|
1.0.602 |
Data extraction agents can copy data to Amazon Redshift |
Data extraction agents now have three upload modes. You can now specify whether to just extract your data, to extract your data and just upload it to Amazon S3, or to extract, upload, and copy your data directly into Amazon Redshift. For more information, see Creating, running, and monitoring an AWS SCT data extraction task. |
May 11, 2017 |
|
1.0.601 |
AWS SCT supports additional data warehouses |
You can now use the AWS Schema Conversion Tool to convert your Vertica and Microsoft SQL Server schemas to equivalent Amazon Redshift schemas. For more information, see Converting data warehouse schemas to Amazon Redshift using AWS SCT. |
April 18, 2017 |
|
1.0.601 |
Data extraction agents support additional data warehouses |
You can now use data extraction agents to extract data from your Greenplum, Netezza, and Vertica data warehouses. For more information, see Migrating data from an on-premises data warehouse to Amazon Redshift. |
April 18, 2017 |
|
1.0.601 |
Data extraction agents support additional operating systems |
You can now install data extraction agents on computers running the macOS and Microsoft Windows operating systems. For more information, see Installing extraction agents. |
April 18, 2017 |
|
1.0.601 |
Data extraction agents upload to Amazon S3 automatically |
Data extraction agents now upload your extracted data to Amazon S3 automatically. For more information, see Data extraction task output. |
April 18, 2017 |
|
1.0.600 |
Data Extraction Agents |
You can now install data extraction agents that extract data from your data warehouse and prepare it for use with Amazon Redshift. You can use the AWS Schema Conversion Tool to register the agents and create data extraction tasks for them. For more information, see Migrating data from an on-premises data warehouse to Amazon Redshift. |
February 16, 2017 |
|
1.0.600 |
Customer Feedback |
You can now provide feedback about the AWS Schema Conversion Tool. You can file a bug report, you can submit a feature request, or you can provide general information. For more information, see Providing feedback. |
February 16, 2017 |
|
1.0.502 |
Integration with AWS DMS |
You can now use the AWS Schema Conversion Tool to create AWS DMS endpoints and tasks. You can run and monitor the tasks from AWS SCT. For more information, see Using AWS SCT with AWS DMS. |
December 20, 2016 |
|
1.0.502 |
Amazon Aurora with PostgreSQL compatibility as a target database |
The AWS Schema Conversion Tool now supports Amazon Aurora with PostgreSQL compatibility as a target database. For more information, see Converting database schemas using AWS SCT. |
December 20, 2016 |
|
1.0.502 |
Support for profiles |
You can now store different profiles in the AWS Schema Conversion Tool and easily switch between them. For more information, see Storing AWS service profiles in AWS SCT. |
December 20, 2016 |
|
1.0.501 |
Support for Greenplum Database and Netezza |
You can now use the AWS Schema Conversion Tool to convert your data warehouse schemas from Greenplum Database and Netezza to Amazon Redshift. For more information, see Converting data warehouse schemas to Amazon Redshift using AWS SCT. |
November 17, 2016 |
|
1.0.501 |
Redshift optimization |
You can now use the AWS Schema Conversion Tool to optimize your Amazon Redshift databases. For more information, see Optimizing Amazon Redshift by using AWS SCT. |
November 17, 2016 |
|
1.0.500 |
Mapping rules |
Before you convert your schema with the AWS Schema Conversion Tool, you can now set up rules that change the data type of columns, move objects from one schema to another, and change the names of objects. For more information, see Creating migration rules in AWS SCT. |
October 4, 2016 |
|
1.0.500 |
Move to cloud |
You can now use the AWS Schema Conversion Tool to copy your existing on-premises database schema to an Amazon RDS DB instance running the same engine. You can use this feature to analyze potential cost savings of moving to the cloud and of changing your license type. For more information, see Creating migration assessment reports with AWS SCT. |
October 4, 2016 |
|
1.0.400 |
Data warehouse schema conversions |
You can now use the AWS Schema Conversion Tool to convert your data warehouse schemas from Oracle and Teradata to Amazon Redshift. For more information, see Converting data warehouse schemas to Amazon Redshift using AWS SCT. |
July 13, 2016 |
|
1.0.400 |
Application SQL conversions |
You can now use the AWS Schema Conversion Tool to convert SQL in your C++, C#, Java, or other application code. For more information, see Converting application SQL using AWS SCT. |
July 13, 2016 |
|
1.0.400 |
New feature |
The AWS Schema Conversion Tool now contains an extension pack and a wizard to help you install, create, and configure AWS Lambda functions and Python libraries to provide email, job scheduling, and other features. For more information, see Using the AWS Lambda functions from the AWS SCT extension pack and Using custom libraries for AWS SCT extension packs. |
July 13, 2016 |
|
1.0.301 |
SSL Support |
You can now use Secure Sockets Layer (SSL) to connect to your source database when you use the AWS Schema Conversion Tool. |
May 19, 2016 |
|
1.0.203 |
New feature |
Adds support for MySQL and PostgreSQL as source databases for conversions. |
April 11, 2016 |
|
1.0.202 |
Maintenance release |
Adds support for editing the converted SQL that was generated for the target database engine. Adds improved selection capabilities in the source database and target DB instance tree views. Adds support for connecting to an Oracle source database using Transparent Network Substrate (TNS) names. |
March 2, 2016 |
|
1.0.200 |
Maintenance release |
Adds support for PostgreSQL as a target database engine. Adds the ability to generate converted schema as scripts and to save the scripts to files prior to applying the schema to the target DB instance. |
January 14, 2016 |
|
1.0.103 |
Maintenance release |
Adds offline project capability, the ability to check for new versions, and memory and performance management. |
December 2, 2015 |
|
1.0.101 |
Maintenance release |
Adds the Create New Database Migration Project wizard. Adds the ability to save the database migration assessment report as a PDF file. |
October 19, 2015 |
|
1.0.100 |
Preview release |
Provides the user guide for the AWS Schema Conversion Tool preview release. |
October 7, 2015 |
