Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Pull data from Oracle and push into SQL Server
ashutosh kumar gupta
Jan 20 2016 5:48 AM
379
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to hide database in management studio?
how to use rank in Sql Server