Chapter 4 Database Administration Utilities
139
Unloading a database from Sybase Central
v To unload a database file or a running database:
1 Connect to the database.
2 Display the Unload an Adaptive Server Anywhere Database wizard,
either by:
♦ Right-clicking the database and then clicking Unload in the popup
menu, or by
♦ Opening the Utilities folder in the left panel, and Double-clicking
Unload Database in the right panel.
3 Follow the instructions in the wizard.
Tip
You can also access this wizard by clicking Tools➤Adaptive Server
Anywhere➤Unload Database.
$ For full information on unloading a database from Sybase Central, see
"Exporting a database" on page 721 of the book ASA User’s Guide.
The dbunload command-line utility
dbunload [
switches
] [
directory
]
Switch Description
–ac "keyword=value; ..." Supply connection parameters for the reload
–an database Creates a database file with the same settings as the
database being unloaded, and automatically reloads
it
–ar directory Rebuild and replace database
–c "keyword=value; ..." Supply database connection parameters for unload
–d
Unload data only
–e table,... Do not unload listed tables
–ii
Internal unload, internal reload (default)
–ix
Internal unload, external reload
–j nnn Repeated unload of view creation statements
–n
No data—schema definition only
Syntax
To Next Page
Loading...