0

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

Sri
  • 1
  • 1
  • Yes, it's possible. What are you asking? – p.campbell Mar 10 '11 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 Mar 10 '11 at 23:31

1 Answers1

2

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.

See also this one and this one

Community
  • 1
  • 1
Sebastian Zaklada
  • 2,308
  • 1
  • 14
  • 25
  • Many Thanks Sebastian. We actually dont want to create as webpages. what are the software pre-requisities for the first option? – Sri Mar 11 '11 at 00:03
  • 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. – Sebastian Zaklada Mar 11 '11 at 00:57