Contents Index Using passthrough mode Using SQL Remote with Replication Server

SQL Remote User's Guide
  Administering SQL Remote for Adaptive Server Enterprise
    Using passthrough mode

Schema modifications


The Adaptive Server Enterprise log transfer interface does not contain information about the number of columns and data types of the columns in a table. SSREMOTE gets this information directly from the Adaptive Server Enterprise system tables. For this reason, altering a table and then scanning operations that happened before the ALTER TABLE will lead to errors. SSREMOTE must set the "truncation point" beyond all operations on replicated tables before schema changes can be made. Operations on replicated tables need to be prevented between SSREMOTE running and the schema changes being made.


Contents Index Using passthrough mode Using SQL Remote with Replication Server