Replicating transactional data from Oracle 9.2 RAC to SQL Server 7
I want to replicate data from Oracle 9.2 RAC on Linux to SQL Server 7.
To move data from Oracle to SQL Server, you'll need to use a product called Transparent Gateways. With Transparent Gateways, you set up a database link in your Oracle database to a non-Oracle database. The nice thing is that Oracle does not even need to know if the remote database is SQL Server, DB2, or anything else. Once you have that database link set up, you can write triggers to be fired when your tables change and push the data into SQL Server across the Transparent Gateway link.
There are 3rd party software solutions which can help as well. A quick search on Google should find them.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments