Migrate

From ADempiere ERP Wiki

Jump to: navigation, search

Migrate User Manual
Adempiere Migration Tool
by Stefan Christians
2012-11-12

This program is part of Adempiere ERP Bazaar
http://www.adempiere.org

Copyright © Stefan Christians
Copyright © Contributors

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

Contributors: Stefan Christians
Sponsors: K.K. Alice

Adempiere is a registered trademark of Adempiere, Inc.
All other company or product names are mentioned for identification purposes only, and may be trademarks of their respective owners.


Tool for Upgrading, Transferring, or Converting Databases

While tools such as migration scripts for upgrading or DDLUtils for converting databases are suitable for Adempiere's application developers to maintain the seed database, they are a bit challenging for the average user to maintain their live database.

Migrate provides a graphical user interface for upgrading databases.

It can also be used for converting between database vendors (like Oracle and postgreSQL) or applications (like Compiere and Adempiere).



Chapter 1.  Introduction
What is Data Migration?
History
Functionality
Transfer Mode
Upgrade Mode
Putting it all Together
Using Migrate for other applications
Process Description
Connect to Databases
Load Meta-Data
Structural Migration
Data Migration
Cleanup
Enforce Constraints
Close Database Connections
Chapter 2.  Marking Customizations
Registering Custom Entity Types
Mark Customizations in the Application Dictionary
Mark Customizations in the Change Log
Chapter 3.  Migrating a Database
Preperation
Disconnect all Users
Create a Backup
Install new Adempiere version
Import Reference Database
Verify Preconditions
Running the Migration Tool
The User Interface
Starting from the Command Line
Post-Migration Tasks
Warnings
Errors
Start the Application Server
Chapter 4.  Compiling and Extending
Compiling Migrate
Requirements
Compiling within Adempiere Source Code
Compiling as Stand-Alone Application
Building and Running Migrate in Eclipse
Extending Migrate
Source Files
Adding Languages and Locales
Adding Database Vendors
To Do
Personal tools