Binary data type of Source (SQL server) gets converted in RAW data type (Oracle) which changes the data value in the target and doesn’t get matched with source system.
For example: In SQL server data is ' 0x00' after migration it's 0 in oracle. Similarly 0x40 get migrated as 40.
The following SQL Server data types should be mapped to the “LONG RAW” data type in Oracle: image, binary and varbinary. So instead of RAW use LONG RAW.
Hope this helps.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?