Migrating a schema from Oracle 19c to Microsoft SQL Server 2017 (RTM-CU25) (KB5003830) - 14.0.3401.7 (X64) and the transfer of data is very slow. Moving an address table with 13 million rows from Oracle to Oracle across a wide are network takes less than 2 minutes. Using SQL Server Management assistant for Oracle, v8.22, takes 17 hours with the SQL Server, app server (with migration assistant) and Oracle all in the same data center. What options can be set to improve the transfer rate from Oracle to SQL Server using the migration assistant?
log
Status,Source table,Target table,Total rows,Migrated rows,Success rate,Duration (DD:HH:MM:SS:MS),Error messages
"Completed","""<schema>"".""ADDRESSES""","[<instances>].[<schema>].[ADDRESSES]",13220149,13220149,"100.00 %","00:17:08:48:587",