The transfer command allows you to transfer data incrementally, and, if required, to a different product.
Incremental data transfer:
Lets you export data, including only the data that has changed since a prior transmittal, from SAP ASE 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: SAP® IQ®, SAP ASE,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 SAP ASE is running (the file can be an NFS file that SAP ASE 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.