Simple steps to use SQL Anywhere, Ultralitej, and Mobilink on Android

[Former Member]

Background:

• I'm having a Client Application that uses an offline database - that database needs to sync with the server database at the end of each day to upload updates
• The client application is built using Mono for android
• I'm currently using microsoft sync framework, sqlserver, and sqlite, but I'm considering moving to sql anywhere

I need simple steps on how to use sql anywhere, ultralitej, mobilink to achieve that scenario

[jeff_albion · Accepted solution]

Try the "Building an Android Application" Tutorial in the documentation:

http://dcx.sybase.com/index.html#sa160/en/ulj/uj-android-tutorial.html

---

If you can't move the consolidated database data over to SQL Anywhere right away, you should be aware that MobiLink can also synchronize directly with Microsoft SQL Server:

http://dcx.sybase.com/index.html#sa160/en/mlserver/ml-basics-mss-5159304.html

The concept is similar: you have to install the system tables and write SQL scripts to control the synchronization data flow.

Once you have the basics covered and you understand how the synchronization system works, you can also extend this tutorial to use Java or .NET scripts instead:

http://dcx.sybase.com/index.html#sa160/en/mlstart/mt-objtext.html

[Former Member]

For the UltraliteJ with Mono part see my answer here. We've been doing this for over a year now with very large applications and have had no problems. Now with the binding project you can also link to the native code easier.