SQL Server Performance Forum – Threads Archive

Transfer Data form oracle to SQL

Hi, I want to transfer data from oracle to sql
Not SQL to oracle.
This query would need to be scheduled to run daily. Does anyone have any suggestions on where to start.
Thank you for your help P

---

Check: http://books.google.com.ar/books?q=transfer data from oracle to sql&oi=print HTH Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

Also make use of Linked Server. Refer in Books On Line, SQL Server help file Madhivanan Failing to plan is Planning to fail

---

Also check other posts in the DTS forums for the similar references. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Hi
Use this One
Insert into {SQL SERVER TABLE} ({SQL SERVER TABLE}.{Field 1}, {SQL SERVER TABLE}.{Field 2}, ……..) Select {ORACLE TABLE}.{Field 1}, {ORACLE TABLE}.{Field 2}, …….. from
OpenRowSet(‘MSDAORA’,'{ORACLE SERVER NAME},{USERID},{PASSWORD}’, ‘ORACLE TABLE NAME’)
use In SQL Server Query Anylazer
Ashish Bajpai

---

I think DTS is the easiest way. you can schedule the DTS as well —————————————-
http://spaces.msn.com/members/dineshasanka

---

check this link which is covering:
Migrating Oracle Databases to SQL Server 2000 http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorcle.mspx

---

Ok No Problem
Type
Insert into OpenRowSet(‘……’,{Oracle Table Name}) A ({Oracle Field Name})
Select {SQL SERVER FIELD NAME} from {SQL SERVER TABLE NAME}

Ashish Bajpai

---

]]>