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 » Unload tools

Unload tools Next Page

Using the Unload Database wizard

You can use the Sybase Central Unload Database wizard to unload an existing database into a new database.

When using this wizard to unload your database, you can choose to unload all the objects in a database, or a subset of tables from the database. Only tables for users selected in the Filter Objects by Owner dialog appear in the Unload Database wizard. If you want to view tables belonging to a particular database user, right-click the database you are unloading, choose Filter Objects by Owner from the popup menu, and then select the desired user in the resulting dialog.

Note

When you unload only tables, the user IDs that own the tables are not unloaded. You must create the user IDs that own the tables in the new database before reloading the tables.

You can also use this wizard to unload an entire database in ASCII comma-delimited format and to create the necessary Interactive SQL command files to completely recreate your database. This is useful for creating SQL Remote extractions or building new copies of your database with the same or a slightly modified structure. The Unload Database wizard is useful for exporting SQL Anywhere files intended for reuse within SQL Anywhere.

The Unload Database wizard also gives you the option to reload into an existing database or a new database, rather than into a reload file.

The dbunload utility is functionally equivalent to the Sybase Central Unload Database wizard. You can use either one interchangeably to produce the same results.

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.

For information about special considerations when unloading a database, see Unload utility (dbunload).

To unload a database file or a running 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. Tip

    You can also access the Unload Database wizard from within Sybase Central using any of the following methods:

    • Selecting a database, and choosing Unload Database from the File menu.

    • Right-clicking a database, and choosing Unload Database from the popup menu.