Adaptive Server Enterprise uses a text pointer to identify the location of text and image column data. The text pointer is passed to system functions that perform the actual updates to data in these large columns. The same technique is used internally in Replication Server to apply LOB datatypes. Replication Server obtains a text pointer, and data server function calls are made to apply the data to replicate databases.
When a non-Sybase database is the replicate database, the database gateway used to communicate with the replicate database must be able to emulate the Adaptive Server text pointer processing. The ECDA Option for ODBC, ECDA Option for Oracle, ExpressConnect for Oracle, and the Mainframe Connect™ DirectConnect for z/OS Option gateways provide this feature.
The ECDA Option for ODBC provides support for LOB replication into Microsoft SQL Server databases. See Chapter 9, “Microsoft SQL Server Replicate Data Server Issues.”
