Exporting databases (command line)

You can unload data from a database to a reload file, a new database, or an existing database using the Unload utility (dbunload) on the command line.

Prérequis

For an unload without a reload, you must have the SELECT ANY TABLE system privilege. For an unload with reload, you must have the SELECT ANY TABLE and SERVER OPERATOR system privileges.

Task

Run the Unload utility (dbunload), and use the -c option to specify the connection parameters.

Option

Action

Unload the entire database

To unload the entire database to the directory C:\ServerTemp\DataFiles on the server computer:

dbunload -c "DBN=demo;UID=DBA;PWD=sql" C:\ServerTemp\DataFiles

Export data only

Use the -d and -ss options. For example:

dbunload -c "DBN=demo;UID=DBA;PWD=sql" -d -ss C:\ServerTemp\DataFiles

Export schema only

Use the -n option. For example:

dbunload -c "DBN=demo;UID=DBA;PWD=sql" -n

The statements required to recreate the schema and/or reload the tables are written to reload.sql in the client's current directory.

Résultat

The data is unloaded to the specified location.

Exporting databases (command line)

Task

See also