Multi-DB Synchronization

by Odoo S.A. , Serpent Consulting Services Pvt. Ltd.

v 14.0 Third Party 11537

Lines of code	705
Technical Name	`base_synchro`
License	AGPL-3
Website	http://www.serpentcs.com
Also available in version	v 8.0 v 11.0 v 12.0 v 7.0 v 13.0 v 9.0

You bought this module and need support? Click here!

Lines of code	705
Technical Name	`base_synchro`
License	AGPL-3
Website	http://www.serpentcs.com
Also available in version	v 8.0 v 11.0 v 12.0 v 7.0 v 13.0 v 9.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.

Ratings
Discuss

Sync Local databse to another server (VPS)

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)

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

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

Jay Vora - SerpentCS

on 2/28/22, 3:50 AM Author

Manuel,

What config are you working on?

Thanks.

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:

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.

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:

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

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'>

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.

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

Ragavan

on 11/19/21, 4:00 AM

Re:

Jay Vora - SerpentCS

on 11/19/21, 6:05 AM Author

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

Thanks.

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:

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,

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:

Jay Vora - SerpentCS

on 11/7/21, 5:30 AM Author

Welcome. This module will sync any odoo model.

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:

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,

Multi-DB Synchronization

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

Start the Sync

Models that can be synchronized

Please log in to comment on this module

Sync Local databse to another server (VPS)

Re: Sync Local databse to another server (VPS)

Not Work

Re: Not Work

Re:

Re:

It seems to be a great tool

Validation Error

Re:

Re:

Re:

Re: