Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data


Exporting data

Exporting data is an administrative task that involves writing data out of your database. Exporting is a useful tool if you need to share large portions of your database, or extract portions of your database according to particular criteria. SQL Anywhere lets you:

  • export individual tables, query results, or table schema
  • create scripts that automate exporting so that you can export a number of tables consecutively
  • export to many different file formats
  • export data to a file on a client computer
  • export files between SQL Anywhere and Adaptive Server Enterprise using the BCP FORMAT clause

For performance reasons, if you want to export an entire database, unload the database instead of exporting the data. See Rebuilding databases.

See also

Export considerations
Export tools
Exporting query results
Exporting databases
Exporting tables