title: Convert Raw[16](Guid) in Oracle to uniqueidentifier in SQL Server by SSMA
body: <p>I have dealt with the problem that I need to convert data from the <code>Oracle</code> database to the <code>SQL Server</code> database and there is no way except SQL Server Migration Assistant.<br><br>
  In <code>SSMA</code> there is a <code>TypeMapping</code> which allows you to define types you want to cast. I added Raw[16](Guid in Oracle) to UniqueIdentifier(Guid in oracle) as <code>TypeMapping</code>.<br><br>
  But when SSMA started to convert data it returns this exception:</p>
  
  <blockquote>
    <p>The given value of type Byte[] from the data source cannot be
    converted to type uniqueidentifier of the specified target column.</p>
  </blockquote>