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

Updating Oracle tables with data from SQL Server

I have two client server applications. One works with Oracle 7 and the other with SQL Server 2000. I want to update a few tables in the Oracle database with the data from the tables in SQL Server 2000.

I have two client server applications. One works with Oracle 7 and the other with SQL Server 2000. Now I want to update a few tables in the Oracle database with the data from the tables in SQL Server 2000. Can you suggest the best way to accomplish this?
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. I do not recall if Oracle 7 implemented Transparent Gateways or not, and I no longer have access to Oracle 7 documentation. You may have to upgrade your Oracle database to 9i or 10g to be able to implement this solution.

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