Data synchronization between two (2) different instances of SugarCRM

[shajiuddin]

Hi,

I have two (2) different instances of SugarCRM those are installed on localhost in 2 different countries.

I need to make data synchronization between them with in a user defined schedule

Is there any suitable way?

Regards

[sts]

Are both installations similar?

As far as I understand the databases of both systems run on different servers and the synchronization must be done in both directions. Every change of data on one side must be transferred into the other sugar instance. Logic hooks on each side calling the SOAP/REST interface of the other instance could do the job I think.

[shajiuddin]

Hi,

Alright, can you describe how is it possible using logic hooks because with in instance the code consider only that own database of that SugarCRM

and these both SugarCRM systems are running on localhost not on remote webserver


Regards

[christianknoll]

Why don't you use MySQL and set up a dual master syncronization. Should be easy and do the task where the database keeps the two instances in sync. Nothing to handle in Sugar itself. If the databases are the same then it should be no issue. If the databases are different you will have lots of fun in coding the sync logic ... ;-) ...

christian.

Hi,

I have two (2) different instances of SugarCRM those are installed on localhost in 2 different countries.

I need to make data synchronization between them with in a user defined schedule

Is there any suitable way?

Regards

[sts]

Yes, if both databases are the same it is the best solution to use direct database synchronization. This would save a lot of time compared with the logic hook solution which would be an option if the systems are different.

[gunni]

And dont forget to sync the files if you want uploaded documents to be synced as well.
I dont know your environment, so i can only blind recommend rsync or the like.
If master-master replication it not the way you like, you may have a look at different ETL-Tools like Pentaho, Talend or jitterbit for syncronisation of your databases.

[rafael.q.g@hotmail.com]

Whether two databases have to be exactly some data, you could also think about make both instances share the same database.
In case just some modules should be syncronized, then you could take a look on synchronization tools, as Jitterbit Open Source Integration - Business Integration Made Easy..