Re: MS SQLServer to Oracle data migration - info needed

you should use a blob column, but if you have only one column of image in your tables, you don't have to replicate this and the image is little enough, you can use the long raw type, that is a little easy to administer (for example, you can do a backup of the DB that include also the image because the data is stored into the datafiles).

Pablo

"prav_saras" <member_at_dbforums.com> ha scritto nel messaggio news:3d14157f$1_at_usenetgateway.com...
> I have been asked to look at migrating 20Gb of data from a MS SQLServer
> system into Oracle 8i. one field is Image in one table of sqlserver Has
> anyone else done a SQLServer to Oracle migration, and if so, how?
>
> Thanks
>
>
>
> --
> Praveen sharma
> Project lead
> Jcast networks Ltd.
> New Delhi
> India
>
> Posted via dBforums
> http://dbforums.com
Received on Sat Jun 22 2002 - 06:33:12 CDT