|
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 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.
For more information about unloading and reloading complete databases, see Rebuilding databases.
Export considerations
Export tools
Unload tools
Exporting query results
Exporting databases
Exporting tables