To improve performance of bulk data transfers between data sources, Sybase now has a bulk copy transfer called “express transfer,” which transfers data faster than bulk copy transfer by using ODBC array-processing APIs. Because the new express transfer feature uses the same syntax as the DirectConnect bulk copy transfer, you can use express transfer without modifying your applications.
This new feature is available on all UNIX and Microsoft Windows platforms for the following DirectConnect products:
ECDA option for DB2 UDB
ECDA option for Informix
ECDA option for Microsoft SQL Server
ECDA option for ODBC
To use express transfer, you need one of these products and an ODBC driver from another DirectConnect or ASE product. For example, to transfer data between Microsoft SQL Server and ASE, you need DirectConnect for Microsoft SQL Server and an ASE ODBC driver.
For additional information, refer to Chapter 7, “Understanding the Transfer Process” and Chapter 8 “Using Bulk Copy Transfer and Express Transfer,” of the ECDA Options User’s Guide for Access Services.
Copyright © 2005. Sybase Inc. All rights reserved. |