Data types for AWS Database Migration Service - AWS Database Migration Service

Data types for AWS Database Migration Service

AWS Database Migration Service uses built-in data types to migrate data from a source database engine type to a target database engine type. The following table shows the built-in data types and their descriptions.

AWS DMS data types

Description

STRING

A character string.

WSTRING

A double-byte character string.

BOOLEAN

A Boolean value.

BYTE

A binary data value.

DATE

A date value: year, month, day.

TIME

A time value: hour, minutes, seconds.

DATETIME

A timestamp value: year, month, day, hour, minute, second, fractional seconds. The fractional seconds have a maximum scale of 9 digits. The following format is supported: YYYY:MM:DD HH:MM:SS.F(9). For Amazon S3 Select and Amazon S3 Glacier Select, the DATETIME data type format is different. For more information, see the description of the timestamp primitive data type in Supported Data Types of the Amazon Simple Storage Service User Guide.

INT1

A one-byte, signed integer.

INT2

A two-byte, signed integer.

INT4

A four-byte, signed integer.

INT8

An eight-byte, signed integer.

NUMERIC

An exact numeric value with a fixed precision and scale.

REAL4

A single-precision floating-point value.

REAL8

A double-precision floating-point value.

UINT1

A one-byte, unsigned integer.

UINT2

A two-byte, unsigned integer.

UINT4

A four-byte, unsigned integer.

UINT8

An eight-byte, unsigned integer.

BLOB

Binary large object.

CLOB

Character large object.

NCLOB

Native character large object.

Note

AWS DMS can't migrate any LOB data type to an Apache Kafka endpoint.