Microsoft SQL Server Primary Datatype Translation

Microsoft SQL Server datatypes are compatible with several corresponding Adaptive Server datatypes.

varchar(max), nvarchar(max) and varbinary(max) LOB datatypes cannot be replicated to databases other than Microsoft SQL Server. However, you can replicate the LOB datatypes into SAP HANA database if the Replication Agent parameter lr_partial_updates_allowed is set to false. See Replication Agent Primary Database Guide > Replication Agent for Microsoft SQL Server > Microsoft SQL Server-Specific Considerations > Replicate Microsoft SQL Server Large Object Datatypes into an SAP HANA Database and Replication Agent Reference Manual > Configuration Parameters > Configuration Parameter Reference > lr_partial_updates_allowed.

For a complete list of Microsoft SQL Server to Replication Server default datatype mapping, see the Replication Agent Primary Database Guide > Replication Agent for Microsoft SQL Server> Microsoft SQL Server-Specific Considerations> Microsoft SQL Server Datatype Compatibility.