I have 2TB of data to copy from Oracle on Linux to SQL Server on Windows.
I am using SSMA. So far over the past 3 days only 575,000,000 have been migrated.
Is it feasible to change the batch size to 10,000,0000?
Is there a way to pause and restart this process without losing or duplicating data already inserted into the SQL Server table?