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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Exporting data from databases » Export tools

Using the UNLOAD statement Next Page

Using the dbunload utility to export data


The dbunload utility lets you export one, many, or all of the tables in the database. You can export table data, as well as table schemas. If you want to rearrange your tables in the database, you can also use the dbunload utility to create the necessary command files and modify them as needed. You can unload tables with structure only, data only, or with both structure and data.

You can also extract one or many tables with or without command files. These files can be used to create identical tables in different databases.

Note

The dbunload utility is functionally equivalent to the Sybase Central Unload Database wizard. You can use either one interchangeably to produce the same results.

Use the dbunload utility when you:

For more information about the dbunload utility, see Unload utility (dbunload).