With Adaptive Server 15.5, you can transfer data incrementally from a table instead of having to transfer the whole table from one Adaptive Server to another. See Chapter 8, “Adding, Changing, Transferring, and Deleting Data,” in the Adaptive Server Enterprise Transact-SQL Users Guide.
Replication Server supports the data definition language related to the Adaptive Server 15.5 incremental data transfer feature. Replication proceeds normally for data modification operations performed on a replicate table marked for incremental transfer.
If you load a replicate table with the transfer table command, and the table has an unique index command and the data on the incremental transfer already exists on the table, Adaptive Server internally converts an insert command into an update command.
The transfer table command applies only to the data server and database where you initiated the transfer the first time.
If you mark tables for incremental transfer in the active database within a warm standby or MSA environment, and then switch to the standby database if the active database terminates, incremental data transfer may not resume correctly at the standby database. This is because, unlike the active database, the standby database does not have a record of the incremental data transfer activity. Therefore, you must initialize the incremental data transfer on the standby database too.
See Chapter 8, “Adding, Changing, Transferring, and Deleting Data,” in the Adaptive Server Enterprise Transact-SQL Users Guide.
