Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Odoo to Odoo data migration tools

by
Open for Small Business, Graeme Gellatly
- 15/10/2019 19:36:06
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

Reference