I am a SQL dba and new to Android. Is it possible to develop an android application which interacts with SQL server 2008 database (remotely) and monitor the happenings? such as agent jobs, event logs, disk space etc
2
-
Yes, it's possible. What are you asking?p.campbell– p.campbell2011-03-10 23:29:38 +00:00Commented Mar 10, 2011 at 23:29
-
Thanks Campbell. I want to develop a android application so that i can monitor my SQL database through my mobile phone. can you tell me the pre-requisites and how to start with?Sri– Sri2011-03-10 23:31:00 +00:00Commented Mar 10, 2011 at 23:31
Add a comment
|
1 Answer
Create a set of WCF services on the server. You might want to use SMO to interact with SQL Server. Query WCF from your Android device.
This should get you started.
Not sure, but you might also consider checking 3rd party tools like SQL Centre Pro
OR create a set of web pages to do the job and access them from your Android device.
2 Comments
Sri
Many Thanks Sebastian. We actually dont want to create as webpages. what are the software pre-requisities for the first option?
Sebastian Zaklada
Just as I said - you can expose pretty much everything through web services, and an Android application can consume them (see the link in my answer to see, how to consume WCF services in Android). These services should retrieve the information that you need from SQL Server instance(s). SMO (see another link in my answer) is one of the methods available to query SQL Server for information.