Laserfiche WebLink
<br />I. Memorandum describing SPWRMS database population scripts. <br />2. Operational data transfer utility. <br />3. Developer's Manual documentation in include the V AX to Server communications in <br />MS Word. <br /> <br />Task 7 -Client-Server Database Utilities <br /> <br />Responsibility: RTi <br /> <br />Objective: Develop the following two client-server database communication processes: <br /> <br />· Synchronize Utility A two-way means of a updating or appending "real-time" data <br />between the Server (INFORMIX) database and Client (ACCESS) database in both <br />directions. This includes data such as Satellite data, Call Information, Water <br />Information Sheet (Data and formatting), and Special Project Sheets. The client <br />machine will'keep track of the latest information received from the server to allow the <br />synchronization of "real-time" data to occur. Note: Satellite data will only flow from <br />the Server to the Client. <br /> <br />· Update (FTP) Utility A one-way means of transferring "static" data from the Server <br />(INFORMIX) database to a Client (ACCESS) database. This includes data such as <br />Structure, Water Rights, historic streamflow, map layers, etc. The update of the <br />client database will be a wholesale drop and replace which would occur only <br />infrequently, probably once a year. The consultant proposes not to actively <br />synchronize these data, only replace it when outdated. <br /> <br />Comments: The GUI's which execute the processes developed in this task are developed <br />in Task 12,Network Communication Options. <br /> <br />The utilities developed under this task are not intended to have the functionality of a <br />database replication technology as is available in the Enterprise Replication from <br />Informix. <br /> <br />Approach: <br /> <br />7.1. Approach Recommend an approach to synchronizing relational data between the <br />PC-Client (MS Access) and the Server (INFORMIX) databases in a 3-4 page <br />memorandum. Investigate existing software packages such as dbAnywhere. <br /> <br />7.2. Synchronization Utilities Implement the recommended Client-Server database <br />synchronization utilities and verifY operations. This functionality will be utilized by <br />the Database Sync GUI developed in Task 12.3. <br /> <br />7.3. Update (FTP) Utility Implement an update utility which will allow the user to drop <br />and replace selected ACCESS database table(s) based on user defined parameters <br />such as Water District(s) or Division(s). This functionality will be utilized by the <br />FTP GUI developed in Task 12.5. <br /> <br />c:\wlcrdsslscopelphlllblscope.doc <br /> <br />0718 <br /> <br />4/24/97 - 16 <br />