Q
Problem solve Get help with specific problems with your technologies, process and projects.

Most efficient way to replicate data

I have read numerous ways of replicating data across different operating systems and different databases. My question is, which of these methods is the most efficient and productive? Could you shed some light on replicating data in one non-Oracle database when either a table or data is updated at some 33 different Oracle databases?

I have read numerous ways of replicating data across different operating systems and different databases. My question is, which of these methods is the most efficient and productive? Oracle mentions it but is not very clear when it comes to non-Oracle databases. Could you shed some light on replicating data in one non-Oracle database when either a table or data is updated at some 33 different Oracle databases?

If the both the master and the slave databases are Oracle, then the best way to implement replication is to use Oracle's Advanced Replication product. This add-on product is the most efficient method to implement replication between Oracle databases. The product does cost money, but you save in having to implement your own custom replication scheme.

If you have a non-Oracle database in the mix, then replication becomes more complicated. To replicate data from Oracle to another vendor's database, you can create a database link to the non-Oracle database using Oracle's Hetergenous Services. You can then create triggers on the tables to be replicated and write your own routines to replicate the data through the database link.

For replicating from a non-Oracle database to Oracle, the solution becomes even more complicated. You can see if your non-Oracle database implements something similar to Oracle's Hetergenous Services and then create a trigger to replicate the data. If this solution is not feasible, then you will have to code triggers to call external programs which will perform the replication for you. These external programs can be Java and use JDBC to connect to the Oracle database, or they can be any programming platform that supports ODBC connectivity.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close