Data transfer between Oracle and SQL Server, on two tables of big data volume over 4.6 million and 26 million of records. Would like to find out what setup or parameters need in TOAD Data Point to speed up the process.
Since these migrations of rows are across two different database types we cannot use any bulk processing of the db types. The only option to play with is the Optimize rows or row size in the import page. Optimize is the best as we keep increasing the two batch size until we reach the largest amount of resources. Also do not turn on the writing of errors. This disables the bulk processing and turns it back into one-row inserts.
