Re: DBMS "store and forward"

Mary Anne Espenshade wrote:
>
> I'm on a project that is trying to decide between Oracle and MS SQL
> Server (or even something else if we can justify it). I have no
> experience with either (my DBMS background is in INGRES). The system
> will have wide-spread client-server installations and some data will
> have to be exchanged between servers. It looks to me like what is
> needed is an application that sends a specified subset of the data
> from one server to another under certain circumstances. It doesn't
> seem to me like the sort of thing that needs all the overhead of
> replication or a distributed DB. The project leader's favorite term
> is "store and forward" and he wants a DBMS that will do this
> automatically - store the data locally and forward it later when
> communication becomes available. Is this something DBMSs, Oracle
> especially, do these days? My DB experience is 5 years out of date.
> The servers are PCs running NT.
> --
> Mary Anne Espenshade
> mae_at_aplexus.jhuapl.edu

ORACLE can send data from a table or groups of tables (or subsets of columns from these tables) to another database at a specified frequency. In ORACLE this is called a snapshot. The receiveing tables are read-only. If you wish to be able to modify data at both ends and keep both ends in synch, you would use symmetric replication.

Wayne Linton Received on Tue Oct 08 1996 - 00:00:00 CEST