To replicate tables with structured User-Defined Types (UDT) columns successfully, the structured UDT must satisfy the following requirements:
- The CAST function must be defined for the default TO-SQL transform.
- The default transform must be symmetrical. In other words, casting UDT > base type > UDT must yield the exact same UDT.
The above requirements should be best practice when using structured UDT in general. They are required for proper CDM replication of structured UDT.