I am starting work on implementing offline client capability for my current development. Is there anyone who has already done this and would be willing to share their experience?
In the first instance I want to know what the minimum steps are to get basic synchronisation working between offline client and central database.
Current dev platform is Mac OS X - unfortunately the default install of SQLAnywhere on OS X does not seem to include all the necessary sample files to allow me to follow the Mobilink tutorials which is making the job harder
Any help gratefully received.
Alternatively if anyone else is about to embark on this path and would like to share experinces as we go, get in touch.
In answer to your query - NO. I’ve had to shelve this for a while but still need to come back to it. I have tried the mobilink tutorials and managed to get a synchronise working using the tutorial files, but haven’t got as far as making this work with a servoy solution yet.
If you’re making headway keep in touch. I’m hoping to explore this further with Sybase and Servoy here in the UK at an upcoming developers meeting in a couple of weeks.
I have been playing with SQL Remote. This is a simplified file based sync tool. It is also bidirectional, scales and has programmable conflict resolution. It is limited to sybase, doesn’t have lots of security, prioritized sync, advanced sync logic written in lots of languages and automatic sync scripts among other things. However, it looks like it may be a good tool for sending updates down to users.
I also did the tutorial and it worked fine. However, I had trouble using it with Servoy. I wanted to see if the runtime builder database would work with it. You have to create a db with all the settings for users and sync stuff and then extract it as a second db. Then you can sync the two databases. I did that and then created a solution based on the remote database and tried to use the runtime builder with this. The idea would then be to use the consolidated database at my end and sync between them. Unfortunately, the runtime builder stopped working for me so I couldn’t get very far. I can’t even make a simple runtime since I moved to the latest beta. I’ll try again with the release of 2.2.