Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » Data export » Tips on exporting data with the Unload Database Wizard

 

Unloading a database file or running database

You can unload a stopped or running database in Sybase Central using the Unload Database Wizard.

Prerequisites

When unloading into a variable, no privileges are required. Otherwise, the required privileges depend on the database server -gl option, as follows:

  • If the -gl option is set to ALL, you must be the owner of the tables, or have SELECT privilege on the tables, or have the SELECT ANY TABLE system privilege.

  • If the -gl option is set to DBA, you must have the SELECT ANY TABLE system privilege.

  • If the -gl option is set to NONE, UNLOAD is not permitted.

When unloading to a file on a client computer:

  • You must have the WRITE CLIENT FILE privilege.

  • You must have write permissions on the directory where the file is located.

  • The allow_write_client_file database option must be enabled.

  • The write_client_file secure feature must be enabled.

Context and remarks

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.

 Task

  1. Click Tools » SQL Anywhere 16 » Unload Database.

  2. Follow the instructions in the Unload Database Wizard.

Results

The specified database is unloaded.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0