Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Fastest way to get 65 million records of data from SAP into SQL

Posted on 2015-01-24
2
Medium Priority
?
172 Views
Last Modified: 2015-01-26
Hi

What is the fastest way to get 65 million records of data from SAP into a SQL table?
0
Comment
Question by:Murray Brown
2 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 2000 total points
ID: 40568118
I'd suggest using the SQL server Import/Export Wiard and creating an SSIS package as described here:
https://msdn.microsoft.com/en-us/library/cc185161%28v=bts.10%29.aspx

Do some tests on a subset of the data first and only query the full set (whole table) when you're happy with the performance.
0
 

Author Closing Comment

by:Murray Brown
ID: 40572078
thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question