Soap Web Service Calls from SQL Server

Question

I'm not entirely sure if this is possible, but does anyone know how, or if you can make calls to a SOAP web service from SQL Server? Seems like it might be good performance-wise in the area of data sync applications. I feel like this might be a long shot though.

Thanks.

possible duplicate of [SQL Server - Using CLR integration to consume a Web Service](http://stackoverflow.com/questions/180046/sql-server-using-clr-integration-to-consume-a-web-service) — Aaron Kurtzhals, Oct 24 '13 at 19:31

score 1 · Answer 1 · answered Dec 05 '08 at 22:49

1

Creating a CLR based call is pretty tedious and not really recommended. why do you want to do this? maybe we can provide another option.

answered Dec 05 '08 at 22:49

Mladen Prajdic

15,457
2
43
51

I don't think there is another option. I'm basically looking into it because a client of ours said they wanted to use our web service and they don't know anything of .NET programming, all they know is SQL Server. I was seeing if it was even possible to achieve. – Wes P Dec 06 '08 at 03:20

score 1 · Accepted Answer · edited May 23 '17 at 12:19

1

You may want to refer to this stackoverflow question: SQL Server - Using CLR integration to consume a Web Service

edited May 23 '17 at 12:19

Community

1
1

answered Dec 06 '08 at 13:39

Nick Kavadias

7,542
2
37
46

score 0 · Answer 3 · answered Dec 05 '08 at 20:46

0

If you're using SQL Server 2005 or higher, you can call a Web service by creating a CLR Procedure that does the task.

answered Dec 05 '08 at 20:46

Mehrdad Afshari

414,610
91
852
789

Soap Web Service Calls from SQL Server

3 Answers3