AWS Database Migration Service Now Supports Expression-Based Data Transformations

Posted on: May 7, 2020

AWS Database Migration Service (DMS) now enables you to dynamically transform and manipulate data being replicated to any supported targets. You can create SQLite-based expressions as part of your replication task that will add columns to your target tables with transformed data, reducing the need for further downstream processing. For example, you can now add a target column with data aggregated from two or more source columns or record the before image of an update/delete in separate columns in the target data store. You can also add details about the commit timestamp or transaction log position of a change record from the source for consolidation purposes.

For more information on the entire set of capabilities, see “Replicating Source Table Headers Using Expressions”.

For DMS availability, refer to the AWS Region Table.