Answered by:
Transfer Data from Oracle to SQL Server

Question
-
Hi All,
All is well.
How to transfer Data from Oracle To SQL ?
Sunday, April 5, 2015 9:53 AM
Answers
-
Please find various way in below:
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/
- Proposed as answer by Shanky_621MVP Monday, April 6, 2015 6:49 AM
- Marked as answer by Katherine Xiong Tuesday, April 14, 2015 3:34 AM
Sunday, April 5, 2015 10:04 AM -
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- Proposed as answer by Shanky_621MVP Monday, April 6, 2015 6:49 AM
- Marked as answer by Katherine Xiong Tuesday, April 14, 2015 3:34 AM
Sunday, April 5, 2015 11:57 AM -
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:
- Download and install SSIS Connector for Oracle based on your SSIS version.
- Drag a Data Flow Task to Control Flow Task.
- 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.
- Drag an Oracle Source to the Data Flow Task, then double click the Source to point to your Oracle Database and select the table.
- Connect OLE DB Destination to Oracle Source, or we can make some transformations between those two components.
- Drag an OLE DB Destination that connects to the target SQL Server table.
- 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).aspxThanks,
Katherine XiongKatherine Xiong
TechNet Community Support- Proposed as answer by Katherine Xiong Friday, April 10, 2015 2:15 AM
- Marked as answer by Katherine Xiong Tuesday, April 14, 2015 3:34 AM
Tuesday, April 7, 2015 6:27 AM - Download and install SSIS Connector for Oracle based on your SSIS version.
All replies
-
Please find various way in below:
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/
- Proposed as answer by Shanky_621MVP Monday, April 6, 2015 6:49 AM
- Marked as answer by Katherine Xiong Tuesday, April 14, 2015 3:34 AM
Sunday, April 5, 2015 10:04 AM -
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- Proposed as answer by Shanky_621MVP Monday, April 6, 2015 6:49 AM
- Marked as answer by Katherine Xiong Tuesday, April 14, 2015 3:34 AM
Sunday, April 5, 2015 11:57 AM -
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:
- Download and install SSIS Connector for Oracle based on your SSIS version.
- Drag a Data Flow Task to Control Flow Task.
- 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.
- Drag an Oracle Source to the Data Flow Task, then double click the Source to point to your Oracle Database and select the table.
- Connect OLE DB Destination to Oracle Source, or we can make some transformations between those two components.
- Drag an OLE DB Destination that connects to the target SQL Server table.
- 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).aspxThanks,
Katherine XiongKatherine Xiong
TechNet Community Support- Proposed as answer by Katherine Xiong Friday, April 10, 2015 2:15 AM
- Marked as answer by Katherine Xiong Tuesday, April 14, 2015 3:34 AM
Tuesday, April 7, 2015 6:27 AM - Download and install SSIS Connector for Oracle based on your SSIS version.
-
Hi All,
Thanks for your reply.
- Edited by narayanan_1983 Tuesday, April 14, 2015 5:46 AM
Tuesday, April 14, 2015 5:46 AM