To improve performance transferring bulk data between data sources, Sybase has a bulk copy transfer called “express transfer,” which uses ODBC bulk APIs to transfer data faster than bulk copy transfer. Express transfer uses the same syntax as bulk copy transfer; as a result, you do not need to modify your applications.
For example, to transfer data between Microsoft SQL Server and ASE requires an ODBC driver from Microsoft for the Microsoft SQL Server data source and the ASE ODBC Driver by Sybase.
To use this feature for Windows DB2 UDB, Microsoft SQL Server, or other ODBC-accessible data sources, 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
For more information about the ODBC drivers and driver managers, see the Enterprise Connect Data Access Installation Guide for your platform.
