Upgrading authenticated databases

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 11 or later

The Upgrade utility (dbupgrad) cannot be used to upgrade version 9.0.2 and earlier databases to version 10 or later. To upgrade older databases to version 11 or later, 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].

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1