Skip to Content

How to handle BLOB datatype while loading from Oracle to SQL SERVER

Hello Experts,

My scenario is...

Source: Oracle11g

Target: Sql Server

I have a performance hit While loading from oracle to Sql server with column which contains BLOB.Its changing the rows per commit to 1 by default.

Is there any work around for increasing the performance.

Thanks,

Srinivas.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 05, 2017 at 12:54 PM

    No. Most databases apply record-level commit when dealing with blob data.

    Add comment
    10|10000 characters needed characters exceeded