The transfer command allows you to transfer data incrementally, and, if required, to a different product. In versions of Adaptive Server earlier than 15.5, you could transfer only whole tables from one Adaptive Server to another.
Adaptive
Server enables the data transfer feature when you purchase, install,
and register the in-memory database license, or when you install
the RAP product.
Incremental data transfer:
Lets you export data, including only the data that has changed since a prior transmittal, from Adaptive Server tables that are marked for incremental transfer.
Allows table data to be read without obtaining the usual locks, without guaranteeing any row retrieval order, and without interfering with other ongoing reads or updates.
Lets you write selected rows to an output file (which can be a named pipe) formatted for a defined receiver: IQ (Sybase IQ), ASE (Adaptive Server Enterprise), bulk-copy (bcp) file, or character-coded output. All selected rows are transmitted without encryption, and, by default, any encrypted columns within the row are decrypted before transmittal. The file to which you are writing must be visible to the machine on which Adaptive Server is running (the file can be an NFS file that Adaptive Server can open as a local file).
Maintains a history of transmittals for eligible tables, and lets you remove transmittal history when it is no longer wanted.
Exports data from tables not declared eligible for incremental transfer, subject to certain restrictions.
Transfers entire rows from indicated tables. You cannot currently select certain columns, select a partition within a table, or transfer results from SQL queries.
