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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere database servers » Authenticated SQL Anywhere applications » Authenticated application development


Upgrading authenticated databases

You can upgrade an authenticated database by creating the authenticate.sql file in the %SQLANY16%/scripts directory before upgrading or rebuilding the database. The file is run by the CREATE DATABASE and ALTER DATABASE UPGRADE statements, dbupgrad and dbunload utilities, and the Upgrade Database Wizard.


To set PUBLIC options, you must have the SET ANY PUBLIC OPTION system privilege

It is recommended that you make backup copies of your database files.

Context and remarks

The only way to preserve authentication information when upgrading or rebuilding a database is to store the authentication statement in the file authenticate.sql.

  1. Create a file named authenticate.sql in the %SQLANY16%\scripts directory.

  2. Add the following contents to the file:

    SET OPTION PUBLIC.database_authentication = 'authentication-statement'

    The go must appear in the file; otherwise, the statement is ignored.


The database is upgraded.


Upgrade or rebuild the database. The steps you must follow depend on the version of the database file you are upgrading or rebuilding.

 See also