Database Migration Service Release Notes

New features in AWS DMS 3.6.1

• DMS Data Resync
  AWS DMS automatically fixes data inconsistencies identified through data validation between your source and target databases. The data resync feature is supported for Oracle and SQL Server as a source and Postgre SQL as a target databases.

• IAM database authentication for MariaDB, MySQL, and PostgreSQL
  Introduced support connecting to Amazon RDS and Aurora MariaDB, MySQL, and PostgreSQL endpoints through AWS Identity and Access Management (IAM) database authentication. With this enhancement you can use IAM to centrally manage access to your database resources, instead of managing access individually on each database endpoint.

• Support for PostgreSQL 17
  Introduced support for PostgreSQL version 17. For more information, see: Using a PostgreSQL database as an AWS DMS source Using a PostgreSQL database as a target for AWS Database Migration Service

• PostgreSQL Read Replica Support for Change Data Capture (CDC) Replication
  AWS DMS supports using PostgreSQL read replicas as source endpoints for Change Data Capture (CDC) replication, available with PostgreSQL version 16.x and later, starting with AWS DMS version 3.6.1. This feature allows you to leverage read replicas for CDC tasks. For more information, see Using a PostgreSQL database as an AWS DMS source.

AWS DMS version 3.6.1 includes the following resolved issues:

• Selection rules filtering with data masking issue
  Table selection rule filters now work correctly with data masking transformation rules. The fix ensures proper filtering when data masking transformations are applied.

• PostgreSQL target unbound numeric handling issue
  PostgreSQL target endpoints can handle unbound numeric data types through optimized memory allocation. This prevents task failures when migrating tables with large numeric values.

• Amazon Redshift target LOB handling issue
  Redshift target endpoints now maintain LOB data integrity during high-volume parallel migrations. The improved LOB handling prevents data corruption when using parallel apply threads.

• Transformation rules metadata issue
  Fixed an issue with expressions in transformation rules that were incorrectly applied.

• Metadata table drop and recreate issue
  Replication tasks now resume successfully when source tables are dropped and recreated during task stoppage. Improved metadata handling and status synchronization for recreated source tables.

• SQL Server AlwaysOn primary replica issue
  Improved primary replica detection for SQL Server sources in AlwaysOn configurations by handling case sensitivity variations.

• MySQL source TIME data type handling issue
  Resolved migration issues with TIME values containing fractions and hours exceeding 24 when loadUsingCSV is disabled.

• Data validation NUL character handling issue
  Data validation now handles NUL (0x00) characters correctly without failing. Improved validation processing for data containing NUL characters.

• SQL Server data validation issue
  Resolved validation comparison issues with UNIQUEIDENTIFIER columns for SQL Server sources.

• Table pre-load validation issue
  AWS DMS tasks now complete validation successfully when tables are in pre-load phase during CDC replication.

• Oracle source logging issue
  Oracle source error logs now display the correct SQL statement during timezone query execution. Improved logging accuracy for better troubleshooting capabilities.

• SQL Server driver update
  SQL Server driver support is updated from ODBC 17 to ODBC 18.

New features in AWS DMS 3.6.0

• New metadata variables for transformations
  Introduced two new metadata variables for transformation rules: $AR_M_MODIFIED_SCHEMA and $AR_M_MODIFIED_TABLE_NAME. These variables allow you to create more dynamic and flexible transformations that can adapt to schema or table name changes during your migration process.
• Support for LOB Column Replication in UPSERT Error-Handling Mode
  Introduced support for replication of Large Object (LOB) columns when using the "No record found for applying an UPDATE: Insert the missing target record" error-handling option. With this enhancement, you can now accurately replicate LOB columns, ensuring complete and accurate data replication.

AWS DMS version 3.6.0 includes the following resolved issues:

• PostgreSQL Memory Issue
  Resolved excessive memory consumption when using PostgreSQL as a source. Fixed an issue where the Write-Ahead Log (WAL) slot would continuously grow, leading to degraded performance. This update enhances the stability and efficiency of PostgreSQL migrations, especially for large databases or long-running tasks.
• Oracle Character Large Object (CLOB) and Character (CHAR) issue
  Addressed the issue where wide Character Large Object (CLOB) and Character (CHAR) values containing non-ASCII characters (e.g., special symbols or international characters) were not replicated correctly. This fix ensures accurate replication of large text data, reducing errors, and maintaining data consistency.
