06-28-2012 2:50 PM
Hi,
we have an interface between SQL Server and SAP, which is sending and reading data via files.
Now we wanted to change that to a direct connection via .Net Connector or Web Services.
The data volume, we are talking about, could be easily 8 mio. of records per table.
I have written a c# application, which is using the .net connector to call a bapi and each call is of course running very long.
So i thought to split the data in 10000 line-packages, or something like that.
what do you think about using web services instead?
Please let me know your suggestions!
Thank you very much!
Michael
07-17-2012 7:45 PM
Hi Michael.
Did you try with native SQL ? Take a look to the program "ADBC_DEMO".
Check this link
Note 178949 - MSSQL: Database MultiConnect with EXEC SQL
Regards,
Manuel H.