Q

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 me.

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 first published in November 2002

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close