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…
Loading
SenthilkumarPosted Feb 24, 2012, 5:55 AM
If you want to update the database with in the server still you can do it the triggers.
Even if you want to update table to the other servers then you can add those servers (sp_addlinkserver) and you can update.
still you want to write some web services then you should have sql server 2005 and above.
http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm
http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx