ASA SQL User's Guide
  Importing and Exporting Data
    Exporting

Exporting databases

To unload all or part of a database (Sybase Central)

1. In the left pane, select the Adaptive Server Anywhere 9 plug-in.

2. In the right pane, click the Utilities tab.

   All of the operations you can perform on a database appear in the right pane.

3. Double-click Unload Database in the right pane.

   The Unload Database wizard appears.

   You can also open the Unload Database wizard by right-clicking the database in the left pane, and choosing Unload Database from the popup menu, or by choosing the Tools > Adaptive Server Anywhere 9 > Unload Database command.

4. Follow the instructions in the wizard.

To unload all or part of a database (command line)

1. At a command prompt, enter the dbunload command and specify connection parameters using the -c option.

   For example, the following command unloads the entire database to c:\temp:

   dbunload -c "dbn=asademo;uid=DBA;pwd=SQL" c:\temp

2. If you want to export data only, add the -d option.

   For example, if you want to export data only, your final command would look like this:

   dbunload -c "dbn=asademo;uid=DBA;pwd=SQL" -d c:\temp

3. If you want to export schema only, add the -n option instead.

   For example, if you want to export schema only, your final command would look like this:

   dbunload -c "dbn=asademo;uid=DBA;pwd=SQL" -n c:\temp

4. Press Enter to execute the command.

For more information about additional command line options you can apply to the dbunload utility, see Unloading a database using the dbunload command-line utility.