TECHNICAL ARTICLE: howto_011.htm

 Close Window  

 
 


Title:
HOW TO:  Upgrade an Existing FLEETMATE Enterprise Edition Installation


DATABASE UPGRADE PROCEDURE:

  1. 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.
     

  2. Close FLEETMATE Enterprise on  all PCs.
     

  3. 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.
     

  4. 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.

  1. 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. 

  1. Once this process is performed, your user community may resume using FLEETMATE Enterprise Edition.


If you need additional assistance, please write or call us:
 support@FLEETMATE.com 
410-282-3603


FLEETMATE Software Copyright (c) 2005-2013 by SCB Consulting.  All rights reserved.
FLEETMATE is a registered trademark of SCB Consulting, LLC.