Q
Manage Learn to apply best practices and optimize your operations.

How to replicate an Oracle database to SQL Server?

I am trying to find the best solution for having a database replicated from Oracle to SQL Server without creating an Oracle instance in our machine. This is not a migration; the Oracle database will continue to be used as is, but reporting is to be done on the SQL Server database.

I am trying to find the best solution for having a database replicated from Oracle to SQL Server without creating an Oracle instance in our machine. This is not a migration; the Oracle database (DB1) will continue to be used as is, but reporting is to be done on the SQL Server (DB2) database. So what I need is to be able to push changes from DB1 to DB2 either in real time or in batches. I cannot find a tool that does this; does someone know of one? Have you done this solution and does it work? Or please let me know another way of pulling the data directly from Oracle to SQL. Please help me out.
If I understand your requirements correctly, you have data in an Oracle database that you wish to push to a SQL Server instance so as to run reports, without touching the Oracle database directly. Probably the best option here is to implement Oracle's Hetergenous Services (formerly called Transparent Gateways). With HS, you can create a database link from the Oracle instance to the SQL Server instance. To Oracle, HS makes SQL Server appear as if Oracle is talking to another Oracle database. Then, you can create triggers in the Oracle database that will update the data in SQL Server when the data is modified in Oracle. Basically, you will be implementing your own replication scheme here. The Oracle 9i and 10g documentation contains the information on how to set up HS for your use.

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