Unable to use advance data migration feature custom select in SSMA ( Oracle)
We had a scenario where we had to migrate one table data ONLY from Oracle to SQL. Tables are created as part of scripts by application team.
Source and Table column details mentioned in the attached image.
Since one of the column name is different ( data type in source - raw and in target it is varbinary) , I was trying to use custom select feature in advance data migration tab as below,
select "ID", "KEY" as "KEY_VAL" from T1
However it could not map the columns and data migration was failing saying missing key value.
Please suggest if there is any solution within SSMA that can be used.
Note - To workaround, I did convert the same table from source to target ( in different temporary schema) and finished schema,data migration to temp table. And then from this temp table I inserted records in final target table.
Sign in to comment