Re: Sybase to Oracle conversion: Problem loading sybase image data into oracle blob

Dwayne,
Hello, interesting you just posted this question - I in fact faced a similar problem when working with binary data types. After a lot of looking (since most of the tools I have are not that friendly), I started using a produuct called Schemer Advanced. It is avaialble from a company called Appligator (http://www.appligator.com). This product has made my life so much simpler as I can connect to all my ODBC/OLEDB data sources from this application and even copy and paste data/table stuctures/entire databases on the fly. If there are types that don't align such as the binary ones in my case, I can define what they should be as it brings up a wizard. Anyway - hope this helps you out! here is a link to the direct product details page of that application... http://www.appligator.com/products/Schemer/moreSchemer.asp Cheers!

In article <3a062c7b.3679479_at_news.ev1.net>,   wdlewis_at_ev1.net (Dwayne Lewis) wrote:
> Help !!!!
>
> I am involved in a Sybase to Oracle conversion and one of the Sybase
> tables uses an image datatype column. I unloaded the data from sybase
> and can load the rows into Oracle using sqlloader without any errors.
> The data is getting loaded into a table with the "image" data being
> loaded as a blob datatype. The image data that was in sybase was
> basically free form text. When I run a select * on the Oracle table,
> I can select on the other columns but I cant see the blob data.
>
> I don't think I can convert the data in Sybase before unloading it. I
> have tried other datatypes such as long and clob with any success
> also.
>
> Any suggestions would be greatly appreaciated.
>
> thanks,
>
> Dwayne Lewis
> Dwayne Lewis
> Database Administrator
> email: wdlewis_at_ev1.net
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 07 2000 - 21:55:02 CST