File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Synchronizing 2 databases separated by firewall

 
Chengwei Lee
Ranch Hand
Posts: 884
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33671
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chengwei,
A database replication tool could do this. Or you could write a script and kick it off with a cron job.
 
Chengwei Lee
Ranch Hand
Posts: 884
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic