Export data with the Unload utility (dbunload)

Use the Unload utility (dbunload) to export one, many, or all the database tables. You can export table data, and table schemas. To rearrange your database tables, you can also use dbunload to create the necessary SQL script files and modify them as needed. These files can be used to create identical tables in different databases. You can unload tables with structure only, data only, or with both structure and data. You can also unload directly into an existing database using the -ac option.

Use dbunload when you:

need to rebuild or extract your database
want to export data in text format
need to process large amounts of data quickly
have flexible file format requirements

Note

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

Export data with the Unload utility (dbunload)

Note

See also