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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Data import and export » Database rebuilds


Using the Unload utility to rebuild databases

You can use the Unload utility (dbunload) to unload an entire database into a text comma-delimited format and create the necessary SQL script files to completely recreate your database. For example, you can use these files to create SQL Remote extractions or build new copies of your database with the same or a slightly modified structure.

Use the Unload utility (dbunload) 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


The Unload utility (dbunload) and the Unload Database Wizard are functionally equivalent. You can use them interchangeably to produce the same results. You can also unload a database using the Interactive SQL OUTPUT statement or the SQL UNLOAD statement.

 See also

Rebuilding databases not involved in synchronization or replication