Ask The SQL Server Expert: Questions & Answers

Options for replicating Oracle data to SQL Server

SearchSQLServer.com

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

To continue reading for free, register below or login

Requires Membership to View

To gain access to this and all member only content, please provide the following information:

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from the TechTarget network of sites, and/or third party content providers that have relationships with TechTarget, based on your topic interests and activity, including updates on new content, event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile, unsubscribing via email or by contacting us here

  • Your use of SearchSQLServer.com is governed by our Terms of Use
  • We designed our Privacy Policy to provide you with important disclosures about how we collect and use your registration and other information. We encourage you to read the Privacy Policy, and to use it to help make informed decisions.
  • If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States.