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

[former_member217874]

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.

[former_member187605 · Accepted solution]

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

[former_member217874 · Accepted solution]

Hi Dirk,

Thanks for you clarification.