DAVIS FMS DriveRight Database Selection Guide (8186) - Manual (Page 4)

4
Selection Considerations: Multi-User
Davis recommends using either MySQL, MS SQL Server, or Oracle if more than
one user will be accessing the data at a time, if the fleet has more than five
vehicles, or if you are logging GPS data for more than one vehicle.
MySQL, MS SQL Server & Oracle Considerations
MySQL, Oracle and MS SQL Server database servers are very powerful
databases, which can support large amounts of data and multiple simultaneous
connections with good performance.
• Of these three powerful databases, MySQL is the most economical server. It is
by far the easiest to set up and maintain and is also the only multi-user database
used by DriveRight FMS that does not require the support of a database
administrator. We strongly recommend MySQL for customers with large fleets
and potentially large databases that do not already have a license for MS SQL
Server or for Oracle.
• In the case of MySQL, most of the maintenance commands will be integrated
through the DriveRight FMS software, to eliminate any administrative
overhead.
• MS SQL Server is a powerful database server from Microsoft. It is also easy to
setup, but MS SQL Server is more expensive than MySQL.
• If you decide to go with MS SQL Server or Oracle, it is assumed that you have
IT personnel who have knowledge to maintain these database servers.
• Though Oracle is a common database server among large applications, it is both
expensive and difficult to maintain.
• In order to connect to an Oracle server with DriveRight FMS running on
multiple machines, Oracle Client software must be installed on each machine.
Each installation of Oracle Client software must be individually licensed.
Multi-User Database Server Setup
Follow this sequence when setting up a multi-user database for DriveRight FMS:
1. Server Installation.
2. Client Installation.
3. Database Configuration.
Multi-User Database Client Setup
Follow this sequence when installing DriveRight FMS on a user’s computer:
1. Client Installation.
2. Database Connection.
MS Access Installation
Of all the databases, MS Access is the easiest to setup. DriveRight FMS
automatically installs all the required components for this database.
Server Installation
Not applicable. The server is automatically installed if it is selected during
DriveRight FMS initial configuration.