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 is it posible if possible how?