Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Oracle/OAS and the fly likes Synchronizing 2 databases separated by firewall Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Synchronizing 2 databases separated by firewall" Watch "Synchronizing 2 databases separated by firewall" New topic
Author

Synchronizing 2 databases separated by firewall

Chengwei Lee
Ranch Hand

Joined: Apr 02, 2004
Posts: 884
I've 2 databases (DB1 & DB2) separated by a firewall. DB1 will push data to DB2 and pull data from DB2 via a nightly job. Is there any feature in Oracle that allows me to ad-hoc-ly push and pull selected records on request in a short time?


SCJP 1.4 * SCWCD 1.4 * SCBCD 1.3 * SCJA 1.0 * TOGAF 8
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30795
    
157

Chengwei,
A database replication tool could do this. Or you could write a script and kick it off with a cron job.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Chengwei Lee
Ranch Hand

Joined: Apr 02, 2004
Posts: 884
Originally posted by Jeanne Boyarsky:
A database replication tool could do this. Or you could write a script and kick it off with a cron job.


Would it be able to just replicate the delta?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Synchronizing 2 databases separated by firewall