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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data » Rebuilding databases

 

Rebuild databases not involved in synchronization or replication

The following procedures should be used only if your database is not involved in synchronization or replication.

To rebuild a database not involved in synchronization or replication (Command line)
  1. Run the dbunload utility, specifying one of the following options:

    To do this... Use this option... Example
    Rebuild to a new database -an
    dbunload -c 
    "DBF=demo.db;UID=DBA;PWD=sql" 
       -an DemoBackup.db
    Reload to an existing database -ac
    dbunload -c 
    "DBF=demo.db;UID=DBA;PWD=sql" 
       -ac "UID=DBA;PWD=sql;DBF=NewDemo.db"
    Replace an existing database -ar
    dbunload -c 
    "DBF=demo.db;UID=DBA;PWD=sql" 
       -ar

    If you use one of these options, no interim copy of the data is created on disk, so you do not need to specify an unload directory on the command line. This provides greater security for your data. The -ar and -an options should also execute more quickly than the Unload Database Wizard in Sybase Central, but -ac is slower than the Unload Database Wizard.

  2. Shut down the database and archive the transaction log before using the reloaded database.

Notes

The -an and -ar options only apply to connections to a personal server, or connections to a network server over shared memory.

There are additional options available for the dbunload utility that allow you to tune the unload and connection parameter options that allow you to specify a running or non-running database and database parameters.