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

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 last published in September 2003

Dig Deeper on SQL Server Replication

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.