ASA SQL User's Guide
  Working with Database Objects
    Working with databases

Installing the jConnect metadata support to an existing database

If a database was created without the jConnect metadata support, you can use Sybase Central to install it at a later date.

To add jConnect metadata support to an existing database (Sybase Central)

1. Connect to the database you want to upgrade.

2. In the left pane, select the Adaptive Server Anywhere 9 plug-in.

3. In the right pane, click the Utilities tab.

4. In the right pane, double-click Upgrade Database.

5. Click Next on the introductory page of the wizard.

6. Select the database you want to upgrade from the list. Click Next.

7. You can choose to create a backup of the database if you wish. Click Next.

8. Select the Install jConnect Meta-Information Support option.

9. Follow the remaining instructions in the wizard.