• Microsoft SQL Server Incorrect Latency Issue
  Resolved an issue where the Microsoft SQL Server source endpoint would incorrectly report very high latency. This fix provides more accurate performance metrics, allowing you to better monitor and optimize your SQL Server migration tasks.
• Microsoft SQL Server Metadata Issue
  Fixed an issue with redundant calls to retrieve other tables' metadata, which resulted in degraded performance and latency after a table's metadata had been altered. This optimization improves overall task performance, especially for databases with frequent schema changes.
• Microsoft SQL Server UPDATE Issue
  Fixed an issue where non-standard UPDATE operations caused tasks to terminate unexpectedly without generating error messages. This fix ensures that such operations are processed correctly, avoiding task failures during complex update scenarios.
• Batch Apply Large Object (LOB) issue
  Fixed an issue in Batch Optimized Apply mode where Large Object (LOB) lookup would fail to find a record when a DELETE operation and an INSERT operation were combined into a single UPDATE operation. This fix improves data consistency and integrity during migrations involving LOB data and complex Data Manipulation Language (DML) operations.
• Transformations Task Start Issue
  Addressed an issue where tasks involving numerous transformations would crash during startup. This fix ensures stability and reliability for tasks with complex transformation logic, enabling you to confidently execute data processing tasks.
• MySQL Data Definition Language (DDL) Issue
  Fixed a failure to capture special format Data Definition Language (DDL) changes during the Change Data Capture (CDC) phase. This fix ensures that all schema changes are properly replicated, maintaining schema consistency between source and target databases throughout the migration process.

New features in AWS DMS 3.5.4

• Data masking
  Introduced data masking, allowing transforming sensitive data with options for digit randomization, masking, or hashing at the column level.

• Enhanced Data Validation Performance
  Introduced enhanced data validation performance, enabling faster processing for large datasets during full load and CDC migration tasks across select migration paths.

• PostgreSQL source unicode issue
  Fixed an issues for PostgreSQL source where degraded migration performance was observed while using filtering. Introduced disableUnicodeSourceFilter ECA to control this behavior.

• Transformation support for enhanced throughput feature
  Introduce support for all transformation rules for the enhanced throughput feature.

AWS DMS version 3.5.4 includes the following resolved issues:

• PostgreSQL, test_decoding issue
  Fixed an issue for PostgreSQL source where certain events would not be replicated while using the test_decoding plugin.

• MySQL to Redshift timestamp issue
  Fixed an issue for MySQL to Redshift migrations where a timestamp column would not be defined correctly on the target.

• Oracle July 2024 PSU issue
  Fixed an issue for Oracle source with binary reader where DMS task would crash after applying Oracle July 2024 PSU.

• MySQL secrets manager issue
  Fixed an issue for MySQL endpoint where credentials would become corrupted when using secrets manager.

• Amazon DocumentDB/MongoDB data record handling issue
  Fixed an issue for Amazon DocumentDB/MongoDB endpoints where some records would be sent to the target twice causing duplicate key exception and AWS DMS task failure.

• Relational to noSQL migration issue
  Fixed an issue for RDS for SQL Server to noSQL migrations where the document structure was incorrect due to incorrect PK handling.

• Data validation issue with Oracle endpoint
  Fixed an issue for Oracle source where data validation would report false positives for null or empty LOBs.

• Uniqueidentifier PK issue with Babelfish target.
  Fixed an issue for PG - Babelfish target where AWS DMS task would fail while replicating tables with PK defined as uniqueidentifier.

• PostgreSQL source issue with MAZ.
  Fixed an issue for PostgreSQL source where AWS DMS MAZ failover would cause a fatal AWS DMS task failure.

• Column order issue
  Fixed an issue where LOB data was not replicated correctly when the column order differed between the source and target.

• Internal AWS DMS database contention issue
  Fixed an issue for internal DMS database where the AWS DMS task would fail due to internal AWS DMS database concurency issues.

• Internal AWS DMS database structure issue
  Fixed an issues for internal AWS DMS database where the AWS DMS task would fail due to the lack of presence of certain internal database objects.

• Oracle source data validaiton issue
  Fixed an issue for Oracle source where data validation would return false positives for certain rare types of replicated events.

• Data validation issue for unicode data types
  Fixed an issue for the data validation feature where ceratin unicode data types were not compared properly which resulted in false positives.

• Parquet target timestamp issue
  Fixed an issue for parquet target where zero-timestamp was replicated as null.

• Babelfish target GeoSpatial data type issue.
  Fixed an issue for Babelfish target where the GeoSpatial data type was not supported.

