Unsupported Datatypes

Datatypes that are not supported for Microsoft SQL Server data replication.

  • cursor

  • table

  • xml

Replication Agent does not support these Microsoft SQL Server 2008 datatypes.

  • datetimeoffset

  • filestream

  • geography

  • geometry

  • hierarchyid

  • Large user-defined datatypes

Tables containing columns of unsupported types can be marked by using pdb_setreptable with the force keyword, but replication might fail at runtime time when parsing log of such tables.
Parent topic: Microsoft SQL Server-Specific Considerations