Laserfiche WebLink
INVENTORY DATABASE FROM HANSEN/ORACLE <br />DATABASE TO MICROSOFT 4CCESS AND <br />CONTINUED TECHNICAL SUPPORT - CAMP, <br />DRESSER, & MCKEE <br />The Board reviewed a Memorandum of October 27, 2000: <br />DATE - <br />TO: <br />FROM: <br />PREPARED <br />AND STAFFED <br />BY <br />SUBJECT: <br />OCTOBER 27th. 2000 <br />JAMES E CHANDLER <br />COUNTY ADMINISTRATOR <br />DONALD R HUBBS. P.E <br />DIRECTOR OF UTILITY S <br />STEVEN J. DOYLE P.E. <br />CAPITAL PROJECTS MANAGER <br />INDIAN RIVER COUNTY UTILITIES <br />CONVERSION OF UTILITY INFRASTKUCTURE INVENTORY <br />DATABASE FROM HANSEN/ORACLE DATABASE TO MICROSOFT <br />ACCESS AND CONTINUED TECHNICAL SUPPORT <br />BACKGROUND & ANALYSIS: <br />On March 7, 2000, Staff presented and the Board of County Commissioners approved the <br />conversion of the GIS computer system from a Unix Based computer software platform to a Windows - <br />NT computer platform. The Utilities Department with the assistance of the County's <br />Coon terthe Services <br />Department completed the transfer and is now presenting the final step <br />for ni <br />computer system <br />Since the conversion to Windows NT has been substantially successful, it is now considered <br />viable to transfer the utility inventory / monitoring database (Hansen/Oracle) fromthe <br />Unixn soft <br />while at the same time eliminating a proprietary maintenance program (Hansen/Oracle) <br />is a utility maintenance program that inventories and monitors utility components, such as valves, fire <br />hydrants, meters, etc., and generates preventative maintenance schedules in the form of work orders. The <br />Hansen/Oracle software can be eliminated and the data transferred to a Microsoft program (MS Access) <br />which has the ability to perform the same functions at a substantially less cost. <br />The annual cost for maintenance of the Hansen/Oracle database software program is $10,800 per <br />year. The Department cancelled the annual maintenance contract when the decision was made to convert <br />to Windows NT =Having evaluated several alternatives, including reentering the data, it was considered <br />less expensive to pay the onetime fee for a professional consultant to convert the database then to pay <br />recurring annual software costs to the Hansen/Oracle licensed software vendor. <br />Convertin g the data to Microsoft Access also allows other Departments. such as EMS to share in <br />the information. The newer MS Access database will be easier to use, modify and extract information <br />then its predecessor (Hansen). <br />The current database is buried throughout the Hansen/Oracle program making data retrieve and <br />conversion difficult. Staff has requested that CDM Inc provide technical experts in retrieving the fire <br />hydrant maintenance & inventory Oracle database located within the Hansen/Oracle environment. <br />NOVEMBER 14, 2000 <br />-131- <br />BKII6PGI143 <br />