• Amazon S3 target issue with columns being added during CDC
  Fixed an issue for Amazon S3 target where new column additions were not handeled properly when the before image setting was enabled.

• SQL Server 2022 CU12 issue
  Fixed an issue for SQL Server source where AWS DMS could not automatically implement MS Replication prerequisites on sources using SQL Server 2022 with CU12 or above.

• PostgreSQL boolean issue
  Fixed an issue for PostgreSQL source where boolean data type would not be migrated correctly while MapBooleanAsBoolean was set to true and pglogical plugin was used.

• TaskrecoveryTableEnabled setting issue
  Fixed an issue for the TaskrecoveryTableEnabled setting, where the AWS DMS task would fail upon task stop when set to true.

• Data duplication with TaskrecoveryTableEnabled setting
  Fixed an issue where some transactions would be replicated twice when the TaskrecoveryTableEnabled setting was enabled.

• MySQL 5.5 source issue
  Fixed an issue for MySQL source where AWS DMS task would fail due to inability to read the BINLOG from MySQL v5.5.

• Data validation partition issue with corrupted data type names
  Data validation now prevents memory corruption during data type processing, eliminating fallback to row-by-row validation for affected partitions.

• Amazon S3 source to target migration issue
  S3 source to target replication now properly handles external table objects during full load and ongoing replication.

• Amazon S3 target CDC replication issue
  S3 target CDC replication processes CSV format data correctly during ongoing replication phase.

• S3 replication issue
  Enhanced S3 directory cleanup process prevents task interruptions during migrations.

• Data validation performance issue
  Data validation operation now optimizes transitions between validation phases, reducing unnecessary delays.

• Data validation issue with specific data types
  Data validation now accurately processes unbound characters and TEXT data types, ensuring correct validation results.

• PostgreSQL source issue with MAZ
  PostgreSQL source replication maintains connectivity during Multi-AZ failover events, preventing task failures.

• Babelfish datetime validation issue
  Data validation now correctly compares datetime values when using Babelfish as a target.

• MySQL source column replication issue
  MySQL source replication now correctly handles mid-table duplicate column additions, preventing task interruptions.

• MySQL source column modification issue
  MySQL source replication maintains column sequence integrity when multiple columns are added during CDC operations.

• DynamoDB LOB replication issue
  DynamoDB target replication now correctly processes LOB data during CDC, ensuring complete data transfer.

• PostgreSQL boolean data validation issue
  PostgreSQL source data validation now correctly interprets boolean data type mappings, producing accurate comparison results.

• DocumentDB connection recovery issue
  DocumentDB replication maintains data consistency during cluster connectivity interruptions and recovery.

• Oracle extended VARCHAR2 data truncation issue
  Oracle source replication preserves trailing spaces in VARCHAR2(4000) columns when extended data type support is enabled.

• SQL Server secondary replica DDL handling issue
  SQL Server source replication maintains connectivity during DDL operations on secondary replicas, preventing task interruptions.

• Secret Manager special character handling issue
  AWS Secrets Manager connection strings now support special characters while preserving security protocols.

• MongoDB/Amazon DocumentDB duplicate key issue
  MongoDB and Amazon DocumentDB replication prevents record duplication that previously triggered key constraint errors.

• Oracle timestamp handling issue
  Oracle source replication accurately processes timestamp values across various session time zone configurations.

• Oracle data conversion issue
  Oracle source replication now handles data type conversions more robustly, preventing ORA-01460 errors.

• SQL Server 2022 CDC replication issue
  SQL Server sources (CU12 and above) can now automatically implement MS Replication prerequisites in AWS DMS.

• Test decoding DDL handling
  AWS DMS ignores DDL statements for tables not configured in table mappings, preventing unnecessary processing of source database schema changes for unmapped tables.

• Columns truncation from source SQL Server Views
  When migrating data from source SQL Server view to target endpoints, the column length is correctly preserved and no columns are truncated.

• Metrics Recording for enhanced data validation
  AWS DMS now accurately reports validated record metrics when using enhanced data validation.

• DMS task resume issue after upgrade
  When resuming tasks after an AWS DMS version upgrade, DMS tasks do not fail to resume due to incompatible internal file formats.

• SQL Server Always On primary replica issue
  Fixed an issue where AWS DMS now correctly identifies the primary replica in Microsoft SQL Server Always On Availability Groups, resolving previous case sensitivity detection errors.

• PostgreSQL target numeric data handling issue
  Fixed an issue where AWS DMS tasks failed when migrating unbound numeric data types to PostgreSQL target endpoints.

