How to migrate from MS SQL Server image type to Oracle blob?

From: Kitae Lee <kitaelee_at_itnc.co.kr>
Date: Wed, 10 Apr 2002 09:18:06 GMT
Message-ID: <irTs8.72677$PC3.5953259@news.bora.net>

I am going to migrate from MS SQL Server 2000 to Oracle 8i.

But, I have image type data in SQL Server 2000.

Other data types have no problem to Oracle 8i.

How to migrate from MS SQL Server image type to Oracle BLOB or LONG RAW?

I tried to use Oracle Migration Workbench(OMWB).

So, I get the Oracle table having BLOB data type.

That table has some data in BLOB column when query by TOAD and

get "(BLOB)" reply for BLOB column in TOAD.

But, When I design the application using Developer/2000 to view image data,

no data displays in BLOB column.

What's wrong?

Thanks for reading!

PS : Is there someone knows how to download image file from MS SQL Server? Received on Wed Apr 10 2002 - 04:18:06 CDT