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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Running the database server » Running authenticated SQL Anywhere applications » Developing an authenticated application


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'

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