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 |
|---|---|
|
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 |