By default, in the Server (and single-user) installation of Camelot 3.x, your main database file will be put in the C:\Program Files\Camelot3\Database folder, and it is the file named CAMDB.FDB.
If you will like this file to be kept somewhere else, then you can move that CAMDB.FDB file to whatever folder you'd like, but then you must tell the Firebird server program where you have moved it. This information is in the C:\Program Files\Firebird\Firebird_2_0 folder in a file named aliases.conf, which is just a text file. You would edit the "camelot = " entry in this file to point to the new location of your CAMDB.FDB file.
Below are very specific steps given as an example for creating a new folder on a local D: hard drive and moving the Camelot3 database file to that location. If you are running windows Vista, you MUST be sure you have disabled User Account Control before attempting these steps or using Camelot at all.
1. Make sure everyone is completely closed out of the Camelot program.
2. Go to the windows Start menu and choose My Computer (or Computer in Vista)
3. In the list of hard drives shown, double-click on your D: drive
4. from the File pull-down menu at the top, choose New > Folder, and enter the new folder name "Camelot3Data", and close the My Computer screen.
5. Now go to the windows Start menu again and choose My Computer
6. double-click on your local disk C: drive, then the Program Files folder, then the Camelot3 folder, then the Database folder, and right-click on the CAMDB.FDB file there and choose Cut.
7. Close the My Computer screen again, and then open it again from the Windows start menu
8. now double-click on the local disk D: drive, right-click on the "Camelot3Data" folder you've created there, and choose Paste
9. Close the My Computer screen again, and then open it again from the Windows start menu
10. double-click on your local disk C: drive, then the Program Files folder, then the Firebird folder, then the Firebird_2_0 folder
11. in this folder, find the file named "aliases" or "aliases.conf", and double-click on it. If it says windows doesn't know how to open this file, choose Select Program from a list, click Next, and then choose the Notepad program, and click OK
12. Here in this file you will find an entry that reads:
camelot = C:\Program Files\Camelot3\Database\CAMDB.FDB
and so you need to choose the right-hand side of the equal sign there to be the new path to your CAMDB.FDB file, which for this example would be:
camelot = D:\Camelot3Data\CAMDB.FDB
13. then just close this file with the X at the upper right, and say Yes to save changes. Now when you open the Camelot3 program, it will be connecting to this database location.
moving database relocating database shared folder changing database folder changing location of database choosing different location
