SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Developer MSSql Migration, Online data move, image to long raw mapping

heijamNov 8 2010 — edited Nov 18 2010

Hello,

my task is to migrate a MSSql Server Database to Oracle 10.2.0.4 with SQL Developer Version 2.1.1.64
and JTDS JDBC Driver oracle.sqldeveloper.thirdparty.drivers.sqlserver 11.1.1.58.17.

Capture, convert and online data move works except data mapping from MSSql image to Oracle long raw dataype.
I need to map MsSql image to oracle blob, to achieve online data move!

is Sql Developer online migration MsSql image to oracle long raw possible?

I know that long raw is outdated, but i'm dba and not responsible for the software part.

What options should i try? offline data move? can MS Bulk Copy Program export image data and SQL*Loader import into long raw?

Any experience or tipp?

Thanks
Michael

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2010

Added on Nov 8 2010

#migration, #sql-developer

6 comments

1,072 views