Use the Create Database wizard to create a new Adaptive Server Enterprise database. You can use this database to develop applications in Sybase WorkSpace.
To create a development-level Adaptive Server Enterprise 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 Enterprise documentation.
To create an Adaptive Server Enterprise database:
In the Database Development perspective, open Enterprise Explorer and right-click an Adaptive Server Enterprise connection profile to connect to the database.
The user name in the connection profile must be the System Administrator or another user with create database privileges.
Do one of the following to open the Create Database wizard:
Open the Enterprise Explorer view, right-click an Adaptive Server Enterprise connection profile, and select Create Database from the context menu.
Select File|New|Create Database from the menu bar.
For more ways to access the Create Database wizard, see Wizards.
Use the following information to complete the Create Database page.
Create Database page
| Field | Description |
|---|---|
| Database Name | Enter a name for the database file. Do not include spaces in the database name. You cannot debug objects in an Adaptive Server Enterprise database whose name includes a space. |
| Database connection profile type | Choose Sybase ASE. |
| Database connection profile name | Select an existing profile from the drop-down list, or click Create to create a new one. |
Click Finish to create the database.
Review the create database operation and status in SQL Results.
If the operation succeeded, a new Adaptive Server Enterprise database is created automatically. Disconnect and reconnect to see the new database under the original connection profile in Database Explorer and Enterprise Explorer.
Setting ASE Create Database Preferences
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com