WH Software Knowledge Base

How do I configuring multiple databases?

Here are some notes on KM7 regarding setting up multiple database on a server.

Step 0:

Determine the databases you want and some logical names

e.g.

Database 1

Business unit = “Watercare Services”

DatabaseName = WATERCARE.FDB

Environment = Watercare

Alias = Watercare

 

Database 2

Business unit = “Social Development Services”

DatabaseName = SOCIALDEVELOPMENT.FDB

Environment = Social Development

Alias = SocialDevelopment

 

Step 1:

Do a full install on the server.

If you are running the next version (we have not released it yet), then you may run the setup like this:

KM7Setup /V LEAVEDBCFG 1

Otherwise run it in the normal manner.

During the installation, it will ask you of you are upgrading from KM5 or not (your choice here, depending on whether you want to bring across the data from your KM5).

At some point in the installation, the database creator wizard will run.

**** if you are not running the “next” version where you can start it with the /V parameter described above then you must do the following steps.

**** Open the folder C:\Program Files\WH Software\KM7\Bin

**** Copy from that folder the two files called KM7DbCfg.exe and KM7Empty.fbk into a temporary folder of your own

Allow the installation to complete.

**** if you are not running the “next” version where you can start it with the /V parameter described above then you must do the following steps.

**** Move the two files described earlier from your temporary folder back to C:\Program Files\WH Software\KM7\Bin

**** This is because the installer automatically removes these two files when it is finished with them.

 

Step 2:

Open the following file in notepad:

C:\Program Files\WH Software\KM7\FB\aliases.conf

There will be a single line

KM7=C:\PM7Data\KM7.FDB

Based on our examples above, we want to change this file to have just the following two lines:

Watercare=C:\PM7Data\WATERCARE.FDB

SocialDevelopment=C:\PM7Data\ SOCIALDEVELOPMENT.FDB

As you can see, this file is making an alias for each physical database, thereby storing the actual database file name in only one location.  This file is read by the database engine.

 

Step 3:

On the server (but the same changes will need to be applied to each workstation), edit the following file:

C:\ProgramData\WH Software\KM7\KM7.ini

(on older operating systems it is in the corresponding location in C:\Documents And Settings\All Users\ApplicationData\...)

In that file there will be two sections that look like this (likely the blank lines will be missing but you may make blank lines to make the file more readable):

[Environments]

Default=Environment-Default

 

[Environment-Default]

ServerName=localhost:KM7

 

Based on our examples above, we want to change this part if the file the following:

 

[Environments]

Watercare=Environment-Watercare

Social Development=Environment-SocialDevelopment

 

[Environment-Watercare]

ServerName=localhost:Watercare

 

[Environment-SocialDevelopment]

ServerName=localhost:SocialDevelopment

 

As you can see, this ini change is making two “Environments” each which point to another section in the same ini file, which in turn specifies the server (localhost) and alias (as we set earlier in aliases.conf)

 

Later, the same change needs to be made to all workstations (but possibly not all environments on each workstation), but on the workstation the reference to localhost will be the name of the server on which the databases are hosted.

 

Step 4

During the installation, the database C:\KM7Data\KM7.fdb was created.  We have changed all references so they are specific to each customer, so this database (it may have been a blank one or may have been your KM5 database upgraded depending on the choices you made) must be renamed.

Change its name from KM7.fdb to WATERCARE.FDB

 

Step 5

We now need to make the other databases (only Social Development in this example as we did the other database in step 4)

Run the program:

C:\Program Files\WH Software\KM7\Bin\KM7DbCfg.exe

Choose “New Installation”

Choose “Social Development”

Keep making any choices requested to complete the wizard.

Re-run KM7DbCfg for any other databases that need to be created.

 

Step 6

Still on the server, log into each environment as “admin”, one at a time and enter the registration information that corresponds to that database.

Create a user account for yourself in each database (if you are in a Windows domain you may want to associate your account with your domain account).

Log out then log in as yourself

Perform the product activation.

Log out then repeat this process for each other database.

 

Step 7

Still on the server, run KM7Back, click the configure button and ensure that all environments are selected for backup and ensure that the Windows Scheduled Task is created and active.

Remember: Do not do anything that directly affects the FDB database files such as your own backup processes or even anti-virus software.  Read the documentation about this as it is very important.

Lots of words?  Yes.  Difficult?  No.  All of this is only a few minutes work, but the first thing to get right is “Step 0” as these are the names you will use in various places.

 




Article Details

Last Updated
26th of October, 2011

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions ( )

How would you rate this answer?



Thank you for rating this answer.

Related Articles

No related articles were found.

Attachments

No attachments were found.

Continue