Can a Progress DB be mirrored?

T

taylormade

Member
We have a Progress 8.3b database.
We would like to mirror (real time) the db on a different server using a different type of DB.
Then be able to query that othe DB using SQL queries and programs.
What options are there to do this?
 
We did some replication to an Oracle database by using schema triggers to create replication records that are then processed into an oracle database via a batch process with Oracle Dataserver but this has many limitations and problems, not least the performance issues of using the triggers and the overhead that the clients have to see the trigger code.

There is a Progress company (PeerDirect) that provides a facility to do hetrogeneous replication that can also be bi-directional. I am not sure how stable this or whether it can be used with v8.3b and it might a bit of overkill.

Try taking a look http://www.peerdirect.com/products/data_replication_engine/index.ssp

Alternatively if you were prepared for the second database to be a Progress one then there are a couple of other potential solutions, such as AI file switching and roll forward, and Fathom Replication (another Progress product).

I hope this helps.
 
You must log in or register to reply here.
Back
Top