Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Exporting table data or table schema

The Unload utility has options that allow you to unload only table data or the table schema.

The dbunload commands in these examples unload the data or schema from the SQL Anywhere sample database table (assumed to be running on the default database server with the default database name) into a file in the c:\DataFiles directory on the server computer. The statements required to recreate the schema and reload the specified tables are written to reload.sql in the local current directory.

To export table data (Command line)

• At a command prompt, enter the dbunload command and specify connection parameters using the -c option, specify the table(s) you want to export data for using the -t option, and specify that you want to unload only data by specifying the -d option.

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

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

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

To export table schema (Command line)

• At a command prompt, enter the dbunload command and specify connection parameters using the -c option, specify the table(s) you want to export data for using the -t option, and specify that you want to unload only the schema by specifying the -n option..

  For example, to export the schema for the Employees table, execute the following command:

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

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