Move KM8 database to a new server.
KM8: All versions
When the current KM8 server being decommissioned and replaced by another server, specific steps must be followed to moved from the old server to the new server.
Directly copying the database files while in use is dangerous because the database engine could write data during the copy process. If this happens, the copy will likely be corrupted.
Not following this procedure risks corrupting the database.
Ensure that all users are logged out of KM8 and do not use KM8 for the duration of this process.
The product activation must be removed from the old server to make it available for reactivation on the new server.
Refer to Product deactivation to move to a new server for information on this process.
Prior to copying the database from the old server, we will rename it.
This serves two purposes.
Locate the database. The default location for the KM8 database is:
C:\ProgramData\WH Software\KM8\Database
Almost always it is called KM8.fdb.
Rename it to MovedToNewServer_KM8.fdb
If Windows will not allow you to rename the database then do not continue.
This means the database is in use.
Using KM8Setup.exe, perform a new install of KM8 to the new server.
When the installer runs the ProMaster Key Manager 8 Database Creator program, click Cancel to close it. This will skip the creation of a blank database because we do not require it.
Copy the renamed database file to the KM8 database folder on the new server.
The KM8 database location is:
C:\ProgramData\WH Software\KM8\Database\
Next, rename the copied database files on the new server from MovedToNewServer_KM8.fdb to KM8.fdb
Configure and test backups on the new server.
See Backup overview or the KM8 help file.
DO IT NOW. DO NOT SKIP THE BACKUP CONFIGURATION.
On each workstation, edit the following file:
C:\ProgramData\WH Software\KM8\KM8.ini
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=OLDSERVER:KM8
The [Environments] section defines the default environment available to the program and points to the next section called Environment-Default. Then in the section [Environment-Default], the server for that environment is named (in this example) OLDSERVER with a database alias of KM8.
Change the name of the server to that of the new server (in this case NEWSERVER):
[Environments]
Default=Environment-Default
[Environment-Default]
ServerName=NEWSERVER:KM8
Save the configuration file
Login as a normal user (not the ‘admin’ user) to perform the KM8 activation.