Transfer the data from the primary to the secondary database, or from the secondary to
the primary.
- A
transfer to statement transfers data from the primary
database to the secondary database. The primary database becomes the source
database to the secondary database, which is the target.
- A
transfer from statement transfers data from the secondary
database to the primary database. The secondary database becomes the source
database to the primary database, which is the target.
When you
execute a bulk-copy transfer from statement, the secondary database
(either Adaptive Server database or another database) is the source of the data to be
transferred. The primary database becomes the destination database, or target.
Note:
Sybase recommends that you use the transfer from command from the
primary database when you transfer data between two access services. Using
transfer from guarantees native datatype mapping and returns
the proper datatype result set.