Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
databasemerge17
2 Antwoorden
1175 Weergaven
Avatar
Kuralarasan

 Hi,

I’m looking for guidance on how to combine two Odoo databases (both on the same Odoo version). 

The use case is to merge data from two separately running instances into a single one ideally preserving customers, products, sales orders, inventory, etc.

Some key points I need help with:

* What's the recommended approach for merging two Odoo databases?

* Can this be done through Odoo's built-in import/export tools, or do I need to use custom scripts?

* Are there any best practices or risks I should be aware of (e.g., handling duplicate IDs, conflicts in sequences, etc.)

* Is there a way to merge selected models (e.g., only customers and products) without affecting the rest of the target database?

Both databases are running on Odoo 17 enterprice, and both have similar modules installed.

Any guidance, tools, or experiences you can share would be greatly appreciated!

Thanks in advance .

Avatar
Annuleer
Avatar
Gautam
Beste antwoord

Hi,

Merging two Odoo databases (even of the same version) is possible but requires careful planning. Unfortunately, Odoo does not provide a built-in tool to merge databases automatically — it typically needs to be done manually or using custom scripts.

If you're not comfortable handling this process yourself, you can consider reaching out to Odoo partners like Kanak Infosystems LLP, who offer professional services for database merging, migration, and customization. They can help ensure that your data is consolidated safely and efficiently without breaking dependencies.

Let me know if you need a high-level guide or checklist for the manual merge process.

Thanks!

Avatar
Annuleer
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Beste antwoord

Hi,


Merging two Odoo databases, even when running the same version, is a complex task, and there is no official one-click solution. However, various proven strategies can help you combine data intelligently depending on your needs.


1. Export / Import Selected Data (Simplest):

           - Selectively merging Customers, Products, Sales Orders without disturbing existing data.

   Use built-in CSV/XML export/import:


    Export key models (e.g., res.partner, product.template, product.product, sale.order, account.move).


    Before import, clean and remap IDs, ensuring any references (like partner_id) are updated.


2- Multi-Company Consolidation (Alternative)

           - If the ultimate goal is combining companies rather than merging historical data:                                         - Configure one database as a multi-company instance.

                           - Migrate one DB’s data first.

                           - Then import the other DB’s customers, products, and transactions into the same company structure.

                           - Still requires export/import or scripting, but uses Odoo’s native multi-company architecture.



NOTE:-

           - Back up both databases completely using pg_dump or Odoo tools.

           - Set up a test environment and run the entire merge flow there first.

           - Never operate directly on live databases without tested backups.


Hope it helps

Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
Odoo 17 one2many lines issue
17
Avatar
Avatar
Avatar
Avatar
3
jun. 25
3241
Change resume view Opgelost
17
Avatar
Avatar
Avatar
Avatar
4
jul. 25
1762
Database disappeared from list after activating Google Oauth for administrator
database
Avatar
0
jul. 25
2317
Setup Odoo with specific database
database
Avatar
Avatar
2
nov. 24
8563
Error Loading Custom Odoo Website Snippet: 'View website_video_block in website 1 not found' - Assistance Needed with XML Template Registration
17
Avatar
Avatar
1
nov. 24
2310