You can export the data from the sql sever servce into the remote folder from there you can load the data into salesforce using cli job https://blog.mirketa.com/scheduling-of-data-loader-through-command-line/ 2 .You can use Heroku connect also https://www.heroku.com/connect 2 .You can write your Own webservice using SOAP and REST API
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
- Data loadder
You can export the data from the sql sever servce into the remote folder from there you can load the data into salesforce using cli jobhttps://blog.mirketa.com/scheduling-of-data-loader-through-command-line/
2 .You can use Heroku connect also
https://www.heroku.com/connect
2 .You can write your Own webservice using SOAP and REST API
Greetings to you!
Please refer to the below links which might help you further.
https://www.youtube.com/watch?v=D7KuWkn95ss
https://www.youtube.com/watch?v=16Yn90-Wd4A
http://blog.pragmaticworks.com/incrementally-loading-data-from-salesforce.com
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas