1

Wanna know how to connect sql azure with android app and sql server?

STEP 1: I want to use real-time sync between exist database (dbo schema and other) in sql server and azure mobile services/azure sql database.

  • If I use Microsoft SQL Data Sync Agent to connect it, What do I have to do? e.g. add an id column to an existing table.
  • Do you have other way better than this or any other suggestions ?

STEP 2: I want to connect android app to azure mobile services or azure sql database.

  • How to connect android app to an existing Azure SQL table (from previous step) with Windows Azure Mobile Services.
  • I'm trying to connecting SQL Azure from my android application with jdbc and jtds, But it doesn't work. Do you have other way or any other suggestions ?
Improve this question

2 Answers 2

Reset to default
1

You are working with Android . So, you need to go as:-

switch to Android Studio , if you already did it then it's fine. Use tutorials provided by Microsoft Azure Mobile Services. Here is the link to get started for Android :-

For brand new DataBase and new Mobile Services :-

https://github.com/Azure/azure-mobile-services/blob/master/docs/mobile-services-android-get-started.md

EDIT : Broken links updated

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Links are broken
1

This is the answer to your step 2

If you don't want to use a brand new database and want to use your existing azure database then follow this link. This is a jtds method and I followed it and it worked for me.

You will use your jdbc connection url that comes with your database instance on azure portal with minor changes in it which are explained in the link. Your portal profile password and username will also be used in the connection url so keep in mind hackers might get a peak to it if they examine your application apk.

Improve this answer

1 Comment

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.