Moving data between Oracle to SQL Server

Posted on 2015-01-08
Medium Priority
Last Modified: 2015-01-17

We are planning to move data from Oracle to SQLServer.
Please let me know what are best ways to move data.

Thanks in advance
Question by:GK GK
LVL 11

Expert Comment

ID: 40537457
1. Create linked server on Sql server, to read Oracle data. REad:
2. Use Openquery to access/read Oracle records. Read

Author Comment

by:GK GK
ID: 40537513
Thanks HuaMinChen,

I want keep the data always in Sync.will wait for  few more ways to move data between the server,
LVL 11

Expert Comment

ID: 40537538
You can create jobs on Sql server to periodically synchronize the data, as the job may call Stored proc, that is running Openquery, inside.
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 40537738
There are products out there that will replicate between heterogeneous systems.

Microsoft solution:

Oracle solution:

There are probably others.
LVL 54

Expert Comment

by:Vitor Montalvão
ID: 40537847
SQL Server solution is Replication. You don't need extra licensing or tool to use it.
Oracle solution is GoldenGate but I never used it so I can't help you with this option.

Author Comment

by:GK GK
ID: 40539441
Thanks Vitor for update.

Up to now below are the solutions.

1.Linked server with Open quires
4.Golden gate.

LVL 29

Expert Comment

ID: 40540956
Or you could use an open source integrated ETL tool like Pentaho or CloverETL
Both are Great! ;)

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question