Using the Unload Database Wizard

You can use the 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 Configure Owner Filter window 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 Configure Owner Filter, and then select the user in the resulting window.

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 text 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 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 11 » Unload Database.

  2. Follow the instructions in the Unload Database Wizard.

Tip

You can use any of the following methods to access the Unload Database Wizard from within Sybase Central:

  • Select the database, and choose File » Unload Database.
  • Right-click the database, and choose Unload Database.
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0