Multiple Databases Per Server

Top  Previous  Next

[Enterprise Edition]: A database server can be configured to host multiple completely separate databases which can be identified with a unique name (Alias). You can choose which database to connect to by entering the name of the alias on the Advanced tab of the database connection form, or by setting up separate shortcuts for each database. See below for details:


Setting up the server:


1.First, install the Firebird database software and configure it for use with a single database as described in the shared database configuration instructions (if you haven't already).
2.After successfully installing, configuring, and testing the shared database, close all connections to the database and then make a copy of the database file located in the directory C:\KZSoftware. Name this file to distinguish it from the other files as needed. For example, if this is a test database, you may name it: TrainingManagerTest.tdb.
3.Lastly, use notepad to open the file "aliases.conf" (located in the Program Files \ Firebird directory), and add a new line containing the path to the new database file you created in Step 2, and an "Alias" name you will use to refer to this connection. Use the same format as the existing entries in the file. You may copy an existing entry and then paste it in at the bottom of the file and make changes to the alias name and database file path as needed. Be sure each database file has a unique alias name. In keeping with the "Test" database example, you might name the new alias, "TrainingManagerTest".


At this point, you should have already connected to the default alias from the client, and you can test the connection to the new alias as follows:


Connection to the new alias:


1.Open the client software, and select the menu item Tools --> Database Connection.
2.Select the "Advanced" tab, and change the "DB Name (Alias)" field to the name of the new Alias you created in Step 3 of the server setup.
3.You can now test the connection and then save it.


You can also set up multiple shortcuts to open the client with the specified database alias selected. For more information, please see the Command Line Options in the user guide at the following link:


Command Line Options