Bulk-Copy and Express Transfer Conditions

The conditions that allows you to determine type of transfer you want to select.

When to Use Bulk-Copy and Express Transfers
Bulk-Copy Transfer	Express Transfer
When the source or destination database is Adaptive Server and does not use an Adaptive Server ODBC driver.	When you use ODBC drivers for both the source and destination database.
To exercise more control over transfer.	To execute the transfer quickly.
When you require diverse datatype conversions.	When you do not require any datatype conversions.

Limitations for Bulk-Copy and Express Transfers

The transfer statement must be the only statement in a request.
The table (the target) into which you want to transfer data must already exist because the transfer statement does not create new tables.
The structure of the target table must match the structure of the source table.
For bulk-copy and express transfer to work, the secondaryname to the secondary database must be recorded in these files:
- For bulk-copy transfer, the Windows sql.ini file or the UNIX interfaces file.
- For express transfer, the secondaryname must match a datasource name (DSN) in the odbc.ini file.
Unicode datatypes are not supported.
The first 32K of long character and long binary values are supported. Transfer processing truncates longer values without any warning.