Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: