Upgrading authenticated databases
 Upgrade or rebuild an authenticated database

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

The CREATE DATABASE and ALTER DATABASE UPGRADE statements, dbupgrad and dbunload utilities, and the Upgrade Database Wizard check for the existence of a file named authenticate.sql in the %SQLANY12%/scripts directory and run its contents if it exists. You must create this file before running the upgrade or rebuild on the database.

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

  2. Add the following contents to the file:

    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.

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