Transfer Data from Oracle to SQL Server

Question

Hi All,

    All is well.

How to transfer Data from Oracle To SQL ? 

     

Answer 1

Please find various way in below:

http://stackoverflow.com/questions/7490576/what-are-ways-to-transfer-tables-from-oracle-to-sql-server

I would choose SSIS or Import/Export Wizard. Detailed steps documented in below:

https://dbadiary.wordpress.com/tag/data-import-from-oracle-to-sql-server-with-ssms/

---

Cheers,
Vaibhav Chaudhari
[MCTS], [MCP]

Answer 2

You can also set up replication from Oracle to SQLServer if you want to copy  table data across

see

https://msdn.microsoft.com/en-us/library/ms152481.aspx

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 3

Hi narayanan_1983,

According to your description, you want to transfer data from Oracle to SQL Server. Just as said above, there are multiple ways.

If we want to bulk loading Oracle data from Oracle to SQL Server, we can use SQL Server Integration Services package. For more detail steps, please see:

1. Download and install SSIS Connector for Oracle based on your SSIS version.
   
2. Drag a Data Flow Task to Control Flow Task.
   
3. Add Oracle Source component from Tools pane to SSIS Toolbox. If the SSIS version is 2012 and later, we should right-click one component in the SSIS Toolbox, then select Refresh Toolbox to add the Oracle Source in SSIS Toolbox.
   
4. Drag an Oracle Source to the Data Flow Task, then double click the Source to point to your Oracle Database and select the table.
   
5. Connect OLE DB Destination to Oracle Source, or we can make some transformations between those two components.
   
6. Drag an OLE DB Destination that connects to the target SQL Server table.
   
7. Click Mapping pane to finish the mapping.

For more details about using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services, please see the following document:
https://technet.microsoft.com/en-us/library/ee470675(v=sql.100).aspx

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 4

Hi All,

 Thanks for your reply.