Document history - AWS Schema Conversion Tool

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.

ChangeDescriptionDate

AWS SCT build #1.0.668

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

AWS SCT build #1.0.667

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

AWS SCT build #1.0.666

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

AWS SCT build #1.0.665

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

AWS SCT build #1.0.664

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

AWS SCT build #1.0.663

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

AWS SCT build #1.0.662

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

AWS SCT build #1.0.661

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

AWS SCT build #1.0.660

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

AWS SCT build #1.0.659

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

AWS SCT build #1.0.658

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

AWS SCT build #1.0.657

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

AWS SCT build #1.0.656

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

AWS SCT build #1.0.655

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

AWS SCT build #1.0.654

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

AWS SCT build #1.0.653

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

AWS SCT build #1.0.652

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

AWS SCT build #1.0.651

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

AWS SCT build #1.0.650

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

AWS SCT build #1.0.649

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

AWS SCT build #1.0.648

Build 1.0.648 adds a number of conversion improvements and bug fixes.

February 22, 2021

AWS SCT build #1.0.647

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

AWS SCT build #1.0.646

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

AWS SCT build #1.0.645

Build 1.0.645 adds support for ETL SSIS to AWS Glue conversion and a number of improvements and bug fixes.

November 16, 2020

AWS SCT build #1.0.643-1.0.644

Build 1.0.644 adds a number of conversion, performance, and user-interface improvements and bug fixes.

October 14, 2020

AWS SCT build #1.0.642

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

AWS SCT build #1.0.641

Added SSL support for data extractors. Build also includes a number of improvements and fixes.

July 17, 2020

AWS SCT builds #1.0.633-1.0.640

Upgraded from JDK 8 to Amazon Corretto JDK 11. Added tables identifying other upgrades, changes, and fixes.

June 22, 2020

AWS WQF availability

AWS SCT is no longer providing the AWS Workload Qualification Framework (AWS WQF) tool for download.

June 19, 2020

AWS SCT builds #1.0.632

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

AWS SCT builds #1.0.631 and #1.0.630 (combined)

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

AWS SCT build #1.0.629

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

AWS SCT build #1.0.628

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

AWS SCT build #1.0.627

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

AWS SCT build #1.0.626

PostgreSQL 11 and MySQL 8.0 are now supported as targets. SAP ASE 15.5 is now supported as a source.

April 26, 2019

AWS SCT build #1.0.625

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

AWS SCT build #1.0.624

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

AWS SCT build #1.0.623

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

AWS SCT build #1.0.622

Updates include the Workload Qualification Framework, which analyzes the workload for an entire migration, including database and app modifications.

December 20, 2018

AWS SCT build #1.0.621

Updates include support for Aurora PostgreSQL 10 as a target, and the ability to migrate from Netezza using external table options.

November 21, 2018

AWS SCT build #1.0.620

Updates include the ability to save SQL scripts, and support for Oracle global cursors when migrating to MySQL.

October 22, 2018

AWS SCT build #1.0.619

Updates include support for migrating from Apache Cassandra to DynamoDB, and support for Vertica 9 as a source.

September 20, 2018

AWS SCT build #1.0.618

Updates include expanded assessment reports, support for converting Oracle ROWIDs, and support for SQL Server user-defined tables.

August 24, 2018

AWS SCT build #1.0.617

Updates include expanded assessment reports, support for converting Oracle ROWIDs, and support for SQL Server user-defined tables.

July 24, 2018

AWS SCT build #1.0.616

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

AWS SCT build #1.0.615

Updates include support for SQL Server to PostgreSQL GOTO statements, PostgreSQL 10 partitioning, and Db2 LUW version 10.1.

May 24, 2018

AWS SCT build #1.0.614

Updates include support for Oracle to Oracle DB Links, SQL Server to PostgreSQL inline functions, and emulation of Oracle system objects.

April 25, 2018

AWS SCT build #1.0.613

Updates include support for Db2 LUW, conversion of SQL*Plus files, and SQL Server Windows Authentication.

March 28, 2018

AWS SCT build #1.0.612

Updates include support for custom data type mapping, schema compare for Oracle 10, and Oracle to PostgreSQL conversion of global variables.

February 22, 2018

AWS SCT build #1.0.611

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

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

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

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 the 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 the custom Python library 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