RE: SQL Server To Oracle

Did you try using the gui wizard? I *thought* there was a chance to specify the delimiter and so forth. Again, I'm really rusty on this, so bring your salt shaker.  

If you can connect network wise to the source data that might also be an option to select directly into your Oracle table. That worked from Sybase to Oracle circa sql*net one, but only if the line length total was under about 512. If it was longer you had to craft the query to have embedded line continuation characters followed by enough white space to make sure you got a new line after each continuation character. It was could be very tedious and you needed to figure out the maximum column length for each column to get the wrapping correct and I think there was some problem with the difference between zero length text values and nulls.  

Some of those brain cells encased in rust are resisting waking up completely, so bring a salt shaker.  

One other idea is to blend output files, one that fits (or more than one if they won't) all the non-text columns, an one each for the text columns prefaced by unique identifier. Then you can use text a script text processor on Linux with a pretty good chance to get it into one line.  

mwf  

From: Scott Canaan [mailto:srcdco_at_rit.edu] Sent: Thursday, March 10, 2022 1:09 PM
To: mwf_at_rsiz.com; oracle-l_at_freelists.org Subject: RE: SQL Server To Oracle  

Flat file only allows for tab delimited. It still does the same thing, create a new row for each CR, which SQL*Loader doesn't like.  

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration

Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520

<mailto: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.  

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mark W. Farnham
Sent: Thursday, March 10, 2022 12:24 PM
To: Scott Canaan <srcdco_at_rit.edu>; oracle-l_at_freelists.org Subject: RE: SQL Server To Oracle  

Did you already try using flat file output option and choosing comma as your delimiter?  

It has been a long time for me (since before MS bought sql server), so of course things may have changed.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan
Sent: Thursday, March 10, 2022 12:02 PM
To: 'oracle-l_at_freelists.org'
Subject: SQL Server To Oracle  

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

<mailto: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