HP OpenVMS Systems

ask the wizard
Content starts here

Database Replication?

» close window

The Question is:

 
My system consists of three databases.  One resides an Intel SQL Server and
the other two are RMS files residing on Alphas.  The three machines are on
one Ethernet network, however one of the Alphas is remote and connected by a
T1 line.  The two Alphas sh
ould be exact copies of one another.
 
New or updated data is pushed from the SQL Server to the local Alpha via
ASCII batch files.  New or updated data can also be entered directly into
either Alpha.
 
I would like to know what is the best way to keep the 2 Alphas synchronized.
 
I have more experience with SQL Server and it would be nice to have a
replication mechanism similar to the one SQL Server provides.  Through some
quick searching through your archives, I've come across terms such as
Snapshot services, BACKUP, RTR, Volume
Shadowing and RMS journaling.  Could any of these be candidates for easy,
reliable replication between two RMS files running on remotely connected
Alphas?
 
TIA
Allen Aune
 
 


The Answer is :

 
  BACKUP, RTR, Volume Shadowing and RMS journaling are generally all
  unrelated to this request -- RTR is the closest as it provides a way
  to perform transactions over the network, though you will more likely
  want to consider something such as the Oracle Data Distributor package.
 
  You will likely best want to contact 1-800-DIGITAL (in North America),
  or the local Compaq pre-sales technical support organization in your
  area.
 

answer written or last revised on ( 12-JUL-1999 )

» close window