Exporting data from SQL Server database to Oracle database

Question

Hello All,

We need to replicate a table's data of SQL Server database to Oracle database.

Can this task be accomplished using Import/Export wizard or Linked servers?

Can help me regarding which Oracle data access components should i download to do this?

I am using SQL Server 2012.

And i have Oracle 11g release 2 client installed in my system.

Thanks in Advance.

---

Thanks and Regards, Readers please vote for my posts if the questions i asked are helpful.

Answer 1

Yes you can definitely transfer data from SQL server to Oracle Have a look at below links

Export SQL server data to Oracle Using SSIS

Use OLEDB data provider to transfer data from SQL server to Oracle

Using Import Export Wizard

Similar thread

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

My TechNet Wiki Articles

Answer 2

Hello Sir,

Yes I am already familiar in using Import and Export wizard to move or copy data from one SQL Server to another and other formats like Microsoft XL, Flat file etc.,

But thing is I am not able to download correct "oledb provider for oracle". Or even if i download, I am not getting to store those files at or how to install that.

Can you help me any how in this?

---

Thanks and Regards, Readers please vote for my posts if the questions i asked are helpful.

Answer 3

Hi,

Please refer to below link

http://blogs.msdn.com/b/dbrowne/archive/2010/03/23/oracle-database-connectivity-for-the-microsoft-bi-stack-part-1-oracle-client.aspx

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

My TechNet Wiki Articles

Answer 4

But thing is I am not able to download correct "oledb provider for oracle".

And what's the exact issue here? Click on the Provider you wants to use; you can get them here: http://www.oracle.com/technetwork/database/windows/utilsoft-088126.html

---

Olaf Helper

[ Blog] [ Xing] [ MVP]