Loading Page ...

Web Pages

Web Page Database Integration

Internet database Synchronization
Intranets
  Services > Web, Internet, Intranet Services > Internet Database Synchronization

The recommended topology is a star topology, in which a hub replica on a server is connected to a number of satellite replicas throughout the organization. The Design Master is placed on a satellite computer, and replicas reside on the hub server and other satellites.
In this scenario, the Design Master is placed on a satellite computer along with Replication Manager, but not have the Design Master on a synchronization schedule. (The administrator can synchronize it with the hub replica when a structural change to the database is needed.) The replica on the hub server becomes the default synchronization partner for each of the other replicas in the organization. In addition to the Design Master and the hub replica, a base replica is used to copy subsequent replicas to remote clients' machines. Once a copy is made on a user's computer and it is synchronized with the hub replica, the copy becomes a true replica with its own globally unique identifier and is integrated into the Replica Set.

Synchronization Details
During synchronization, a client makes an HTTP connection with an Internet or Intranet server. The client builds a message file containing all the design and data changes that have occurred since the replicas were last synchronized, and places it in the FTP file location on the Internet or Intranet server. The Synchronizer on the Internet or Intranet server then applies these changes to its local replica. Next, the Synchronizer builds a message file containing all the design and data changes that have occurred since the client and server replicas were last synchronized, again placing them in the FTP file location. The server sends the name and location of the message file back to the client workstation. The client then transfers the message file from the server to the client workstation using FTP. All the changes specified within the message file are then applied to the client replica.
You don't need a Synchronizer on the client workstation to synchronize databases over the Internet or Intranet. Instead, the Microsoft Jet and Microsoft Windows DLLs handle all aspects of the synchronization. Depending on how the client workstation and the server are configured, establishing a connection with the server may result in the display of a login dialog box at the client workstation. In this case, the synchronization will not occur unless a user at the client workstation types the appropriate user name and password in the login dialog box.
When a client synchronizes changes with an Internet or Intranet server, several DLLs on the client and server computers work together to perform the synchronization. You cannot perform a direct synchronization between two databases over the Internet or Intranet (as you can on a local area network). Instead, the FTP folder on the server acts as a dropbox folder for an indirect synchronization.
There are other methods of providing updates to database information using Internet synchronization. These methods incur additional costs and administrative manpower to implement and manage. If you have an existing database platform that is not MS-Access, we can still provide the web database integration using other products. We can provide the ability for users to add, edit, delete and/or manipulate data using their familiar tools and in the background, provide Internet synchronization to keep the data up to date. Contact us for more details on your specific hardware/software and DBMS installation.

 

Links Page
Protocol Management System Email Access Software Host Access Software Host FileXfer Software Visit our Links Page

 Copyright © 2003, Input Output, Inc.  All rights reserved.

Questions / Comments about the site, contact Webmaster.