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
- Go to SSMA Tools Menu
- Select Project Settings, you will be shown with the below screen
- As per the below screen shot enable the option
- Save it and re-run the report.
