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!
> 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
Sent via Deja.com http://www.deja.com/
Before you buy.
by