RE: SQL-Server to Oracle 9205

  • From: "Gudmundur Josepsson" <gbj@xxxxxxxx>
  • To: "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 29 Aug 2005 20:28:51 -0000

Isn?t Data Transformation Services good for that sort of thing?

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Bryan Wells
Sent: 29. ágúst 2005 19:26
To: Oracle-L
Subject: SQL-Server to Oracle 9205

 

To my esteemed mentors...

 

I am attempting to create a Cognos (i know, i know...) datastore with sample
data.  however the oracle 817 export they provide (the only one for all i
know) appears to be corrupt.  is there a way to import from a SQLServer
export file, or should can/should i create a csv export from SQLServer then
run a massive import script?  what about SQL*Loader?  its been quite some
time since ive used it, so I cant remember if that is a viable choice or
not. 

 

with great respect...

Thanks

-- 
Bryan Wells
bunjibry@xxxxxxxxx
Oracle DBA hopeful 

Other related posts: