You can distribute MS SQL Server columns that contain large objects to MS SQL Server and Oracle targets. The individual datatype mappings allowed by the Connect CDC Director are displayed in the table in Character and long character categories and in the table in Decimal numeric category .
Replication support for MS SQL Server long columns is limited to those methods of updating long data that allow Connect CDC insert, delete, and update triggers to fire on the user table. Consequently, long columns updated by the following methods may not be replicated:
-
WRITETEXT and UPDATETEXT SQL statements
-
DB-Library applications using dbwritetext and dbupdatetext function calls