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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Exporting data from databases

Outputting NULLs using the OUTPUT statement Next Page

Exporting databases


Note

If the database you want to unload is already running, and you start the Unload Database wizard, the SQL Anywhere plug-in automatically stops the database before you can unload it.

To unload all or part of a database (Sybase Central)
  1. From the Tools menu, choose SQL Anywhere 10 > Unload Database.

    The Unload Database wizard appears.

  2. Follow the instructions in the wizard.

  3. 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 the directory c:\DataFiles on the server computer:

      dbunload -c "DBN=demo;UID=DBA;PWD=sql" c:\DataFiles

      The statements required to recreate the schema and reload the tables are written to reload.sql in the local current directory.

    2. Do either of the following:

      • To export data only, use -d. For example:

        dbunload -c "DBN=demo;UID=DBA;PWD=sql" -d c:\DataFiles

        The statements required to reload the tables are written to reload.sql in the local current directory.

      • To export schema only, use -n. For example:

        dbunload -c "DBN=demo;UID=DBA;PWD=sql" -n

        The statements required to recreate the schema are written to reload.sql in the local current directory.

    3. For more information, see Unload utility (dbunload).