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


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.


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.

  • 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.


The data is unloaded to the specified location.

 See also