Create a Database

Previous  Index  Next  How To Use

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

 

The Create New Database Wizard - page 2 - login and primary datafile info

 

It displays the following things:

 

Server

The server on which this database will be created.

Protocol

The protocol used to connect to this server and database.

Username

The username used to create the database. This user will become the database owner and the username used to connect to this database, by default, from Database Workbench.

Password

The password for the given user.

Alias

Display alias for the tree-view in the Enterprise Manager.

Primary database file

The primary datafile filename - this has to be a path LOCAL on the server.

Page size

The size, in bytes, of individual data-pages in the datafiles.

Primary file length

The maximum size of the primary datafile, in pages. The actual maximum size in Kb and Mb is calculated on the fly and displayed behind the edit box.

 

Note:

Modern versions of InterBase (6.5 and up) support 64 bit I/O and can have a virtually unlimited datafile size - check the Unlimited length check box in order to not specify a maximum file size. Make sure that your operating system supports this as well. Checking this box also skips the Additional Datafiles page from the wizard.

 

The Create New Database Wizard - page 3 - additional datafiles

 

The Addional database files page, skipped if you had the Unlimited length checkbox checked, lists secondary datafiles. The Start at page values are automatically calculated via the Length in pages values.

 

Note:

Secondary datafiles can be added to a database after creation as well via specialized DDL statements - see the InterBase documentation for more - or via a backup/restore cycle.

 

The Create Database Wizard - page 4 - additional settings

 

The "last" page in the wizard displays the database characterset to use and it's SQL dialect. For new projects, it's recommended you use dialect 3. Optionally, you can automatically connect to the database by leaving the Connect to database after creation box checked. The database will be automatically registered under the server in the Enterprise Manager.

 

You can use the Finish button to create the database, or use the Next button to go to registration-option pages.