Regarding web services

Question

I have a  backup server it is having latest products available  information that is sql server the application is developed in vb.net,I  want  to use a webservice to pull data out off SQL Server and  update a different server that resides different location, the application is developed in  Magento(php and mysql server) the purpose is  to give latest available products and prices information to clients ,for online shopping.
And can we write trigger's  on both servers i.e when they got changes made then the webservice call automatically and shuld be updated, it it posible…