CODEWITHSUNDEEP
oracle-databasesql-server-migration-assisql-server-2017
DoomerDGR8
DoomerDGR8

Reputation: 5042

Migrating data from Oracle to SQL Server error: The value is Null

I have been getting a strange error since today when trying to migrate data from an Oracle DB Server to SQL Server 2017 Express using the latest SQL Server Migration Assistant for Oracle v7.5

The error affects certain tables only and read simply: The value is Null

During import process

Import report

I don;t know how to trace the issue especially because it was working last week when I did the last import on an older version of SSMA. Just this morning the new version got installed.

Upvotes: 1

Views: 1062

Answers (2)

Blade
Blade

Reputation: 620

This was a bug in SSMA v7.5, and has been fixed in version v7.6.

Upvotes: 0

user3489896
user3489896

Reputation: 46

I was using "Oracle Client Provider" to connect to Oracle and I was running into the same problem.

I switched to OLEDB Provider and TNSNAME mode just to test. That solved the problem for me!

Upvotes: 3

Related Questions