Re: SQL Server To Oracle

Hey Scott,

Is a direct connection to Oracle a possibility? I've had success creating a Linked Server in SQL Server using ODAC (warning: reboot *required *after ODAC install) and then using SQL's OPENQUERY operator to push data from SQL to Oracle. I can't recall if that system had CLOBs or not, but I thought those were supported in ODAC 12.2.

My $.02,
Rich

p.s. If you try this, make sure the "Allow InProcess" option is checked on the Linked Server Provider options, and I believe I needed to check "Dynamic parameter" as well.

On Thu, Mar 10, 2022 at 11:03 AM Scott Canaan <srcdco_at_rit.edu> wrote:

> I’m trying to get some data from a SQL Server 2012 database into an Oracle
> 19c database on Linux. I’m having trouble with the CLOB fields (text in
> SQL Server). When I export the data to a csv, it splits the data in that
> is larger into several rows, which SQL*Loader doesn’t like. I don’t know
> how to get the data exported so I can use it or to import the data as it
> is.
>
> If anyone has any suggestions, I’d really appreciate it.
>
>
>
> Thank you,
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

--
http://www.freelists.org/webpage/oracle-l