I am pulling the data from Oracle and pushing it into the sql server. In the Oracle there are around more than 1 Billion records. I am fetching the data from the Oracle using the addlinkserver into the sqlserver.
Now the problem is that while it fetches the data from oracle using the OPENQUERY it takes too much time to fetch the data from oracle and also takes time to push the data as well.
Please let me know is there any faster approach to pull from oracle and push into sql server?
Please help me it is very urgent. I am stuck there 3-4 days.