Oracle 11g Migration to SQL Server 2014 ( oracle table with bfile data type)

  • Hello All, I'm using SSMA to migrate Oracle to SQL Server . Bringing Bfile data into SQL Server seems to be very challenging. SSMA is migrating bfile data as varbinary(max) column inside the table. when I tried to read this data using bcp utility, only half of the file is readable and remaining data is ASCII characters or lost. Meaning its not migrating cleanly. Anyone has done bfile migration using SSMA or know how to migrate outside SSMA? Appreciate your time in advance !!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply