SQL Server Performance Forum – Threads Archive
How to populate MSSQL Server Tables with Oracle8 THi,
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
quote:Originally posted by raja9072 Rushendra i want to populate MSSQL Server Tables with Oracle8 Tables very day Raja
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. _________
If u want to use with linked servers in sql refer books online topic is openquery in sql server . Thanks.