• Data validation character handling issue
  AWS DMS now correctly validates CHAR and VARCHAR data during migrations, eliminating false positive reports in validation tasks.

• Amazon Redshift LOB parallel apply issue
  AWS DMS prevents data corruption in Large Object (LOB) data during parellel batch operations when using Amazon Redshift as a target endpoint.

• Data validation with column filter issue
  Validation failures are prevented and queries are successfully executed on Amazon S3 target when source column filters are applied to VARCHAR, CHAR, DATE, and DATETIME data types.

• S3 validation data persistence issue
  When using Amazon S3 targets, consistent data validation states are maintained throughout Change Data Capture (CDC) operations.

• String formatting validation issue
  Fixed an issue where data validation failed due to string formatting errors during record comparison operations.

New features in AWS DMS 3.5.3

Enhanced PostgreSQL source endpoint for Babelfish support

AWS DMS has enhanced its PostgreSQL source endpoint to support Babelfish datatypes. For more information, see Using a PostgreSQL database as an AWS DMS source.

Support for S3 Parquet as a source

AWS DMS supports S3 Parquet as a source. For more information, see Using Amazon S3 as a source for AWS DMS

Support for PostgreSQL 16.x

AWS DMS supports PostgreSQL version 16.x. For more information, see Using a PostgreSQL database as an AWS DMS source and Using a PostgreSQL database as a target for AWS Database Migration Service.

Enhanced Throughput for Full-Load Oracle to Amazon Redshift Migrations

AWS DMS Serverless provides significantly improved throughput performance for full-load migrations from Oracle to Amazon Redshift. For more information, see Enhanced Throughput for Full-Load Oracle to Amazon Redshift and Amazon S3 Migrations.

Support for RDS for SQL Server Log backups

AWS DMS supports ongoing replication from transaction log backups for RDS for SQL Server sources. This feature is available only to new and modified AWS DMS source endpoints reading from RDS for SQL Server. For more information, see Setting up ongoing replication on a cloud SQL Server DB instance.

AWS DMS version 3.5.3 includes the following resolved issues:

Issues resolved in the DMS 3.5.3 release dated 17-May-2024

