If the database you want to unload is already running, and you start the Unload Database Wizard, the SQL Anywhere 12 plug-in automatically stops the database before you can unload it.
Choose Tools » SQL Anywhere 12 » Unload Database.
Follow the instructions in the Unload Database Wizard.
Run the dbunload utility, and use the -c option to specify the connection parameters.
To unload the entire database to the directory c:\DataFiles on the server computer:
dbunload -c "DBN=demo;UID=DBA;PWD=sql" c:\DataFiles |
The statements required to recreate the schema and reload the tables are written to reload.sql in the local current directory.
To export data only, use -d. For example:
dbunload -c "DBN=demo;UID=DBA;PWD=sql" -d c:\DataFiles |
The statements required to reload the tables are written to reload.sql in the local current directory.
To export schema only, use -n. For example:
dbunload -c "DBN=demo;UID=DBA;PWD=sql" -n |
The statements required to recreate the schema are written to reload.sql in the local current directory.
For more information, see Unload utility (dbunload).
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |