Multi-DB Synchronization

by ,
Odoo 7
v 14.0 Third Party 11921
Download for v 14.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 707
Technical Name base_synchro
LicenseAGPL-3
Websitehttp://www.serpentcs.com
Versions 14.0 8.0 7.0 9.0 11.0 12.0 13.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 707
Technical Name base_synchro
LicenseAGPL-3
Websitehttp://www.serpentcs.com
Versions 14.0 8.0 7.0 9.0 11.0 12.0 13.0

Multi-DB Synchronization

This module will let you synchronize more than 1 Odoo Databases!

Note: Make sure to apply --db-filter="db_name" when running the server locally in the system.

Configure Servers

Configure the Objects to Sync

You can set if you want to Upload/Download data or if you want to perform both of then simultaneously.

Start the Sync

For better insights, You will get a report once the Synchronization is complete.

Models that can be synchronized

Users, Contacts, Partner Category, Product, Product Pricelist, Sales Order, Sales Order Line, Purchase Order,Purchase Order Line, CRM lead, Bill of Materials, Bill of Materials lines, MRP Work center, MRP Routing Work center.

Check out our various Odoo Services below
 
Odoo Consulting Gap Analysis and BPR Odoo Implementation Integration with E-Commerce Odoo Technical Training
Offshore & Onsite Development Support and Maintenance Hire Dedicated Odoo Developer Payment Gateway Integrations Odoo Functional Training
Odoo Mobile App Development Odoo Manual Testing Odoo Automated Testing Integration with Shipping API Installation & Hosting
 
Check out our various Odoo Based Products
 
Restaurant Management Property Management Visa Agency Management Singapore Localization School, University Management
Construction Management Fleet Management Medical ERP Hotel Management Human Resource Management
Field Service Management Spa & Salone Management Ringcentral telephone integration Customer Relationship Talent Management
 
For any questions, support and development contact us.
 
(+91) 98793-54457, (+91) 90334-72982 +91-79-2975-0867 contact@serpentcs.com www.serpentcs.com www.serpentcs.in www.odooqa.com
WhatsApp, Telegram or Call 24X7 Help! Send Mail Browse our Services Browse our Products QA Services
 

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
Sync Local databse to another server (VPS)
by
Tri Nanda
on 8/4/22, 8:39 AM

Hi, it seems this is one of the best module.


I have a question:

Can this module sync Odoo local database to the another Odoo database in an online server like VPS?

Thanks,

Tri

Re: Sync Local databse to another server (VPS)
by
Jay Vora - SerpentCS
on 8/4/22, 9:54 AM Author

Hello Tri Nanda,

We have some questions based on your query:
1) which transaction you need to synch with another database?
2) Is it a single way or both way synchronization?

Kindly mail us at support@serpentcs.com.

Thanks.

