How to Resolve - O2SS0346: SQL Server Migration Assistant for Oracle Error message: Referencing columns not nullable ?

During SSMA migration from Oracle to SQL Server we generally face the below error


O2SS0346: SQL Server Migration Assistant for Oracle Error message: Referencing columns not nullable

The meaning of above error is : In oracle we have a column which is marked for accepting Null (can accept Null) and also a part of Referential integrity.

SQL Sever raise this as an error because, if the column is part of Referential Integrity then how can it be a Null ?

You can still force SQL Server to accept this during migration using below settings

 How enable this option

1. Go to SSMA Tools Menu 
2. Select Project Settings, you will be shown with the below screen
3. As per the below screen shot enable the option 
4. Save it and re-run the report.