• Data Validation override function
• Fixed an issue for the data validation feature where AWS DMS would not honor source filtering when a rule action was set to override-validation-function in table mappings.
• MySQL source CDC errors
• Fixed an issue for MySQL as a source where CDC migration would fail with UTF16 encoding.
• Data validation collation differences
• Fixed an issue for the data validation feature where AWS DMS would not properly apply the HandleCollationDiff task setting when column filtering was used.
• Data validation task hanging.
• Fixed an issue for the data validation feature where the AWS DMS task would hang with a target is null" error.
• Task failures in PostgreSQL to PostgreSQL replication.
• Fixed an issue for PostgreSQL to PostgreSQL migrations where a AWS DMS task would fail while inserting LOB data into the target during CDC replication.
• Data loss with PostgreSQL as a source
• Fixed an issue for PostgreSQL as a source where data loss occurring in certain edge-case scenarios.
• MySQL 5.5 source CDC errors
• Fixed an issue for MySQL as a source where CDC replication would fail with MySQL verion 5.5.
• Oracle source IOT table issue.
• Fixed an issue for Oracle as a source where AWS DMS wouldn't replicate UPDATE statements correctly for IOT tables with supplemental logging enabled on all columns.
• MySQL source LOBS
• Fixed an issue for MySQL to Amazon Redshift migrations where the AWS DMS task would fail due to LOBs exceeding the maximum size allowed by Amazon Redshift.
• Validation issue with SkipLobColumns
• Fixed an issue for the data validation feature where the AWS DMS task would fail with SkipLobColumns = true when a primary key was on the last column in the source table.
• Skip validation where the unique key is null
• Fixed an issue for the data validation feature where AWS DMS doesn't skip rows with null unique keys properly.
• Data validation improvements for Oracle COLLATE operator.
• Fixed an issue for the data validation feature where the validation would fail with a syntax error on Oracle versions prior to 12.2.
• Error handling during full load
• Fixed an issue for PostgreSQL as a target where the task would hang during the full-load phase after a table error caused by invalid data.
• Revalidation of CDC validation-only tasks
• Enhanced the data validation feature to allow revalidation on a CDC validation-only task.
• S3 as a target CdcMaxBatchInterval Out of Memory issue
• Fixed an issue for S3 as a target where the AWS DMS task would fail with an Out of Memory condition with CdcMaxBatchInterval set.
• Oracle source driver
• Upgraded the AWS DMS Oracle source driver from v12.2 to v19.18.
• LOB truncation warning with SQL Server source
• Enhanced logging for SQL Server as a source to show warnings on LOB truncation during CDC.
• Oracle binary reader enhancements
• Enhanced the Oracle source binary reader to support the following: Big Endian platform Parallel DML hints with HCC compression Advanced Oracle Compressions with Golden Gate enabled
• Skip cached changes issue after interruptions
• Fixed an issue for skipping cached changes in case of an unexpected interruption while applying those changes.
• MongoDB AWS DMS swap file issue
• Fixed an issue for MongoDB source where AWS DMS task would fail to resume after AWS DMS upgrade when AWS DMS swap file was present.
• MySQL to Amazon Redshift JSON migration issue.
• Fixed an issue for MySQL source where the JSON data type was not being hadled propely with Batch Apply enabled.
• Data validation issue for SQL Server to APG migrations.
• Fixed an issue for SQL Server to PostgreSQL migration where data validaiton would report false positives in certain situations.
• EmptyAsNull ECA issue for Amazon Redshift target CDC
• Fixed an issue for Amazon Redshift target where the EmptyAsNull ECA would not work correctly.
• Logging enhancement for SQL Server source
• Enhanced logging for SQL Server source to unclude the storage unit value.
• Memory leak issue
• Fixed an issue where for targets using CSV files to load data AWS DMS task was showing a memory leak.
• Amazon S3 target issue
• Fixed an issue for Amazon S3 target where CdcMaxBatchInterval and CdcMinFileSize were not respected when cdcInsertAndUpdateOnly setting was enabled.
• Logging enhancement for Kafka target
• Enhanced logging for Kafka target
• Logging enhancement for Oracle source.
• Enhanced logging for Oracle source with binary reader to properly indicate tables being skipped due to missing primary keys.
• Logging Enhancement for SQL Server source
• Enhanced logging for SQL Server source in AlwaysOn configuration to properly indicate missing permissions.
• Logging Enhancement for migrations with disabled DDL
• Enhanced logging for migrations with disabled DDL replication to indicate unexpected target table structure after its modified outside of AWS DMS.
• Db2 target issue
• Fixed an issue for Db2 target where the task would fail when the AWS DMS status table is enabled.
• MongoDB / Amazon DocumentDB Secret Manger issue.
• Fixed an issue for MongoDB / Amazon DocumentDB endpoints where the credentials could not be retrieved from Secret Manager which resulted in an error.
• MongoDB / Amazon DocumentDB endpoint issue
• Fixed an issue for MongoDB / Amazon DocumentDB where the task would fail with ParallelApply enabled while replicating certain sequence of events.
• Logging enhancement for Amazon Redshift target
• Enhanced logging for Amazon Redshift target to include more detailed information in default logging level.
• Amazon S3 target task crash issue
• Fixed an issue for Amazon S3 target where DMS task would crash after receiving alter table DDL when GlueCatalogGeneration is enabled.
• Data validation issue
• Fixed an issue for data validation feature where validation would fail on NUL (0x00) characters.
• Babelsifh endpoint issue
• Fixed an issue for babelfish endpoint where tables names with mixed case would be suspended.
• Amazon S3 source issue
• Fixed an issue for Amazon S3 source where files were not process due to a file name validation issue.
• Db2 LUC source issue with selection rules.
• Fixed an issue for Db2 LUW source where "table-type" option in selection rules was being ignored.
• Amazon Redshift target missing data issue.
• Fixed an issue for Amazon Redshift target where data loss would occur when ParallelLoadThreads was >0 under certain conditions.
• Data validation enhancement for Amazon Redshift target
• Enhanced the data validation feature for Amazon Redshift target to support HandleCollationDiff setting.
• Amazon S3 target data validation issue
• Fixed an issue for Amazon S3 target data validation where validation would fail when there were no other columns than the PK in the table.
• Data validation CloudWatch metrics
• Fixed an issue for data validation feature where the CloudWatch metrics would be missing for validation which took a short amount of time to complete.
• Data validation re-validate option unavailable
• Fixed an issue for data validation feature where the re-validation option was unavailable in certain situations.
• Large tranasction replication issue
• Fixed an issue where the maximum number of events per transaction was limited to 201,326,592 under certain conditions.
• MySQL source data loss issue
• Fixed an issue for MySQL to Amazon S3 migration where first DML executed after "add column" DDL would be missed resulting in data loss.
• Memory leak issue in batch apply
• Fixed a memory leak issue for batch apply feature which would occur under certain conditions.
• DMS task start issue
• Fixed an issue where AWS DMS task start woudl take a very long time and never complete.
• MySQL source data validation issue.
• Fixed an issue for MySQL source data validation where auto-incremented columns were not handled properly.
• Oracle endpoint Kerberos authentication issue
• Fixed an issue with Oracle endpoint where connectivity would not work with Kerberos authentication.
• Babelfish target uniqueidentifier issue
• Fixed an issue for Babelfish target where replication would fail for tables with primary keys defined as uniqueidentifier.
• PostgreSQL souce missing data issue
• Fixed an issue for PostgreSQL source where data loss would occur due to unknown events in the replication slot.
• Data validation issue for unicode data types.
• Fixed an issue for the data validation feature where ceratin unicode data types were not compared properly which resulted in false positives.
• Redshift Target Timestamp Column
• Fixed an issue with ColumnType definition where timestamp column types were not set correctly
• S3 Target Timestamp Conversion
• Fixed an issue with S3 target parquet file format by handling zero timestamp values (these values should be converted to NULL on the target)
• MySQL source and target LOB columns order
• Fixed an issue with MySQL source and target migrating Lob columns. Now DMS uses the column id from the target table instead of source table when deciding to which column we need to write the LOB Data
• Babelfish target Datetime data types
• Fixed an issue with Babelfish target where we have restricted the fractional seconds precision for Datetime and Time types to solve rounding errors.
• MySQL 5.5 task failures while reading binglog during on going replication (CDC).
• Fixed an issue with MySQL 5.5 source, we have added retry mechanism to prevent task failure when DMS would fail to read binary log events during on going replication (CDC).
• PostgreSQL Source segfault and memory leak issue while using test decoding plugin.
• Fixed an issue with PostgreSQL source where certain onging replication (CDC) events failed to be parsed correctly when using the test_decoding plugin for Postgres.
• DocumentDB Target parallel apply settings
• Fixed an issue with DocumentDB target with parallel apply setting which was preventing the use of multiple threads while using this feature.
• Oracle HCC Compression DIRECT INSERT
• Fixed an issue with Oracle HCC compression DIRECT INSERT with parallel DML hint causing missing and duplicate data.
• Oracle Binary Reader issue with Oracle July 2024 CPU
• Fixed an issue with Oracle source, DMS task with binary reader were failing due to Oracle July 2024 CPU
• Babebfish Target UUID Primary Keys
• Fixed an issue with Babelfish target where DMS task were failing while replicating tables with Primary Key defined as UUID.
• DMS ongoin replication (CDC) tasks failing with TaskRecoveryTableEnabled
• Fixed an issue with TaskRecoveryTableEnabled enabled, where DMS attempts to update the target system table awsdms_txn_state after the target connection is terminated.
• PostgreSQL source duplicate records
• Fixed an issue with PostgreSQL source where some transactions would be replicated twice when the TaskrecoveryTableEnabled setting was enabled.
• DMS S3 source/target replication issue
• Fixed an issue with S3 source to S3 target where DMS task was not replicating data during full load and on going replication.
• DMS S3 source task failure during on going replication
• Fixed an issue for S3 source where DMS task was seg faulting during on going replication for DMS vesion 3.5.3
• DMS DB2 source CcsidMapping ECA
• Fixed an issue with DB2 soruce with CcsidMapping, CCSID mappin ECA is now properly applied to task when code page is 0 and data is migrated properly
• DMS Aurora PostgreSQL to Redshift Serverless Boolean Value replication.
• Fixed an issue where DMS migration from Aurora PostgreSQL to Redshift Serverless was seeing issue with Boolean value.
• Data validation issue with specific data types
• Data validation operation can now accurately processes unbound characters and TEXT data types, ensuring correct validation results.
• PostgreSQL source issue with MAZ
• PostgreSQL source replication maintains connectivity during Multi-AZ failover events, preventing task failures.
• Babelfish datetime validation issue
• Data validation now correctly compares datetime values when using Babelfish as a target, improving cross-platform compatibility.
• MySQL source column replication issue
• MySQL source replication now correctly handles mid-table duplicate column additions, preventing task interruptions.
• MySQL source column modification issue
• MySQL source replication maintains column sequence integrity when multiple columns are added during CDC operations.
• DynamoDB LOB replication issue
• DynamoDB target replication now correctly processes LOB data during CDC, ensuring complete data transfer.
• PostgreSQL boolean data validation issue
• PostgreSQL source data validation now correctly interprets boolean data type mappings, producing accurate comparison results.
• Oracle extended VARCHAR2 data truncation issue
• Oracle source replication preserves trailing spaces in VARCHAR2(4000) columns when extended data type support is enabled.
• SQL Server secondary replica DDL handling issue
• SQL Server source replication maintains connectivity during DDL operations on secondary replicas, preventing task interruptions.
• Secret Manager special character handling issue
• AWS Secrets Manager connection strings now support special characters while preserving security protocols.
• MongoDB/Amazon DocumentDB duplicate key issue
• MongoDB and Amazon DocumentDB replication prevents record duplication that previously triggered key constraint errors.
• Oracle timestamp handling issue
• Oracle source replication accurately processes timestamp values across various session time zone configurations.
• Oracle data conversion issue
• Oracle source caused AWS DMS task to fail with an ORA-01460 error during data type conversion. This update improves the handling of data type conversions to prevent task failures.

