Creating an ASA Database

Use the Create Database wizard to create a new Adaptive Server Anywhere database. You can use this database to develop applications in Sybase WorkSpace.

To create a development-level Adaptive Server Anywhere database based on your Create Database preference settings, follow this procedure.

To create a production database using options other than the ones described here and in the Create Database preferences page, see your Adaptive Server Anywhere documentation.

To create an Adaptive Server Anywhere database:

  1. In the Database Development perspective, open Enterprise Explorer. If you are not already connected, right-click an Adaptive Server Anywhere connection profile to connect to the database.

    Note

    The user name in the connection profile must have DBA authority.

  2. Do one of the following to open the Create Database wizard:

    • Open the Enterprise Explorer view, right-click a Sybase ASA connection profile, and select Create Database from the context menu.

    • Select File|New|Create Database from the menu bar.

      Note

      For more ways to access the Create Database wizard, see Wizards.

  3. Use the following information to complete the Create Database page.

    Create Database page

    FieldDescription
    Database Name

    Enter a name for the database file. The same name is used for the ASA log file.

    Database connection profile type

    Choose Sybase ASA.

    Database connection profile name

    Select an existing profile from the drop-down list, or click Create to create a new one.

  4. Click Finish to create the database.

  5. Review the create database operation and status in SQL Results.

If the operation succeeded, a new Sybase ASA connection profile is created automatically with the same name as the new database name. The new database starts automatically, and:

Creating a Simple Database

Setting ASA Create Database Preferences

Creating an ASA Connection Profile

Viewing SQL Results

Connecting to a Server

Connecting to a Database

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com