Skip to Content

Odoo Data Migrator

by
Odoo

$ 42.20

v 19.0 Third Party
Versions 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 2366
Technical Name oe_odoo_data_migrator
LicenseOPL-1
Websitehttps://odooerp.ae/
Versions 17.0 18.0 19.0

Key Features

Safely migrate and merge data from any PostgreSQL database into your Odoo instance with intelligent dependency handling and ID remapping

Direct PostgreSQL Connection

Connects directly to any source PostgreSQL database using psycopg2 for fast and reliable data transfer.

Automatic Dependency Resolution

Automatically orders tables based on foreign key dependencies to ensure data integrity during migration.

Smart FK Remapping

Automatically remaps foreign keys using ID mapping tables and handles Many2Many relation tables.

Incremental Migration

Migrate only new or modified records using cutoff dates based on create_date or write_date.

Dry Run Mode

Test your migration configuration safely without making any changes to the destination database.

Update Existing Records

Automatically detects and updates records that already exist instead of skipping them.

Comprehensive Logging

Full audit trail with detailed logs for every action, including errors and skipped records.

Batch Processing

Configurable batch size for optimal performance and memory usage during large migrations.

Sequence Synchronization

Automatically synchronizes sequences after migration and handles unique constraint violations intelligently.

Migration Configuration
Migration configuration form with source database settings
Migration Settings
Migration settings including cutoff date, batch size and dry run
Table Selection
Optional table selection for partial migrations

User guide

Safely migrate data from any PostgreSQL database into Odoo with full control and detailed logging.

1. Install the module

  1. Copy the oe_odoo_data_migrator folder to your Odoo addons directory.
  2. Install psycopg2-binary via pip.
  3. Update Apps List and install Database Migration Tool.

2. Create Migration Configuration

  1. Go to Database Migration from the main menu.
  2. Click Create and give your configuration a name.

3. Configure Source Database

  1. Fill in Source DB Host, Port, Name, User and Password.
  2. Click Test Connection to verify.

4. Set Migration Options

  1. Configure Cutoff Date, Batch Size, Dry Run, and other settings.
  2. Enable Dry Run for testing first.

5. Run the Migration

  1. Review all settings carefully.
  2. Click Start Migration.
  3. Monitor progress in the Logs tab.

6. Review Results

  • Check detailed logs for migrated records, skipped items, and errors.
  • Review ID mappings and sequence synchronization status.
  • Always backup your destination database before running a live migration.

Frequently Asked Questions

1. Does it support incremental migration?
Yes. You can set a Cutoff Date and choose between create_date or write_date to migrate only newer or modified records.
2. Is the source database modified?
No. The module only reads from the source database. All writes happen only in the destination Odoo database.
3. What happens if a record already exists?
The module automatically updates existing records instead of skipping them. ID mapping tables help track migrated data.
4. Should I use Dry Run first?
Yes. Always run a Dry Run first to validate your configuration and see what will be migrated without making any changes.
5. Does it handle foreign keys automatically?
Yes. It resolves table dependencies, remaps foreign keys, and handles Many2Many tables automatically.
6. Is it safe for production use?
Yes. It includes multiple safety features: Dry Run, savepoint isolation, detailed logging, and admin user protection.
Module Support & SLA
For support related to this module, contact apps@odooerp.ae
Standard response time (SLA) for support queries is typically 1 to 2 working days.
+971 54 289 8664 Email Us
Oakland partner and services
Support and contact information
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 2366
Technical Name oe_odoo_data_migrator
LicenseOPL-1
Websitehttps://odooerp.ae/ 
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

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 or have a question related to your purchase, please use the support page.
by
Toufeequrrahman
on 7/3/26, 8:12 AM


There are no comments yet!