How recive data from SQL Server to Android Application, in autonomous manner? <p>I have created a web service which, querying a SQL Server, retrives several tables. I'm consuming this web service using KSoap2 package in Android application, and I want maintain alligned the tables on SQL Server and tables on Android Application. Many of the tables in SQL Server remain the same over time, but some others change frequently. I need an automatic mechanism for update the tables on Android Application, on the initiative of Server. I think I need a socket on Android application, for listening a signal transmitted from SQL Server, the meaning of which is "the data in some tables are changed". So, then, I can use the web service call for retrieves new data. Is this possible? anyone has suggestions?</p>