Oracle to SQL migration: Fail due to BLOB datatype.: Very Urgent.

Oracle to SQL migration: Fail due to BLOB datatype.: Very Urgent.

 

  

Hello,

I need to migrate the schema and data from Oracle database (Source) to SQL
Server database (Destination). I used DTS packages for this. Most of the
tables got migrated. I am not able to migrate some tables because they
contain columns having data type as BLOB. Can someone please let me know the
simplest (it's ok if it is not the cleanest approach) way to accomplish
this. I have tried some tools available in the market but none of them were
helpful. This is really very urgent..



Tushar Dave

Intrack Inc




Oracle LazyDBA home page