cancel
Showing results for 
Search instead for 
Did you mean: 

SAP data to SQL server?

Former Member
0 Kudos

Hi All,

Can anyone share their expertise/knowledge/idea on how to get the data from SAP server to SQL? and which is the best method to perform the transmission, SAP to Excel to SQL or Direct from SAP to SQL?

Thanks in advance.

Have Great day!!!

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi James,

Please check whether the below note helps.

Note 1774329 - Preparing your SAP instance to connect to remote SQL server

Thanks and Regards,

Vimal

cherry_tian
Explorer
0 Kudos

Hi, James,

Do you want to export SAP objects to a remote SQL SERVER?

Please consider a system copy or DB copy if your SAP system is also on a SQLSERVER.

If your SAP objects are currently stored in a non-SQLSERVER database, for example, Oracle, you have to do a heterogeneous system copy, which we also call "migration". 

If your SAP system is on a SQLSERVER, you can detach /attach sap DB to the remote SQL SERVER. Please refer to note 151603.

Best regards.

Cherry.

Former Member
0 Kudos

Hi James,

I don't understand what do you want. Why you do not open SQL and Copy table?

Regards

former_member188883
Active Contributor
0 Kudos

Hi James,

As I understand you have an SAP system from which you want to transfer some data to either SQL database or excel file.

If my understanding is correct, could you help us with Database version on which SAP system is running .

Regards,

Deepak Kori