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

Note

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