Re: MS SQLServer to Oracle data migration - info needed

Under no circumstances use Long Raws.

They are there for backwards compatibility only, officially deprecated in 8i, strongly discouraged in 9i, and I wouldn't be surprised if they disappeared altogether in 10i.

Their presence will cause migration issues when eventually moving to 9i. They are neither as large nor as flexible nor as capable as BLOBs, and if we are really talking about BLOBS and not BFILEs, then BLOBS are just as much part of the database (and hence backupable) as any other data type. You are confusing being stored out of line with being stored outside of the database altogether.

Apart from all of that, pretty close.
HJR "Paulus" <xxxx_at_xxxxx.xx> wrote in message news:YfZQ8.51433$j65.1224427_at_twister1.libero.it...
> 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 - 07:16:34 CDT