Create a Database

Previous  Top  Next

After the Welcome page of the wizard, the following page is shown:

 

The Create New Database Wizard - page 2

 

It displays the following things:

 

Server

The server on which this database will be created.

Main database file

The main database file that automatically includes a database space "SYSTEM".

Transaction log file

The file that holds transaction information, check the box to enable the edit box.

Mirror log file

An additional log file, check the box to enable the edit box.

Page size

The size in bytes of each database page.

Pre-allocate space

This allows you to create an empty database files of the specified size instead of letting the file grow while it's filling with data.

 

You can use the Finish button to create the database or click Next for more options.

 

The Create New Database Wizard - page 3

 

Check the Sybase Anywhere documentation for more information on these options.

 

The Create New Database Wizard - page 4

 

Enter the DBA-user name and password or leave the defaults.

 

The Create New Database Wizard - page 5

 

A database needs to be started at a server before it can be used. Database Workbench can do this for you and you can enter a running database name. Additionally, you can connect to the database after creating it.