Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

asked 18 Mar '13, 12:15

waleedramadan's gravatar image

waleedramadan
101358
accept rate: 0%

edited 18 Mar '13, 14:10


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

permanent link

answered 19 Mar '13, 08:12

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

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.

permanent link

answered 19 Mar '13, 08:39

J%20Chapman's gravatar image

J Chapman
3413612
accept rate: 66%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×371
×84
×79
×72
×14

question asked: 18 Mar '13, 12:15

question was seen: 10,988 times

last updated: 20 Mar '13, 13:13