Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Odoo to Odoo data migration tools

Archives

Contributors

XSLT for Odoo Studio

Becoming a PSC of OCA/storage

Odoo to Odoo data migration tools

Hello,

 

I have more than one customer request to merge several single-company databases into a single multi-company database.

The usual approaches all mean some level of data loss.

 

Since the database schemas are the same, I’m wondering if it would be feasible to have a tool that would copy the data at the database level, while properly handling the record ids conversion.

 

I’ve worked before with a tool that deal with that kind of problem – Anybox’s Anygrate.

So I could have a try at a second generation of that tool.

 

I wonder about other ideas?

 

Thanks

Daniel Reis

 

by Daniel Reis <dreis.pt@hotmail.com> - 03:51 - 15 Oct 2019

Follow-Ups

  • Re: Odoo to Odoo data migration tools
    Hi all,

    We have simple library that allows to transfer data between Odoo databases via XML-RPC or JSON-RPC.
    All you need is to define transfer schema and run data-transfer.
    It was used to transfer data (sales and purchases) from Odoo 7.0 to Odoo 9.0

    This library is available here: https://github.com/crnd-inc/odoo-transfer-lib

    вт, 15 жовт. 2019 о 20:42 Graeme Gellatly <gdgellatly@gmail.com> пише:
    The first generation would be fine of anygrate IF there arent too many duplicate records requiring discrimination you could get it all done in a just a few attempts. Config file the lot. I have an advanced fork of it somewhere optimized for speed and this kind of case, although I never tried it for merging multiple companies it should work.

    Main issue will be computed tree fields and sequences which will have to be dropped and recreated. Plus id sequences bumped. Ir property can also be a bit tricky. 

    On Wed, 16 Oct 2019, 2:51 AM Daniel Reis, <dreis.pt@hotmail.com> wrote:

    Hello,

     

    I have more than one customer request to merge several single-company databases into a single multi-company database.

    The usual approaches all mean some level of data loss.

     

    Since the database schemas are the same, I’m wondering if it would be feasible to have a tool that would copy the data at the database level, while properly handling the record ids conversion.

     

    I’ve worked before with a tool that deal with that kind of problem – Anybox’s Anygrate.

    So I could have a try at a second generation of that tool.

     

    I wonder about other ideas?

     

    Thanks

    Daniel Reis

     

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by dmytro.katyukha - 11:41 - 16 Oct 2019
  • Re: Odoo to Odoo data migration tools
    The first generation would be fine of anygrate IF there arent too many duplicate records requiring discrimination you could get it all done in a just a few attempts. Config file the lot. I have an advanced fork of it somewhere optimized for speed and this kind of case, although I never tried it for merging multiple companies it should work.

    Main issue will be computed tree fields and sequences which will have to be dropped and recreated. Plus id sequences bumped. Ir property can also be a bit tricky. 

    On Wed, 16 Oct 2019, 2:51 AM Daniel Reis, <dreis.pt@hotmail.com> wrote:

    Hello,

     

    I have more than one customer request to merge several single-company databases into a single multi-company database.

    The usual approaches all mean some level of data loss.

     

    Since the database schemas are the same, I’m wondering if it would be feasible to have a tool that would copy the data at the database level, while properly handling the record ids conversion.

     

    I’ve worked before with a tool that deal with that kind of problem – Anybox’s Anygrate.

    So I could have a try at a second generation of that tool.

     

    I wonder about other ideas?

     

    Thanks

    Daniel Reis

     

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by Graeme Gellatly - 07:40 - 15 Oct 2019