How to send a HTTP or XML/RPC request from SQL Server stored procedure/trigger?

my client has SQL Server with some customer info and I am developing e-shop using MySQL database. What we need is to keep the database of customer loyalty points synchronized. When customer buys a product in an ordinary shop (not e-shop) these开发者_如何学运维 are recorded on SQL Server (via some accounting app). The problem is that I need this information to get to the MySQL server which stores information for the e-shop application, so the amount of loyalty points gets sync'ed on both servers.

Is there any way how can I send http and/or xml/rpc request from SQL Server via either trigger or stored procedure (I suppose trigger can trigger a stored procedure, so either of these is fine)?

---

Is it essential to interface with the MySQL DB via xml/rpc?

I might try to accomplish this by linking the MySQL DB to the MSSQL DB... the process will be version dependent so your MSSQL version is helpful...

But this site:
http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_server_in_MS_SQL_Server

may be a good start for you

EDIT: And here, for MSSQL2008
http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/