|
Title:
HOW TO:
Upgrade an Existing FLEETMATE Enterprise Edition Installation
DATABASE UPGRADE PROCEDURE:
-
First start your existing
FLEETMATE Enterprise client software, use the Help | About... menu, and note
your current Build number. This number will
tell you which "Alter Scripts" may need to be run.
-
Close FLEETMATE Enterprise on all PCs.
-
Perform the download/installation process for the Enterprise Edition from the
Download page of the FLEETMATE Website at each PC where FLEETMATE is
currently installed.
-
All database Alter
scripts must be successfully executed one-time using a PC that has Microsoft
SQL Server Management Studio software installed. Following are some example
scenarios listed below:
-
Look in the C:\Program
Files\FLEETMATE_Enterprise\Database\Scripts
folder for files named in the following manner. "Alter_FLEETMATE_10009.sql".
The
10009
in
the filename indicates that it will bring your database structure up to date
with FLEETMATE Build #9. If you already have build #9, you may skip this
because no changes are needed. However, if your current build is #8, you
will need to execute
Alter_FLEETMATE_10009.sql.
-
If your current build is #7, you
will need to execute Alter_FLEETMATE_10008.sql
and then execute
Alter_FLEETMATE_10009.sql
to
alter your database structure in an incremental fashion so that it matches
the most recent build number.
-
If your current build is #23,
and you are upgrading your system to build #27, you
will need to execute Alter_FLEETMATE_10024.sql
and then execute
Alter_FLEETMATE_10027.sql
to
alter your database structure in an incremental fashion so that it matches
the most recent build number. Note that not every new build of FLEETMATE
Enterprise will include an alter script, so that is why you will not file
scripts named
Alter_FLEETMATE_10025.sql
and
Alter_FLEETMATE_10026.sql
, because those two intermediate
builds required no changes to the database structure.
-
IMPORTANT NOTE: The alter scripts assume
a default database name of FLEETMATE. If your
database name is different, please edit all occurrences of the term
"FLEETMATE" within the script, to your actual database name, prior
to running the Alter script.
-
Once this process is performed, your user community may
resume using FLEETMATE Enterprise Edition.
|