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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Data import and export


Data export

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

  • export individual tables, query results, or table schema

  • create scripts that automate exporting so that you can export several 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

Before exporting data, determine what resources you have and the type of information you want to export from your database.

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

 Export limitations
 See also

Export data with the Export Wizard
Export data with the OUTPUT statement
Export data with the UNLOAD TABLE statement
Export data with the UNLOAD statement
Export data with the Unload utility (dbunload)
Export data with the Unload Database Wizard
Exporting data with the Unload Data window
Exporting query results
Using the OUTPUT statement to output NULLs
Exporting databases (Sybase Central)
Exporting databases (command line)
Exporting tables (SQL)
Exporting tables (command line)