Column and table collation
When replicating from Amazon RDS for SQL Server to a supported Microsoft SQL Server-based target, column and table collations will be replicated to the target.
Information note
To support collation replication, the DBA must ensure that the collations defined for the source Amazon RDS for SQL Server database are the same as those defined for the supported Microsoft SQL Server-based target.
Non-nullable columns and primary/unique index names
Primary/Unique Index names are preserved during homogeneous replication. Non-nullable columns are also preserved during homogeneous replication, with the exception of the following data types:
- text
- ntext1
- varchar(max)
- nvarchar(max)
- varbinary(max)
- image
- xml