Transfer Process

The transfer process allows you to transfer rows and columns of data between tables in multiple databases from a client application.

Based on your needs and limitations, you can select from one of three transfer options: bulk copy, express, and destination-template.

• Access Service Data Transfer Between Databases
  The access service configured to access a particular primary database.The secondary database is an Adaptive Server database located on the LAN. The client application can transfer data from the primary database to Adaptive Server, or from Adaptive Server to the primary database.
• Transfer Direction
  Transfer the data from the primary to the secondary database, or from the secondary to the primary.
• Transfer Process – Unit of Work
  A unit of work is one or more requests that execute, commit, or roll back as a group.
• Transfer Targets
  The transfer statement allows you to move data in either direction between the primary database and supported databases.
• Datatype Conversion for Transfer Processing
  Datatype conversion is handled differently by the access service for the different transfer types.
• Transfer Options for Processing Data
  Bulk-copy transfer and express transfer allow you to quickly and directly transfer large amounts of compatible data between databases.
• Transfer Error Types and Error Handling
  Transfer processing errors are classified as structural errors and values errors.
• Transfer Processing Error Reporting
  Obtain error information about bulk-copy and destination-template transfer processing.
• Control Processing with the TransferErrorCount Property
  During bulk-copy and destination-template transfer processing, the access service automatically sets the StopCondition property to none.