Above is the connection with a SQL Dedicated Server, and below is Oracle.
I need to get data from SQL Server and get it in Oracle.
What is the best way to make it?
Most of the table in SQL has more than 3 million rows, so copy the oracle
Has anyone got this issue first?
Either way, I want to get this data from SQL to fast .
By the time I used the Oracle driver (not Microsoft), I had very slow performance (using SSIS). Use an OLE DB destination with fast loading and make sure that (if it is OK) use the table lock on the OLE DB destination target.
No comments:
Post a Comment