AWS SchemaConversionTool documentation change
Summary
Multiple documentation updates including rebranding to 'AWS SCT', link corrections, added support for new data sources/conversions, improved assessment processes, and JDBC driver updates
Security assessment
Added documentation for AWS Secrets Manager/SSL integration in multiserver assessments and Oracle Unified Auditing support, which are security features. No specific vulnerabilities addressed.
Diff
diff --git a/SchemaConversionTool/latest/userguide/CHAP_ReleaseNotes.md b/SchemaConversionTool/latest/userguide/CHAP_ReleaseNotes.md index 512059d39..b65ca27a5 100644 --- a/SchemaConversionTool/latest/userguide/CHAP_ReleaseNotes.md +++ b/SchemaConversionTool/latest/userguide/CHAP_ReleaseNotes.md @@ -7 +7 @@ Release notes – 676Release notes – 675Release notes – 674Release notes – -# Release notes for AWS Schema Conversion Tool +# Release notes for AWS SCT @@ -270 +270 @@ All | Amazon Redshift | Resolved an issue where AWS SCT data extraction agents d -Apache Oozie | AWS Step Functions | Implemented support for the migration from Apache Oozie to AWS Step Functions in the command line interface (CLI) mode. After migrating your Hadoop workloads to Amazon EMR, you can now migrate the workflow scheduling system to the AWS Cloud. For more information, see [Converting Oozie workflows;](./big-data-oozie.html). +Apache Oozie | AWS Step Functions | Implemented support for the migration from Apache Oozie to AWS Step Functions in the command line interface (CLI) mode. After migrating your Hadoop workloads to Amazon EMR, you can now migrate the workflow scheduling system to the AWS Cloud. For more information, see [Converting Apache Oozie to AWS Step Functions](./big-data-oozie.html). @@ -296,2 +296,2 @@ Azure SQL Database Microsoft SQL Server | Aurora PostgreSQL PostgreSQL | Resolve -BigQuery | Amazon Redshift | Added support for BigQuery as a source for the multiserver assessment process. For more information, see [Multiserver assessment report](./CHAP_AssessmentReport.Multiserver.html). -Hadoop | Amazon EMR | Updated the version of the supported Apache Hive JDBC driver that you use to connect to your source databases. For more information, see [Installing JDBC drivers for AWS Schema Conversion Tool](./CHAP_Installing.JDBCDrivers.html). +BigQuery | Amazon Redshift | Added support for BigQuery as a source for the multiserver assessment process. For more information, see [Creating a multiserver assessment report](./CHAP_AssessmentReport.Multiserver.html). +Hadoop | Amazon EMR | Updated the version of the supported Apache Hive JDBC driver that you use to connect to your source databases. For more information, see [Downloading the required database drivers](./CHAP_Installing.html#CHAP_Installing.JDBCDrivers). @@ -353 +353 @@ Azure SQL Database Microsoft SQL Server | Aurora PostgreSQL PostgreSQL | Resolve -Azure Synapse Analytics | Amazon Redshift | Added support for Azure Synapse Analytics as a source for the multiserver assessment process. For more information, see [Multiserver assessment report](./CHAP_AssessmentReport.Multiserver.html). +Azure Synapse Analytics | Amazon Redshift | Added support for Azure Synapse Analytics as a source for the multiserver assessment process. For more information, see [Creating a multiserver assessment report](./CHAP_AssessmentReport.Multiserver.html). @@ -384 +384 @@ Source | Target | What's new, enhanced, or fixed -All | All | Improved the multiserver assessment process, which helps determine the optimal target database platform for your source databases. Now, AWS SCT ignores the AWS Secrets Manager key if you provide database credentials in the input comma separated values (CSV) file. For more information, see [Multiserver assessment report](./CHAP_AssessmentReport.Multiserver.html). +All | All | Improved the multiserver assessment process, which helps determine the optimal target database platform for your source databases. Now, AWS SCT ignores the AWS Secrets Manager key if you provide database credentials in the input comma separated values (CSV) file. For more information, see [Creating a multiserver assessment report](./CHAP_AssessmentReport.Multiserver.html). @@ -440 +440 @@ Netezza | Amazon Redshift | Enhanced the source metadata loader to ensure that A -Oracle | Aurora PostgreSQL PostgreSQL | Added new functions to the extension pack to improve conversion of local nested tables. These new functions emulate `PRIOR`, `NEXT`, `LIMIT`, `FIRST`, `LAST`, `EXISTS`, `EXTEND`, `TRIM`, `DELETE`, and `SET` functions in your source Oracle code. For more information, see [Extension packs](./CHAP_ExtensionPack.html). +Oracle | Aurora PostgreSQL PostgreSQL | Added new functions to the extension pack to improve conversion of local nested tables. These new functions emulate `PRIOR`, `NEXT`, `LIMIT`, `FIRST`, `LAST`, `EXISTS`, `EXTEND`, `TRIM`, `DELETE`, and `SET` functions in your source Oracle code. For more information, see [Using extension packs](./CHAP_ExtensionPack.html). @@ -456 +456 @@ SAP ASE | Aurora PostgreSQL PostgreSQL | Resolved an issue where `CONVERT` func -Snowflake | Amazon Redshift | Added support of Snowflake as a source for data migration with AWS SCT data extraction agents. For more information, see [Migrating data from on-premises data warehouse to Amazon Redshift with AWS Schema Conversion Tool](./agents.html). +Snowflake | Amazon Redshift | Added support of Snowflake as a source for data migration with AWS SCT data extraction agents. For more information, see [Migrating data from an on-premises data warehouse to Amazon Redshift](./agents.html). @@ -463,2 +463,2 @@ Source | Target | What's new, enhanced, or fixed -All | All | Implemented support of Informatica extract, transform, and load (ETL) scripts in the command line interface (CLI) mode. AWS SCT automatically redirects your Informatica ETL scripts to the new target database. Also, AWS SCT converts object names and SQL code that is embedded in your Informatica objects. For more information, see [Informatica ETL scripts](./CHAP-converting-informatica.html). -All | Amazon Redshift | Increased the minimum supported driver version for Amazon Redshift to 2.1.0.9. For more information, see [Installing JDBC drivers for AWS Schema Conversion Tool](./CHAP_Installing.JDBCDrivers.html). +All | All | Implemented support of Informatica extract, transform, and load (ETL) scripts in the command line interface (CLI) mode. AWS SCT automatically redirects your Informatica ETL scripts to the new target database. Also, AWS SCT converts object names and SQL code that is embedded in your Informatica objects. For more information, see [Converting Informatica ETL scripts](./CHAP-converting-informatica.html). +All | Amazon Redshift | Increased the minimum supported driver version for Amazon Redshift to 2.1.0.9. For more information, see [Downloading the required database drivers](./CHAP_Installing.html#CHAP_Installing.JDBCDrivers). @@ -467 +467 @@ Azure Synapse Analytics | Amazon Redshift | Improved conversion of the `DATEDIFF -Azure Synapse Analytics Microsoft SQL Server DW | Amazon Redshift | Updated the extension pack version. Make sure that you apply the latest version of the extension pack in your existing AWS SCT projects. For more information, see [Extension packs](./CHAP_ExtensionPack.html). +Azure Synapse Analytics Microsoft SQL Server DW | Amazon Redshift | Updated the extension pack version. Make sure that you apply the latest version of the extension pack in your existing AWS SCT projects. For more information, see [Using extension packs](./CHAP_ExtensionPack.html). @@ -479 +479 @@ Microsoft SQL Server DW | Amazon Redshift | Improved conversion of `DATEADD` fun -Oracle | Aurora PostgreSQL PostgreSQL | Improved SQL code conversion in Java applications by adding support for the MyBatis framework. For more information, see [SQL code in Java](./CHAP_Converting.App.Java.html). +Oracle | Aurora PostgreSQL PostgreSQL | Improved SQL code conversion in Java applications by adding support for the MyBatis framework. For more information, see [Converting SQL code in Java applications](./CHAP_Converting.App.Java.html). @@ -512 +512 @@ Oracle | Aurora PostgreSQL PostgreSQL | Improved performance of the converted c -Oracle | Aurora PostgreSQL PostgreSQL | Improved SQL code conversion in Java applications by adding support for the MyBatis framework. For more information, see [SQL code in Java](./CHAP_Converting.App.Java.html). +Oracle | Aurora PostgreSQL PostgreSQL | Improved SQL code conversion in Java applications by adding support for the MyBatis framework. For more information, see [Converting SQL code in Java applications](./CHAP_Converting.App.Java.html). @@ -540 +540 @@ Azure Synapse Analytics | Amazon Redshift | Resolved an error where the AWS SCT -BigQuery | Amazon Redshift | Implemented conversion of BigQuery data warehouses to Amazon Redshift. For more information, see [Connecting to Google BigQuery with AWS Schema Conversion Tool](./CHAP_Source.BigQuery.html). +BigQuery | Amazon Redshift | Implemented conversion of BigQuery data warehouses to Amazon Redshift. For more information, see [Using BigQuery as a source for AWS SCT](./CHAP_Source.BigQuery.html). @@ -572 +572 @@ All | All | Added support of Amazon Redshift Serverless as a source and target f -All | All | Improved the user interface of the **Conversion settings** window. AWS SCT now displays settings only for database conversion pairs with created mapping rules. For more information, see [Data type mapping](./CHAP_Mapping.html). +All | All | Improved the user interface of the **Conversion settings** window. AWS SCT now displays settings only for database conversion pairs with created mapping rules. For more information, see [Creating mapping rules](./CHAP_Mapping.html). @@ -584 +584 @@ Oracle | Aurora PostgreSQL PostgreSQL | Improved conversion of the `SYS_EXTRACT_ -Oracle | Aurora PostgreSQL PostgreSQL | Improved SQL code conversion in C++ applications by implementing support of `Wcscats`, `Wcscpys`, and `Wcsncats` functions. For more information, see [Converting SQL code in C++ applications with AWS Schema Conversion Tool](./CHAP_Converting.App.Cplusplus.html). +Oracle | Aurora PostgreSQL PostgreSQL | Improved SQL code conversion in C++ applications by implementing support of `Wcscats`, `Wcscpys`, and `Wcsncats` functions. For more information, see [Converting SQL code in C++ applications with AWS SCT](./CHAP_Converting.App.Cplusplus.html). @@ -586 +586 @@ Oracle DW Snowflake | Amazon Redshift | Resolved an issue where converted statem -Teradata | Amazon Redshift | Added the ability to change column collation between `case sensitive` and `case insensitive` in migration rules. For more information, see [Applying migration rules](./CHAP_Converting.MigrationRules.html). +Teradata | Amazon Redshift | Added the ability to change column collation between `case sensitive` and `case insensitive` in migration rules. For more information, see [ Creating migration rules](./CHAP_Converting.html#CHAP_Converting.MigrationRules). @@ -602,2 +602,2 @@ Source | Target | What's new, enhanced, or fixed -All | All | Added the ability to change the length of `char`, `varchar`, `nvarchar`, and `string` data types using the multiplication operator in a migration rule. For more information, see [Applying migration rules](./CHAP_Converting.MigrationRules.html). -All | All | Implemented support of three new columns in the multiserver assessment report and updated the format of the input file. Make sure that you use the updated template of the input file with the latest version of AWS SCT. For more information, see [Creating a multiserver assessment report in AWS Schema Conversion Tool](./CHAP_AssessmentReport.Multiserver.html). +All | All | Added the ability to change the length of `char`, `varchar`, `nvarchar`, and `string` data types using the multiplication operator in a migration rule. For more information, see [ Creating migration rules](./CHAP_Converting.html#CHAP_Converting.MigrationRules). +All | All | Implemented support of three new columns in the multiserver assessment report and updated the format of the input file. Make sure that you use the updated template of the input file with the latest version of AWS SCT. For more information, see [Creating a multiserver assessment report for database migration](./CHAP_AssessmentReport.Multiserver.html). @@ -627 +627 @@ Source | Target | What's new, enhanced, or fixed -All | All | Added the ability to automatically create AWS SCT projects for each source database when creating the multiserver assessment report. With this option turned on, AWS SCT can add mapping rules to these projects and save conversion statistics for offline use. For more information, see [Creating a multiserver assessment report in AWS Schema Conversion Tool](./CHAP_AssessmentReport.Multiserver.html). +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](./CHAP_AssessmentReport.Multiserver.html). @@ -639 +639 @@ Oracle | Aurora PostgreSQL PostgreSQL | Fixed an extension pack issue where the -Oracle | Aurora PostgreSQL PostgreSQL | Implemented SQL code conversion in C++ applications. For more information, see [Converting SQL code in C++ applications with AWS Schema Conversion Tool](./CHAP_Converting.App.Cplusplus.html). +Oracle | Aurora PostgreSQL PostgreSQL | Implemented SQL code conversion in C++ applications. For more information, see [Converting SQL code in C++ applications with AWS SCT](./CHAP_Converting.App.Cplusplus.html). @@ -667 +667 @@ Source | Target | What's new, enhanced, or fixed -All | All | Added filters to search for mapping rules in the mapping view. When you apply a filter, AWS SCT displays rules that match the filtering conditions in the **Server mappings** list. For more information, see [Editing data type mappings in the AWS Schema Conversion Tool](./CHAP_Mapping.Edit.html). +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](./CHAP_Mapping.Edit.html). @@ -674 +674 @@ Azure Synapse Analytics Microsoft SQL Server DW | Amazon Redshift | Improved con -IBM Db2 for z/OS | Aurora MySQL Aurora PostgreSQL MySQL PostgreSQL | Added support of IBM Db2 for z/OS version 12 as a source for database migration projects in AWS SCT. For more information, see [Connecting to IBM DB2 for z/OS](./CHAP_Source.DB2zOS.html). +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](./CHAP_Source.DB2zOS.html). @@ -684 +684 @@ Microsoft SSIS | AWS Glue AWS Glue Studio | Added a new action item 25042 for un -Microsoft SSIS | AWS Glue Studio | Implemented conversion of Microsoft SQL Server Integration Services (SSIS) extract, transform, and load (ETL) packages to AWS Glue Studio. For more information, see [SSIS to AWS Glue Studio](./CHAP-converting-ssis-glue-studio.html). +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](./CHAP-converting-ssis-glue-studio.html). @@ -706 +706 @@ Source | Target | What's new, enhanced, or fixed -All | All | Added support of AWS Secrets Manager and Secure Sockets Layer (SSL) in the multiserver assessment report. For more information, see [Creating a multiserver assessment report in AWS Schema Conversion Tool](./CHAP_AssessmentReport.Multiserver.html). +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](./CHAP_AssessmentReport.Multiserver.html). @@ -763 +763 @@ Oracle | Amazon RDS for Oracle | Implemented support of Oracle Unified Auditing -Oracle | PostgreSQL Aurora PostgreSQL | Implemented SQL code conversion in C# applications. For more information, see [SQL code in C# applications](./CHAP_Converting.App.Csharp.html). +Oracle | PostgreSQL Aurora PostgreSQL | Implemented SQL code conversion in C# applications. For more information, see [Converting SQL code in C# applications](./CHAP_Converting.App.Csharp.html). @@ -1105 +1105 @@ All | All | Updated and enhanced use of extractor agents, including: -For more information, see [Migrating data from on-premises data warehouse to Amazon Redshift with AWS Schema Conversion Tool](./agents.html). +For more information, see [Migrating data from an on-premises data warehouse to Amazon Redshift](./agents.html).