Unable to use advance data migration feature custom select in SSMA ( Oracle)

Siddhesh Manjrekar 1 Reputation point

Hi Team,

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.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
396 questions
0 comments No comments
{count} votes