Android and a SQL Server database [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

I have a big SQL Server database I want to connect to and my question is, what is the best way going forward? And some link or bits of code would be appreciated.

My knowledge of databases is limited.

The problem is that a web service exists but it's currently using SOAP which I simply can not get to work with Android (yes, I've tried k2SOAP and others alike). I know Android supports restservice but maybe there is a simpler way.

• Maybe connect to SQL Server through PHP?
• Copy the database to MySQL and use PHP?
• I'm suggesting PHP because I've actually worked with PHP so I know it. It might be more trouble to re-code the web-service?

I would be greatly appreciate any help. I'm doing this for a company so the less I need to "mess" with their database the better.

[UPDATE]

I'm asking what is the most cost efficient, cheapest and fastest way of doing this?

I know this was a vague question but this is in simple what I want to do.

I've accepted the question below as the answer, since it seems to be the most cost-effi开发者_运维百科cent way of doing this.

---

If you ready to connect to the MSSQL database using PHP, why not simply create a RESTful based webservice. If you create a PHP file to connect to the database, then also you'll be needing a mechanism to connect to the PHP file from Android. Same would be the case with RESTful service.

I would suggest to go with a JSON based RESTful service.