Install InterBase and Create a New Database

Products | Solutions | Support | Download | Order

Knowledge Base

Install InterBase and Create a New Database - December 22, 2000

The following text only applies to Biblioscape before version 5.

InterBase, well known for its low-maintenance, enterprise-class relational database management system (RDMS), offers a powerful, reliable, easy-to-use solution for Biblioscape customers who needs Client/Server setup. Best of all, InterBase is the first commercial quality SQL database to become open source and it is completely free. The following tutorial shows you how to setup InterBase and create a new empty database. You can then convert your existing Biblioscape database in Paradox into InterBase with the DataPump utility.

1. Click here to download the latest release of InterBase at Borland Web site for free.

2. Unzip the downloaded file into an empty directory and run the setup.exe to install InterBase.

3. Once it is installed, click Windows status bar "Start | Programs | InterBase | IBConsole" to start InterBase console manager. First, you need to register the server. By default, you can login to the server as system administrator "SYSDBA" with password "masterkey". To register the local server, click menu command "Server | Register...". Select "Local Server". Enter "SYSDBA" as the user name and "masterkey" as the password. Click OK button to register.

4. Once you registered local server, a Local Server icon will be shown on the left of the IBConsole. Next time when you start IBConsole, the local server icon will be shown, but you need to login to the server. Select the "Local Server" icon, then click right mouse button to show the popup menu. Click "Login" and enter the user name and password to login.

Once you registered the local server, you can change the default password for the "SYSDBA" account. To do that, click menu command "Server | User Security...". You can also create new user. In this tutorial, we assume you will keep using the default "SYSDBA" account.

5. Now, you need to create a new empty database. On the IBConsole Window, click menu command "Database | Create Database...". Enter an alias. For example "biblioscape4_ib". Enter the full path name of your InterBase database to be created. For example "d:\temp7\biblioscape4_ib.gdb". In the "Options" section, select "1" as the "SQL Dialect". This is very important, otherwise, your Biblioscape database in Paradox won't be converted into InterBase successively. Click OK button to create the database. Now, you have created an InterBase database without any table. You can then use the DataPump utility to convert your default Biblioscape database in Paradox format into this InterBase database.