TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ashutosh kumar gupta
NA
190
0
Pull data from Oracle and push into SQL Server
Jan 20 2016 5:48 AM
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.
Reply
Answers (
1
)
How to hide database in management studio?
how to use rank in Sql Server