Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table migration from SQL Server 2019 to Oracle 19c using dblinks

User_7OO0XSep 13 2022

I need to migrate multiple tables from SQL Server 2019 into Oracle 19C. Currently I am using dblink connection from SQL Server and it can Migrate about 125K row per minute which is too long for me. Right now, I am using SELECT from SQL Server then INSERT into Oracle inside a procedure. I need a faster query or a query that can commit every 1 million rows so that the query can be inserted even the query is stuck. Thanks

Comments
Post Details
Added on Sep 13 2022
0 comments
365 views