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.

Exporting data

See also