Re: SQL Server Tables to Oracle Database

Phoenix wrote:

>Is there a way to do it in a procedure or function? I am hitting 14 SQL
>Servers and pulling the data over to a central SQL Server but need to
>convert my SQL Server to Oracle 8.1.7 and haven't found a way to get the
>data as yet.
>
>Regards,
>Ron Hagerman
>http://www.rons-sandbox.com
>
>
>

For the benefit of the rest of us ... what is 14 SQL Servers? 14 instances? 14 databases (schemas in Oracle)?

 From my experience the best way to move data between the two is SQL*Loader. But only after the data
extracted from SQL Server has been cleansed of all of the hidden lower ASCII characters that SQL Server
seems oblivious to.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)