When you upgrade to EAServer 6.0.2, Adaptive Server™ Anywhere (ASA) version 9.0.2 is upgraded to version 10.0, and the name of the database server changes from ASA to SQL Anywhere®. The EAServer 6.0.2 upgrade script installs a new database (default.db) that is used by the server.
SQL Anywhere 10.0 does not work with an ASA 9.x database. To continue using the data in an ASA 9.x database, run the asa-unload script to move the data into the SQL Anywhere 10.0 database.
Moving data from an ASA 9.0.2 database to a SQL
Anywhere 10.0 database
First, upgrade EAServer to version 6.0.2, then move the data to the new database.
In a command window, change to the EAServer bin subdirectory and run:
asa-unload.bat [options] <directory>@<data>
The asa-unload script calls dbunload [options] <directory>@<data>, where:
options are any of the options listed in Table 1.
data is either an environment variable or a file from which the data is expanded.
directory is the path to data. The path must be available to the database server, unless you use an external unload.
See “Sample upgrade”.
Option |
Description |
|---|---|
-ac “keyword=value;...” |
Connection parameters for the ASA 9.x database |
-an <db_file> |
Create a database file with the same settings as the old database file, and move the data into the new database. |
-ap <size> |
Set the page size of the new database |
-ar |
Rebuild and replace the database |
-c “keyword=value;...” |
Database connection parameters |
-d |
Unload data only |
-dc |
Recompute columns |
-e <list> |
Do not display output for the listed tables |
-ea <algorithm> |
Encryption algorithm for the new database; used with -ek or -ep |
-ek <key> |
Encryption key for the new database; used with -an or -ar |
-ep |
Prompt for the new database encryption key; used with -an or -ar |
-er |
Remove encryption from encrypted tables |
-et |
Enable encrypted tables in new database; used with -an or -ar |
-g |
Generate statements to refresh valid materialized views |
-ii |
Internal unload, internal reload (the default) |
-ix |
Internal unload, external reload |
-k |
Create an auxiliary catalog; used with diagnostic tracing |
-m |
Do not preserve user IDs for a replicating database |
-n |
No data; schema definition only |
-nl |
No data; include LOAD/INPUT statements in reload script |
-o <file> |
Logs output messages to file |
-p <char> |
Escape character; the default is “\” |
-q |
Suppress display of messages and windows |
-r <file> |
Name of the generated reload ISQL command file; the default is reload.sql |
-t <list> |
Output the listed tables only |
-u |
Data can be unordered |
-v |
Verbose messages |
-xi |
External unload, internal reload |
-xx |
External unload, external reload |
-y |
Replace existing command file without asking for confirmation |
You can find complete upgrade instructions in Upgrading to SQL Anywhere 10.
For an overview of SQL Anywhere 10 features, see What’s New in Version 10.0.0.
This example calls asa-unload to
move data from an ASA 9.x database to a SQL
Anywhere 10.0 database:
asa-unload -c "dbf=..\data\default.db;uid=dba;pwd=sql" -ar -o ..\data\dbunload.txt
where:
-c “dbf=..\data\default.db;uid=dba;pwd=sql” specifies
the database connection parameters: path and name of the 9.x database
file, user ID, and password.
-ar replaces
and rebuilds the database.
-o ..\data\dbunload.txt specifies
the name and location of the output log file.
As the data is moved, the console displays:
SQL Anywhere Unload Utility Version 10.0.0.2745 Connecting and initializing Unloading user and group definitions Unloading table definitions Unloading index definitions Unloading functions Unloading view definitions Unloading procedures Unloading triggers Unloading SQL Remote definitions Unloading MobiLink definitions Creating new database Creating indexes
