Skip to main content Skip to complementary content

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

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!