DAVIS FMS DriveRight Database Selection Guide (8186) - Manual

Davis Instruments, 3465 Diablo Avenue, Hayward, CA 94545-2778 U.S.A. • 510-732-9229 • www.davisnet.com
®
1
DriveRight ® Fleet Management Software
Database Selection Guide
Use this guide to help you select the right database to use with your DriveRight
Fleet Management Software (FMS), and to help you perform any required
database installation procedures before you run DriveRight FMS for the first time.
DriveRight FMS supports the following databases:
• Single-User Databases:
• MS Access (Microsoft Access) (all required software included)
• MSDE 2000 (Microsoft Desktop/Data Engine not supported in the
Windows Vista or later operating system)
• Multi-User Databases:
• MySQL
• MS SQL Server (Microsoft SQL Server)
• Oracle
When you first run DriveRight FMS, you will be required to select a database to
use with the software. Each of the supported databases for DriveRight FMS have
their advantages and disadvantages. First, we’ll look at the selection
considerations for each of the supported database types. Later in this document we
present the installation procedure for each of the databases.
Selection Considerations: Single-User
Review the following considerations for each database and then select the best
database for your situation.
MS Access Considerations
Of the supported databases, MS Access is the easiest to install and use.
• There is no additional software to buy if you use MS Access. DriveRight FMS
automatically installs all the necessary components when you first run the
program.
• MS Access does have limitations to the number of users connected
simultaneously to the database, the size of the database, and reliability of the
database.
• MS Access is only recommended for installations that have one user.
• Maximum database size for MS Access is 2 gigabytes.
• MS Access is only recommended for small fleets of five vehicles or less. Be
aware that if you are logging GPS and vehicle speed data or other CarChip
parameter data, the database size increases very rapidly since GPS and vehicle
speed data is logged much more frequently than data from the DriveRight
console. In such cases, if you decide to go with MS Access database, it is
advised to backup your data at least once a month.