Data Synchronisation between 2 databases

Hello all, I am starting a new project in which i need to send data from one database to another. I was thinking of installing 2 clients that watch both databases for changes and automatically send over the changes to the other database… Does anyone have any experience in doing this? Can anyone please help me on where to start or what the easiest way is to do this? I already made a sheet that contains all object fields that need to be transferred between the databases… Thank you very much in advance

Did you take a look at the “Replikator” from Kloster ? See http://www.kloster-import.dk/ You should evaluate the license-costs and the setup-time against the time that you spend for your own solution. Some of our customers use it and are quite content with it.

  1. Which network type are you using ? (LAN,WAN) Speed of network ? 2. It is two equal databases (you need transfer 1<->2) or not (1->2) ? 3. Did they use common data (Inventory, customers, vendors …)? Data collision problem. This is the fundamental questions. I have used Kloster replicator. I have developed own replication application. What to choose, it depends on what you want :slight_smile:
  1. Which network type are you using ? (LAN,WAN) Speed of network ? We are on a LAN netwerk with 10 and 100mbit connections. 2. It is two equal databases (you need transfer 1<->2) or not (1->2) ? Yes, the databases are equal 3. Did they use common data (Inventory, customers, vendors …)? Data collision problem. Yes they do use common data but data collision is not possible… I am looking at the kloster website right now, thank you for the advice…