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

You can also use the Unload Database Wizard to unload an entire database in text comma-delimited format and to create the necessary SQL script 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.

Note

The Unload utility (dbunload) is functionally equivalent to the Unload Database Wizard. You can use either one interchangeably to produce the same results.

 See also

Unloading a database file or running database