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:



The server on which this database will be created.


The protocol used to connect to this server and database.


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.


The password for the given user.


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.



Firebird versions (and operating system versions) that support 64 bit I/O and can have a virtually unlimited datafile size - check the Unlimited length checkbox in order to not specify a maximum filesize. Checking this box also skips the Additional Datafiles page from the wizard.


The Create New Database Wizard - page 3 - additional datafiles


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



Secondary datafiles can be added to a database after creation as well via specialized DDL statements - see the Firebird 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.