Contents Index Saving, loading, and running command files Accessing Remote Data

ASA SQL User's Guide
  Importing and Exporting Data

Adaptive Server Enterprise compatibility


You can import and export files between Adaptive Server Anywhere and Adaptive Server Enterprise using the BCP FORMAT clause. Simply make sure the BCP output is in delimited ASCII format. If you are exporting BLOB data from Adaptive Server Anywhere for use in Adaptive Server Enterprise, use the BCP format clause with the UNLOAD TABLE statement.

For more information about BCP and the FORMAT clause, see LOAD TABLE statement or UNLOAD TABLE statement.


Contents Index Saving, loading, and running command files Accessing Remote Data