Use the dbunload utility 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 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.
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:
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
For more information about the dbunload utility, see Unload utility (dbunload).
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|