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.