Using the dbunload utility to rebuild databases

The dbunload and dbisql utilities let you unload an entire database in text comma-delimited format and create the necessary Interactive SQL command files to completely recreate your database. This may be useful for creating SQL Remote extractions or building new copies of your database with the same or a slightly modified structure. This utility is useful for exporting SQL Anywhere files intended for reuse within SQL Anywhere.

Note

The dbunload utility and the Unload Database Wizard are functionally equivalent. You can use them interchangeably to produce the same results.

Use the dbunload utility when you:

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

For more information, see: