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 » Exporting data

 

Export data with the Unload Database Wizard

Use the Unload Database Wizard to unload an existing database into a new database.

When using the Unload Database 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 the Unload Database 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. Choose Tools » SQL Anywhere 11 » Unload Database.

  2. Follow the instructions in the Unload Database Wizard.