Thursday, 11.March LAT | ENG
Data migration module group PDF E-mail

Description

This module group is intended to automate data migration between two OpenERP databases. These modules allow to automate data structure analysis on both databases, and move the data from one database to another. This tool is intended for use by skilled OpenERP developers/administrators.

Possible uses of these modules would be migration from old TinyERP 4.2 setup to the newer OpenERP 5.0. server. Data migration between two OpenERP 5.0. databases, when huge amounts of data should be moved, but manual input is not an option.

Possible combination would be:

  1. "4.2." as donor and 5.0. as the receiver;
  2. "5.0" as donor and "5.0" as the receiver;

Before you begin migration.

Note, that it is strongly recommended to try these modules on a backup copies of the server and databases, not the production setup. And remember that backup is the best friend of administrator, do them as frequently as possible. These modules are at active development and structure may be modified without prior notice.

We will try to provide generic support on this module on our forum.

Contents of module group.

  1. Module "server_migration" - main functionality;
  2. Module "server_migration_config_data" - ready module mappings if you want to move data migration mappings created in one database to another. This is helpful if you want to reuse your work on several databases. For example, you may want to reuse migration mappings for the common modules such as Partners and several other base models.
  3. Module "server_migration_demo_data" - holds demo data in order to better understand how to create model mappings. Model mappings in this module - Partners, Partner Address, Partner Categories, Banks, Users Tasks, Task Works, Projects.

Migration process.

Generic procedure of migration (real life case would require other actions too):

  1. Create a new 5.0.x database;
  2. Install migration module to the newly created (1.step) database;
  3. Set the connection parameters in "Administration/Server Migration/Connect to the old server", where the old server could be reached;
  4. Check the modules installed on the new server. For automation purposes there are wizard available - "Administration/Server Migration/Compare New and Old server's modules";
  5. Install all missing modules on the new database;
  6. Create Mappings for the data models in "Administration/Server Migration/Model mapping";
  7. You may want to create backup of the new database, because you will probably repeat steps over and over again until you get desired result;
  8. Schedule migration "Administration/Server Migration/Create Migration Scheduler";
  9. Inspect data migration process in the "Administration/Server Migration/Scheduled Migrations".
 
Copyright © 2001 KN dati SIA, ALL RIGHTS RESERVED