New features in AWS DMS 3.5.2
Amazon Redshift data validation
AWS DMS now supports validating data in Amazon Redshift targets.
Support for Microsoft SQL Server version 2022 as a source and target.
AWS DMS now supports using Microsoft SQL Server version 2022 as a source and target.
IBM Db2 LUW as a target
AWS DMS now supports IBM Db2 LUW as a target. Using AWS DMS, you can now perform live migrations from IBM Db2 LUW to IBM Db2 LUW.
AWS DMS version 3.5.2 includes the following resolved issues:
Issues resolved in the DMS 3.5.2 maintenance release dated 29-Apr-2024
IBM Db2 target segmented full load
Added support for segmented full load with IBM Db2 as a target.
Amazon Timestream as a target settings
Enhanced the handling of invalid timestamp settings and unsupported table operations for Timestream as a target.
Task crash with column filter
Fixed an issue where a task was crashing while using a filter on a column that DMS added dynamically using a transformation rule.
Logging transaction swap file reading
Added logging to show when DMS is reading from transaction swap files.
S3 as a target with CdcInsertsAndUpdates
Fixed an issue for S3 as a target where a task would crash when CdcInsertsAndUpdates is true and PreserveTransactions is true.
Source filter negative operators
Fixed an issue where the source filter-operator when set to a negative operator had incorrect behavior if the same column had a transformation rule defined.
Added logging for when DMS pauses reading from the source
Enhanced logging to show when DMS temporarily pauses reading from the source to improve performance.
Source filters with escaped characters
Fixed an issue for source filters where DMS applies escaped characters to newly created tables during CDC.
PostgreSQL as a target, incorrectly replicated deletes
Fixed an issue for PostgreSQL as a target where DMS replicates deletes as null values.
Oracle as a source logging improvements
Enhanced logging for Oracle as a source to remove extraneous error codes.
Improved logging of XMLTYPE limitations
Improved logging for Oracle as a source to show DMS' lack of support for full LOB mode for the XMLTYPE data type.
MySQL data loss
Fixed an issue for MySQL as a target where corrupted column metadata could cause task crashes or data loss.
Filter applied to a new column
Fixed an issue during full load where DMS ignores a filter that a transformation rule adds to a new column.
S3 as a target: Validation issue
Fixed an issue for S3 as a target where data validation would fail while migrating multiple tables with different validation partitioning definitions.
CDC-only task crash
Fixed an issue for CDC-only tasks where the task would crash when TaskRecoveryTableEnabled is true.
MySQL to MariaDB incompatible collations
Fixed an issue for MySQL to MariaDB migrations where DMS doesn't migrate MySQL v8 tables with tf8mb4_0900_ai_ci collation.
Task crashes with BatchApplyEnabled
Fixed an issue for the Batch Apply feature where the task would fail under certain conditions.
Non UTF-8 characters in Amazon DocumentDB
Added support for non UTF-8 characters for Amazon DocumentDB endpoints.
Batch Apply task crash
Fixed an issue for the Batch Apply feature where the DMS task crashes while replicating large transactions.
Db2 transaction rollback handling
Fixed an issue for Db2 as a source where DMS would replicate an INSERT to the target, despite being rolled back on the source.
Validation with source filters
Fixed an issue where validation was not respecting source filters.
MongoDB AWS DMS swap file issue
Fixed an issue for MongoDB source where DMS task would fail to resume after AWS DMS upgrade when AWS DMS swap file was present.
MySQL to Amazon Redshift JSON migration issue.
Fixed an issue for MySQL source where the JSON data type was not being hadled propely with Batch Apply enabled.
MySQL 5.5 source CDC errors
Fixed an issue for MySQL source where CDC replicaiton would fail with MySQL verion 5.5.
LOB migration issue
Fixed an issue for LOB migration where the AWS DMS task would crash while processing certain event types.
Data validation issue
Fixed an issue for Data Validation feature where the Validation-only task would hang on certain DDL events.
Data validation issue with filters.
Fixed an issue for data validation feature where the the HandleCollationDiff setting was not applied when filters were present
MySQL SourceEnum encoding issue.
Fixed an issue for MySQL source where UTF-16 encoded enum values were not migrated correctly.
LOB truncation warning with SQL Server source
Enhanced logging for SQL Server source to show warning on LOB truncation during CDC.
Data validation issue for SQL Server to APG migrations.
Fixed an issue for SQL Server to PostgreSQL migration where data validaiton would report false positives in certain situations.
EmptyAsNull ECA issue for Amazon Redshift target CDC
Fixed an issue for Amazon Redshift target where the EmptyAsNull ECA would not work correctly.
Logging enhancement for SQL Server source
Enhanced logging for SQL Server source to unclude the storage unit value.
Memory leak issue
Fixed an issue where for targets using CSV files to load data AWS DMS task was showing a memory leak.
Amazon S3 target issue
Fixed an issue for Amazon S3 target where CdcMaxBatchInterval and CdcMinFileSize were not respected when cdcInsertAndUpdateOnly setting was enabled.
Logging enhancement for Kafka target
Enhanced logging for Kafka target
Logging enhancement for Oracle source.
Enhanced logging for Oracle source with binary reader to properly indicate tables being skipped due to missing primary keys.
Logging Enhancement for SQL Server source
Enhanced logging for SQL Server source in AlwaysOn configuration to properly indicate missing permissions.
Logging Enhancement for migrations with disabled DDL
Enhanced logging for migrations with disabled DDL replication to indicate unexpected target table structure after its modified outside of AWS DMS.
Db2 target issue
Fixed an issue for Db2 target where the task would fail when the AWS DMS status table is enabled.
MongoDB / Amazon DocumentDB Secret Manger issue.
Fixed an issue for MongoDB / Amazon DocumentDB endpoints where the credentials could not be retrieved from Secret Manager which resulted in an error.
MongoDB / Amazon DocumentDB endpoint issue
Fixed an issue for MongoDB / Amazon DocumentDB where the task would fail with ParallelApply enabled while replicating certain sequence of events.
MongoDB / Amazon DocumentDB data validation issue
Fixed an issue for MongoDB / Amazon DocumentDB data validation where an error would occur after detecting data differences.
Logging enhancement for Amazon Redshift target
Enhanced logging for Amazon Redshift target to include more detailed information in default logging level.
Amazon S3 target task crash issue
FIxed an issue for Amazon S3 target where AWS DMS task would crash after receiving alter table DDL when GlueCatalogGeneration is enabled.
Data validation issue
Fixed an issue for data validation feature where validation would fail on NUL (0x00) characters.
Babelsifh endpoint issue
Fixed an issue for babelfish endpoint where tables names with mixed case would be suspended.
Amazon Redshift target missing data issue
Fixed an issue for Amazon Redshift target where data loss would occur when ParallelLoadThreads was >0 under certain conditions.
Amazon S3 target data validation issue
Fixed an issue for Amazon S3 target data validation where validation would fail when there were no other columns than the PK in the table.
Data validation CloudWatch metrics
Fixed an issue for data validation feature where the CloudWatch metrics would be missing for validation which took a short amount of time to complete.
Data validation re-validate option unavailable
Fixed an issue for data validation feature where the re-validation option was unavailable in certain situations.
Large tranasction replication issue
Fixed an issue where the maximum number of events per transaction was limited to 201,326,592 under certain conditions.
Table reload issue
Fixed an issue where a reload of multiple tables was canceled when at least one of the table was invalid.
MySQL source data loss issue
Fixed an issue for MySQL to S3 migration where first DML executed after "add column" DDL would be missed resulting in data loss.
Memory leak issue in batch apply
Fixed a memory leak issue for batch apply feature which would occur under certain conditions.
DMS task start issue
Fixed an issue where AWS DMS task start woudl take a very long time and never complete.
PostgreSQL souce missing data issue
Fixed an issue for PostgreSQL source where data loss would occur due to unknown events in the replication slot.
Amazon S3 target data loss issue
Fixed an issue for Amazon S3 target where failed LOB lookup would result in data loss.