CODEWITHSUNDEEP
androiddatabase
Sindu_
Sindu_

Reputation: 1465

Which database to use with android application

I am developing an android mobile application using eclipse. I need a database that resides on a desktop computer. I need to save and retrieve information to and from the database to the mobile application. I will be storing details such as login details, registration and location of user. SQLite will not be appropriate for this since the database created will only be accessible by itself. Can I use SQL server for this? I am new to android and I am not sure what database to use and how to save and retrieve information to and from the database to the mobile application. Please help.

Upvotes: 2

Views: 15561

Answers (4)

user1527161
user1527161

Reputation: 11

I would HIGHLY recommend using Sybase SQL Anywhere. Their UltraLite DB works on Android as well as Windows. It has a MobilLink Server that allows for two-way data transfer between the PC and the Android device. You can get the Developer Edition for free from www.sybase.com. The current installation also includes a fully working Android sample application that includes data synchronization between the PC and Android device.

After all, Sybase wrote SQL Server for Microsoft originally - see: http://en.wikipedia.org/wiki/Microsoft_SQL_Server

Mark

Upvotes: 1

Swayam
Swayam

Reputation: 16364

Use SQL server to manage the data on your desktop and create a web-service in .Net on Visual Studio.

Then connect to the web-service in your application and set/get data from the DB.

Link on how to make a web-service in .NET (does not include the implementation in Android) : http://srikanthtechnologies.com/blog/dotnet/wsdaljava.aspx

Links on how to connect your service with Android : http://seesharpgears.blogspot.in/2010/11/basic-ksoap-android-tutorial.html

http://www.codeproject.com/Articles/304302/Calling-Asp-Net-Webservice-ASMX-From-an-Android-Ap

http://adrianandroid.blogspot.in/2012/05/access-c-net-web-service-in.html

Upvotes: 7

Freni
Freni

Reputation: 143

Ypu can use SQL Server with your mobile app but still u have to use one web service to connect it with SQL Server DB or you can also use WAMP Server with MySql DB that will be easy to implement.

Upvotes: 1

user1092042
user1092042

Reputation: 1295

The best bet if you are using Windows is WAMP server. It comes with phpmyadmin(Although you do need to get a few tweaks in order to get it up and running correctly). Then it is very easy to use the database(mysql) as you have a graphical interface with phpmyadmin. Ofcourse if youre going to need to access it from your application you would have to provide an intermediary php script to get it working correctly

Upvotes: 1

Related Questions