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 » Database rebuilds


Exporting table data

The Unload utility allows you to unload only table data.


You must be the owner of the table being queried, or have SELECT privilege on the table, or have the SELECT ANY TABLE system privilege.

Context and remarks

The statements required to recreate the schema and reload the specified tables are written to reload.sql in the current local directory.

You can unload more than one table by separating the table names with a comma.

  • Run the dbunload command, specifying connection parameters using the -c option, table(s) you want to export data for using the -t option, whether you want to suppress column statistics by specifying the -ss option, and whether you want to unload only data by specifying the -d option.

    For example, to export the data from the Employees table, run the following command:

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

    The reload.sql file will be written to the client's current directory and will contain the LOAD TABLE statement required to reload the data for the Employees table. The data files are written to the server directory C:\ServerTemp\DataFiles.


The table data is exported to the specified directory.

 See also