Home:ALL Converter>Validating Long RAW column in oracle with SQL Server after migration using SSMA

Validating Long RAW column in oracle with SQL Server after migration using SSMA

Ask Time:2013-02-05T14:54:42         Author:Dibin

Json Formatter

I have an oracle 11g source which I hae migrated to SQL Server 2008 using SQL Server Migration assistant tool from microsoft. The oracle source had a table that contained a long raw column. The type mapping that was used for migration was long raw -> varbinary(max). When I view the oracle data using SQL developer, the column is only showing RAW in every rows. However in SQL Server, I am able to view the migrated data in string format.

What can I do to validate or crosscheck the data in oracle to that with the data in SQL server, or atleast is validation of long raw column possible?

Author:Dibin,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/14701773/validating-long-raw-column-in-oracle-with-sql-server-after-migration-using-ssma
yy