Exporting data

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. See Rebuilding databases.

Export limitations

When exporting data from a SQL Anywhere database to an Excel database with the Microsoft Excel ODBC driver, the following data type changes can occur:

When you export data that is stored as CHAR, LONG VARCHAR, NCHAR, NVARCHAR or LONG NVARCHAR data type, the data is stored as VARCHAR (the closest type supported by the Excel driver).

Note that the Microsoft Excel ODBC driver supports text column widths up to 255 characters.
Data stored as MONEY and SMALLMONEY data types is exported to the CURRENCY data type. Otherwise numerical data is exported as numbers.

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 dbunload utility
Export data with the Unload Database Wizard
Export data with the Unload Data window
Export query results
Use the OUTPUT statement to output NULLs
Export databases
Export tables

Discuss this page in DocCommentXchange.

Exporting data

Export limitations

See also