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

Hi

What is the fastest way to get 65 million records of data from SAP into a SQL table?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
SimonConnect With a Mentor Commented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.