Column and table collation
When replicating from Microsoft Azure SQL Managed Instance 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 Microsoft Azure SQL Managed Instance database are the same as those defined for the 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