Data type exceptions
When replicating from Amazon RDS for SQL Server database to a supported Microsoft SQL Server-based target, source and target data types are identical, with the following exceptions:
Amazon RDS for SQL Server Source | Microsoft SQL Server Target |
---|---|
DATETIME |
Supported database versions preceding Microsoft SQL Server 2016: DATETIME Microsoft SQL Server 2016 or later: DATETIME2 |
VARCHAR |
VARCHAR (x) (when x=0 or x>8000) else VARCHAR (max) |
NVARCHAR (length) |
NVARCHAR (x) (when x=0 or x>8000) else NVARCHAR (max) |
VARBINARY |
VARBINARY (x) (when x=0 or x>8000) else VARBINARY (max) |
HIERARCHYID |
STRING(250) |
TIMESTAMP |
VARBINARY |