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.
Rebuilding databases not involved in synchronization or replication
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |