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

Replicating from SQL Server to Oracle

I want to do a replication from SQL Server to Oracle. How can I achieve it? Your inputs will be of great help to...


Your replication solution will depend on your replication requirements. Do you need data replicated in near-real time, or will you only need data updated every so often? If you need data replicated in real time, then you might wish to look at SQL Server's solution to link Oracle databases. (I'm not a SQL Server expert so I can't give you any guidance there). If the data needs to be replicated every so often, then you can use SQL Server's Data Transformation Services (DTS) to push data to Oracle through OLE DB.

Alternatively, you can connect Oracle directly to a SQL Server database, through ODBC, using an Oracle product called Heterogeneous Services.

For More Information

This was last published in November 2002

Dig Deeper on Oracle DBA jobs, training and certification

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.