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!