Getting Started:Changing your Default Database

From Fishbowl Inventory

User Manual | Getting started | Starting Fishbowl

[edit] Changing your Default Database

Whether you are trying to create a blank database or connect to a different existing database, the following instructions will provide step-by-step instructions on how to do so.

[edit] Creating a new database

To create a new database you will need to be on the Fishbowl Server computer. The Fishbowl server will also need to be stopped, which will not allow any exisitng clients to stay connected.

Right click on your server in the system tray by your clock and go up to options. Click Yes to stop the server.
The Fishbowl Server Administration box will open up and will default to the database tab.
To connect to your first blank datafile highlight the line that says 'Your Company' and select 'ok' down at the bottom. This will connect you to an already existing blank database named 'event' (located in your Fishbowl\database\data folder).
Start your Fishbowl server again and connect your client. You now are connected to a blank database.

Create an additional blank database by repeating steps 1-2 then continue below.
In the upper right hand side of the database tab select the 'new' button.
Select whether your database will be internal or external. For convenience we recommend keeping an internal use database. click Next.
You will now be shown a list of boxes to fill out. Leave the Database box as 'Firebird'. Enter in an Alias and Database Name for the new file being created. Your company's name would likely be what is entered here. *Note: If you have pasted a database into your data folder and are trying to connect to it, you will need to ensure that the database name is precisely the same as the database you pasted into the data folder. Click Finish.
You will be directed back to the Fishbowl Server Administration box. The Alias name of your company you just created will now be displayed as a new line item in the list of database names.
Highlight your newly created datafile and click ok at the bottom of the wizard. A pop-up box will inform you that your database has been changed to the newly created one. Click ok.
Right click on your Fishbowl server again in the system tray and go up to start. A pop-up box will inform you that the database is importing schema. This may take a few minutes.
Once your Server has completely started you can connect your client to your new blank database.

[edit] Switching to an Already Existing Database

To create a new database you will need to be on the Fishbowl Server computer. The Fishbowl server will also need to be stopped, which will not allow any

exisitng clients to stay connected.

If you have an existing database and would like to switch to an example, or to another company datafile the following instructions will assist you in doing so.

Right click on your server in the system tray by your clock and go up to options. Click Yes to stop the server.
The Fishbowl Server Administration box will open and will default to the database tab.
Simply highlight the line of the database you are wanting to switch to by clicking on the name listed.
At the bottom of the wizard box click ok.
A message box will be displayed to inform you that your database has been changed. click ok.
Now we need to re-start the Fishbowl server by right clicking on your orange server icon in your system tray and going up to start.
You can now log in to your client and connect to the newly changed database.