SQL Server Performance Forum – Threads Archive

How to populate MSSQL Server Tables with Oracle8 T

Hi,
How to populate MSSQL Server Tables with Oracle8 Tables ?? Raja

---

You can use import/export wizard in sql server to accomplish this activity. Rushendra

---

Rushendra i want to populate MSSQL Server Tables with Oracle8 Tables very day Raja

---

Infact u can use the same for vice versa. Thanks

Rushendra

---

Import/Export wizard will let you define a one-off task to copy data from Oracle to SQL Server, but the last stage will let you save the task definition as a DTS package. This can then be saved to sql server and scheduled as a job to run daily.
Depending on your requirements (ie, refill from scratch every day?) this might be adequate, or you may need to go into DTS designer and create a fully customised DTS.

---

Can we do the same with linked servers??

---

Yes you can use Linked server and use OLE DB provider for Oracle and source SQL*Net alias that points to an Oracle database. REfer to BOOKS ONLINE for more information. _________
Satya SKJ

---

If u want to use with linked servers in sql refer books online topic is openquery in sql server . Thanks.
Rushendra

---

]]>