Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Running the Database Server » Running authenticated SQL Anywhere applications » Developing an authenticated application

Executing the authentication statement Next Page

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 10

The 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'

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].