Express transfer uses the same syntax as bulk-copy transfer; as a result, you do not need
to modify your applications.
To improve performance transferring bulk data between datasources, Sybase has a bulk-copy
transfer called “express transfer,” which uses ODBC bulk APIs to transfer data faster
than bulk-copy transfer.
Example: To transfer data between Microsoft SQL Server and Adaptive Server requires an ODBC driver from Microsoft for the Microsoft SQL Server datasource and the Adaptive Server ODBC driver by Sybase.
To use this feature for Windows DB2 UDB, Microsoft SQL Server, or other
ODBC-accessible datasources, you need to obtain a back-end ODBC driver. As of
version 15.0, Sybase no longer provides back-end (server-side) drivers for them.
However, Sybase does support these drivers:
-
IBM DB2 CLI ODBC Driver for DB2 databases
-
Data Direct Driver for DB2 and Microsoft SQL Server databases
-
Microsoft driver for SQL Server databases, which you can download at no
cost
See the Enterprise
Connect Data Access Installation Guide for your platform for information
about the ODBC drivers and driver managers.