|
The only way to preserve authentication information when upgrading or rebuilding a database is to store the authentication statement in the file authenticate.sql.
Upgrade utility unsupported for upgrading to version 10The Upgrade utility (dbupgrad) cannot be used to upgrade version 9.0.2 and earlier databases to version 10. To upgrade older databases to version 10, you must rebuild the database by performing an unload and reload. See Upgrading SQL Anywhere. |
Create a file named authenticate.sql in the install-dir\scripts directory, with the following contents:
SET OPTION PUBLIC.database_authentication = 'authentication-statement' go
The go must appear in the file; otherwise, the statement is ignored.
For information about the content of the authentication-statement string, see database_authentication [database].