Q

Options for replicating Oracle data to SQL Server

We have our in-house production database in Oracle. We need to replicate the data to MS SQL Server for reporting needs. Could you please suggest all the options and alternatives that I have to achieve this?

There are three that I'm aware of and have used in production environments:

  1. Bulk unload the data from Oracle to files, copy the files to the SQL Server, use BCP or DTS to load the data into SQL Server.
  2. Create a DTS package that moves the data from Oracle to SQL Server.
  3. Buy Data Mirror, and set it up to move incremental data from Oracle to SQL Server.
The first two methods will essentially overwrite everything in SQL Server each time they run. The third method, while more expensive, will apply incremental changes to SQL Server as they happen in Oracle.

For More Information

This was first published in September 2003

Dig deeper on SQL Server Replication

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:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close