Not Work
by
Manuel
on 2/23/22, 11:07 AM 
Odoo Server Error
Traceback (most recent call last):
  File "/opt/odoo/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/opt/odoo/odoo/odoo/http.py", line 685, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/odoo/odoo/http.py", line 361, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo/odoo/odoo/http.py", line 349, in checked_call
    result = self.endpoint(*a, **kw)
  File "/opt/odoo/odoo/odoo/http.py", line 914, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/odoo/odoo/http.py", line 533, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/odoo/addons/web/controllers/main.py", line 1398, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "/opt/odoo/odoo/addons/web/controllers/main.py", line 1386, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/opt/odoo/odoo/odoo/api.py", line 399, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/opt/odoo/odoo/odoo/api.py", line 386, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/opt/odoo/include/base_synchro/wizard/base_synchro.py", line 430, in upload_download_multi_thread
    target=self.upload_download()
  File "/opt/odoo/include/base_synchro/wizard/base_synchro.py", line 385, in upload_download
    self.synchronize(server, obj_rec)
  File "/opt/odoo/include/base_synchro/wizard/base_synchro.py", line 135, in synchronize
    value = self.data_transform(
  File "/opt/odoo/include/base_synchro/wizard/base_synchro.py", line 340, in data_transform
    df = self.relation_transform(
  File "/opt/odoo/include/base_synchro/wizard/base_synchro.py", line 280, in relation_transform
    res = [[res[0]]]
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/opt/odoo/odoo/odoo/http.py", line 641, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/odoo/odoo/http.py", line 317, in _handle_exception
    raise exception.with_traceback(None) from new_cause
IndexError: list index out of range
Re: Not Work
by
Jay Vora - SerpentCS
on 2/28/22, 3:50 AM Author

Manuel,

What config are you working on?

Thanks.

by
a7med.nor@gmail.com
on 11/26/23, 8:37 AM

are you planning to upgrade it ?



Re:
by
Jay Vora - SerpentCS
on 12/4/23, 12:32 AM Author

Hello, 

As of now no any upgrade plans. If you have any requirements, Kindly mail us at support@serpentcs.com.

Thanks.

Can this be used for synching data from version 15 to 16 database?
by
Aashim Bajracharya
on 7/26/23, 11:36 PM

I am in wonder if this module could be used to transfer data from odoo 15 to 16. Any possibility?

Re: Can this be used for synching data from version 15 to 16 database?
by
Jay Vora - SerpentCS
on 7/28/23, 6:49 AM Author

Hello Aashim,

Yes, it is doable but if the concept you think is full migration, we would not recommend

Thanks.

by
zhang zhi-heng
on 11/22/22, 8:03 AM

1. can this work with v15 community?

2. is it using dB streaming of postgreSQL?

3. does it have dB security such as RSA based security?

Re:
by
Jay Vora - SerpentCS
on 11/25/22, 1:44 AM Author

Hello zhang ,

1. This module is not yet migrated in v15

2. Yes, using PostgreSQL for dB streaming

3. RSA security is not there

Thanks.

by
francis hwenha
on 10/17/22, 9:49 AM

Error:
Odoo Server Error

Traceback (most recent call last):
File "/odoo3/odoo3-server/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/odoo3/odoo3-server/odoo/http.py", line 683, in dispatch
result = self._call_function(**self.params)
File "/odoo3/odoo3-server/odoo/http.py", line 359, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/odoo3/odoo3-server/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/odoo3/odoo3-server/odoo/http.py", line 347, in checked_call
result = self.endpoint(*a, **kw)
File "/odoo3/odoo3-server/odoo/http.py", line 912, in __call__
return self.method(*args, **kw)
File "/odoo3/odoo3-server/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/odoo3/odoo3-server/addons/web/controllers/main.py", line 1398, in call_button
action = self._call_kw(model, method, args, kwargs)
File "/odoo3/odoo3-server/addons/web/controllers/main.py", line 1386, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/odoo3/odoo3-server/odoo/api.py", line 399, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/odoo3/odoo3-server/odoo/api.py", line 386, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/odoo3/odoo3-server/addons/base_synchro/wizard/base_synchro.py", line 430, in upload_download_multi_thread
target=self.upload_download()
File "/odoo3/odoo3-server/addons/base_synchro/wizard/base_synchro.py", line 385, in upload_download
self.synchronize(server, obj_rec)
File "/odoo3/odoo3-server/addons/base_synchro/wizard/base_synchro.py", line 82, in synchronize
module = pool1.get("ir.module.module")
File "/odoo3/odoo3-server/addons/base_synchro/wizard/base_synchro.py", line 50, in get
return RPCProxyOne(self.server, ressource)
File "/odoo3/odoo3-server/addons/base_synchro/wizard/base_synchro.py", line 24, in __init__
self.uid = rpc.login(server.server_db, server.login, server.password)
File "/usr/lib/python3.8/xmlrpc/client.py", line 1109, in __call__
return self.__send(self.__name, args)
File "/usr/lib/python3.8/xmlrpc/client.py", line 1450, in __request
response = self.__transport.request(
File "/usr/lib/python3.8/xmlrpc/client.py", line 1153, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python3.8/xmlrpc/client.py", line 1165, in single_request
http_conn = self.send_request(host, handler, request_body, verbose)
File "/usr/lib/python3.8/xmlrpc/client.py", line 1278, in send_request
self.send_content(connection, request_body)
File "/usr/lib/python3.8/xmlrpc/client.py", line 1308, in send_content
connection.endheaders(request_body)
File "/usr/lib/python3.8/http/client.py", line 1251, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked)
File "/usr/lib/python3.8/http/client.py", line 1011, in _send_output
self.send(msg)
File "/usr/lib/python3.8/http/client.py", line 951, in send
self.connect()
File "/usr/lib/python3.8/http/client.py", line 922, in connect
self.sock = self._create_connection(
File "/usr/lib/python3.8/socket.py", line 787, in create_connection
for res in getaddrinfo(host, port, 0, SOCK_STREAM):
File "/usr/lib/python3.8/socket.py", line 918, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/odoo3/odoo3-server/odoo/http.py", line 639, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/odoo3/odoo3-server/odoo/http.py", line 315, in _handle_exception
raise exception.with_traceback(None) from new_cause
socket.gaierror: [Errno -3] Temporary failure in name resolution

Re:
by
Jay Vora - SerpentCS
on 10/18/22, 3:08 AM Author

Hello francis,

In server starting time need to use db_filter. As we mentioned in index page if still error will raise kindly mail at support@serpentcs.com

Thanks

It seems to be a great tool
by
Ahmed Eldeeb
on 2/14/22, 4:21 PM

Is this available to sync between two remote servers, this appears when it's happened

 File "/usr/lib/python3.8/xmlrpc/client.py", line 1341, in parse_response
    return u.close()
  File "/usr/lib/python3.8/xmlrpc/client.py", line 655, in close
    raise Fault(**self._stack[0])
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/odoo/odoo-server/odoo/http.py", line 640, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/odoo/odoo-server/odoo/http.py", line 316, in _handle_exception
    raise exception.with_traceback(None) from new_cause
xmlrpc.client.Fault: <Fault AccessDenied: 'Access Denied'>
by
Jay Vora - SerpentCS
on 11/22/21, 12:09 AM Author

Hello Ragavan,

In version 9 to 14, we had only this app for DB synchronization.

If you want more requirements, please email support@serpentcs.com


Thanks.


by
Ragavan
on 11/20/21, 12:23 AM

Does this app could be used for Odoo9 db to Odoo14 db synchronization?

Do you have any other app for database transfer Between Odoo9 to Odoo14 ?. I badly need that please help me with that

by
Ragavan
on 11/19/21, 4:00 AM

Validation Error

If your Synchronization direction is/ download or both, please install "Multi-DB Synchronization" module in targeted/ server!


please help me with this error

Re:
by
Jay Vora - SerpentCS
on 11/19/21, 6:05 AM Author

Its a warning that you should install module in both servers.

Thanks.

by
Ragavan
on 11/18/21, 11:12 PM

Hiii, Good work on this module. I am really interested do you have any Documentation about how this module works?

Re:
by
Jay Vora - SerpentCS
on 11/19/21, 12:57 AM Author

Ragavan, So far we have videos on youtube and webpage on this URL.

Thanks,

by
Francesco Moccia
on 11/4/21, 3:15 PM

Ho and thanks for your work.

Can this module also sync attachments to the record ?

And can it sync extra models like employees ?

Thanks in advance

Francesco

Re:
by
Jay Vora - SerpentCS
on 11/7/21, 5:30 AM Author

Welcome. This module will sync any odoo model.

by
ladylene@narratreeconsulting.com
on 6/24/21, 3:31 AM

Hi, I am interested with this.  Do you have any documentation on how to use multiple database in ODOO?

Re:
by
Jay Vora - SerpentCS
on 6/24/21, 10:44 AM Author

Ladylene, We do not have one. we are improving the product and will come up with the documentation next month.

Thanks,