Database synchronization

Classic Servoy
1

I have developed a solution with Servoy/SQL Anywhere.

What I want to do next is to be able to run this solution locally and when the user is at the office synchronize it with the “main” database on the server.

The server is a Mac G5 and runs iAnywhere9 and the clients are Mac Intel computer and they run iAnywhere10.

I searched the internet for information on this matter but it is a jungle! So I have two questions:

  1. Does anybody know if it is possible to synchronize databases between the two versions?

  2. Is there a manual for “dummies” how to realize this on a Mac OSX platform.

2

Hello,

The MobiLink server from SQL Anywhere 9 can synchronize to MobiLink clients from version 9 and below, so unfortunately this will not work in your configuration.

The MobiLink server from SQL Anywhere 10 can synchronize with clients from versions 9 and 10, so in your case, you would need to upgrade your server.

I hope this helps!

Jose Ramos
Product Manager
Sybase iAnywhere

3

My server is a Mac G5, is it possible to run iAnywhere 10, or do I need an intelMac?

4

irenem:
My server is a Mac G5, is it possible to run iAnywhere 10, or do I need an intelMac?

Unfortunately no. Version 10 only supports Intel-based Macs.

Thanks,
Jose

5

A no for answer is also an answer. :lol:

This clarifies a big portion of the problems I had. I will look for an other server,

Thank you Jose

6

I’m working on a plugin in Servoy to accomplish this. Will allow a runtime to sync to a Servoy server and will be cross-database / cross-platform. I’ll let you know when I have more details.

7

Great stuff !!!

Can’t wait to get this plugin!!

Regards,

Hans Nieuwenhuis

8

goldcougar:
I’m working on a plugin in Servoy to accomplish this. Will allow a runtime to sync to a Servoy server and will be cross-database / cross-platform. I’ll let you know when I have more details.

Hi Scott, any updates on this?

9

The plugin is available now on a case by case basis. As it requires some work to get you started with it and it is not a standard product yet (read: it doesn’t ship with a 100 page manual) we will not make it generally available right now. For those interested please contact me by email to co-ordinate implementation with you.

10

Have you looked at this Open Source Data Synchronization tool.
http://opensource.replicator.daffodilsw.com/index.html

Daffodil’s Daffodil Replicator (OS) is an Open Source Data Synchronization tool that provides the capability to synchronize multiple heterogeneous data sources - some of which may be residing on a remote network.

Daffodil database synchronization tool allows its users to develop Java Databases for applications that can replicate and synchronize data between distributed Java-enabled databases. Replicator integrates impeccably with all Daffodil database products as well as with selected third-party databases that provide JDBC drivers.