I'm trying to send data from MS SQL Server to an android app, and I've seen online tutorials so far, they only teach how the receive/insert data from/into MS SQL Server from the android side. Is there any way to send data to android from the SQL server side "live"?
In my context, I have a website created in visual studio with the sql server in the same project, and I want to send a notification to the android app upon clicking a button in the website.
For receiving data from MS SQL Server using android app, I used Microsoft's jtds driver, which I imported into the android app. Can this driver be used to receive data as well?
-
you can use firebase notifications for this...i dont know about MS jtdsBipin Gawand– Bipin Gawand2017年08月07日 09:39:13 +00:00Commented Aug 7, 2017 at 9:39
-
@BipinGawand do you mean use firebase database?mabel– mabel2017年08月07日 09:57:00 +00:00Commented Aug 7, 2017 at 9:57
-
Possible duplicate of How to push the data from database to application?coding Bott– coding Bott2017年08月07日 09:58:09 +00:00Commented Aug 7, 2017 at 9:58
1 Answer 1
Yes you can, but i have no idea if this works with you db client.
You can use the SQL-Server Service Broker to send notifications to clients. These notifications can triggered by table triggers like insert, update and delete.