Difference between revisions of "Migrate"

From ADempiere ERP Wiki
Jump to navigationJump to search
(Created page with '<div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Migrate</th></tr><tr><td width="20%" align="left"> </td><th width="60%"…')
 
Line 1: Line 1:
<div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Migrate</th></tr><tr><td width="20%" align="left"> </td><th width="60%" align="center"> </th><td width="20%" align="right"> [[Migrate - Introduction|Next]]</td></tr></table><hr></div>
<div class="navheader"><table summary="Navigation header" width="100%"><tr><th align="center" colspan="3">Migrate</th></tr><tr><td align="left" width="20%">&nbsp;</td><th align="center" width="60%">&nbsp;</th><td align="right" width="20%">&nbsp;[[Migrate - Introduction|Next]]</td></tr></table><hr></div>
<b><big>Migrate User Manual</big></b><br><b>Adempiere Migration Tool</b><br>by <span class="firstname">Stefan</span> <span class="surname">Christians</span><br>2011-07-07
<b><big>Migrate User Manual</big></b><br><b>Adempiere Migration Tool</b><br>by <span class="firstname">Stefan</span> <span class="surname">Christians</span><br>2011-07-07


<small><i>This program is part of Adempiere ERP Bazaar<br>http://www.adempiere.org
<small><i>This program is part of Adempiere ERP Bazaar<br>http://www.adempiere.org


Copyright © Stefan Christians
Copyright &copy; Stefan Christians
<br>Copyright © Contributors
<br>Copyright &copy; 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.<br>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.<br>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.
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.<br>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.<br>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.
Line 31: Line 31:




;[[Migrate - Introduction#id2772867|Chapter 1.  Introduction]]
;[[Migrate - Introduction#N1004E|Chapter&nbsp;1.&nbsp; Introduction]]
:[[Migrate - Introduction#id2771400|What is Data Migration?]]
:[[Migrate - Introduction#N10052|What is Data Migration?]]
:[[Migrate - Introduction#id2771532|History]]
:[[Migrate - Introduction#N10096|History]]
:[[Migrate - Introduction#id2771944|Functionality]]
:[[Migrate - Introduction#N10133|Functionality]]
::[[Migrate - Introduction#id2771953|Transfer Mode]]
::[[Migrate - Introduction#N10137|Transfer Mode]]
::[[Migrate - Introduction#id2772063|Upgrade Mode]]
::[[Migrate - Introduction#N10176|Upgrade Mode]]
::[[Migrate - Introduction#id2772113|Putting it all Together]]
::[[Migrate - Introduction#N10186|Putting it all Together]]
::[[Migrate - Introduction#id2772192|Using Migrate for other applications]]
::[[Migrate - Introduction#N101B2|Using Migrate for other applications]]
:[[Migrate - Introduction#id2772293|Process Description]]
:[[Migrate - Introduction#N101F4|Process Description]]
::[[Migrate - Introduction#id2772309|Connect to Databases]]
::[[Migrate - Introduction#N101FC|Connect to Databases]]
::[[Migrate - Introduction#id2772337|Load Meta-Data]]
::[[Migrate - Introduction#N10209|Load Meta-Data]]
::[[Migrate - Introduction#id2772366|Structural Migration]]
::[[Migrate - Introduction#N10216|Structural Migration]]
::[[Migrate - Introduction#id2773459|Data Migration]]
::[[Migrate - Introduction#N102B6|Data Migration]]
::[[Migrate - Introduction#id2773538|Cleanup]]
::[[Migrate - Introduction#N102D0|Cleanup]]
::[[Migrate - Introduction#id2773624|Enforce Constraints]]
::[[Migrate - Introduction#N102F2|Enforce Constraints]]
::[[Migrate - Introduction#id2773669|Close Database Connections]]
::[[Migrate - Introduction#N10303|Close Database Connections]]


;[[Migrate - Marking Customizations#id2773691|Chapter 2.  Marking Customizations]]
;[[Migrate - Marking Customizations#N1030B|Chapter&nbsp;2.&nbsp; Marking Customizations]]
:[[Migrate - Marking Customizations#id2773789|Registering Custom Entity Types]]
:[[Migrate - Marking Customizations#N10337|Registering Custom Entity Types]]
:[[Migrate - Marking Customizations#id2773967|Mark Customizations in the Application Dictionary]]
:[[Migrate - Marking Customizations#N10394|Mark Customizations in the Application Dictionary]]
:[[Migrate - Marking Customizations#id2774054|Mark Customizations in the Change Log]]
:[[Migrate - Marking Customizations#N103C3|Mark Customizations in the Change Log]]


;[[Migrate - Migrating a Database#id2774238|Chapter 3.  Migrating a Database]]
;[[Migrate - Migrating a Database#N10424|Chapter&nbsp;3.&nbsp; Migrating a Database]]
:[[Migrate - Migrating a Database#id2774248|Preperation]]
:[[Migrate - Migrating a Database#N10428|Preperation]]
::[[Migrate - Migrating a Database#id2774256|Disconnect all Users]]
::[[Migrate - Migrating a Database#N1042C|Disconnect all Users]]
::[[Migrate - Migrating a Database#id2774284|Create a Backup]]
::[[Migrate - Migrating a Database#N10439|Create a Backup]]
::[[Migrate - Migrating a Database#id2774344|Install new Adempiere version]]
::[[Migrate - Migrating a Database#N1045D|Install new Adempiere version]]
::[[Migrate - Migrating a Database#id2774390|Import Reference Database]]
::[[Migrate - Migrating a Database#N1047A|Import Reference Database]]
::[[Migrate - Migrating a Database#id2774425|Verify Preconditions]]
::[[Migrate - Migrating a Database#N1048D|Verify Preconditions]]
:[[Migrate - Migrating a Database#id2774492|Running the Migration Tool]]
:[[Migrate - Migrating a Database#N104AA|Running the Migration Tool]]
::[[Migrate - Migrating a Database#id2774615|The User Interface]]
::[[Migrate - Migrating a Database#N104F5|The User Interface]]
::[[Migrate - Migrating a Database#id2772606|Starting from the Command Line]]
::[[Migrate - Migrating a Database#N107DA|Starting from the Command Line]]
:[[Migrate - Migrating a Database#id2778205|Post-Migration Tasks]]
:[[Migrate - Migrating a Database#N109D5|Post-Migration Tasks]]
::[[Migrate - Migrating a Database#id2770449|Warnings]]
::[[Migrate - Migrating a Database#N109E7|Warnings]]
::[[Migrate - Migrating a Database#id2778698|Errors]]
::[[Migrate - Migrating a Database#N10A79|Errors]]
::[[Migrate - Migrating a Database#id2779542|Start the Application Server]]
::[[Migrate - Migrating a Database#N10C63|Start the Application Server]]


;[[Migrate - Compiling and Extending#id2779564|Chapter 4.  Compiling and Extending]]
;[[Migrate - Compiling and Extending#N10C6B|Chapter&nbsp;4.&nbsp; Compiling and Extending]]
:[[Migrate - Compiling and Extending#id2779573|Compiling Migrate]]
:[[Migrate - Compiling and Extending#N10C6F|Compiling Migrate]]
::[[Migrate - Compiling and Extending#id2779611|Requirements]]
::[[Migrate - Compiling and Extending#N10C86|Requirements]]
::[[Migrate - Compiling and Extending#id2779674|Compiling within Adempiere Source Code]]
::[[Migrate - Compiling and Extending#N10CA7|Compiling within Adempiere Source Code]]
::[[Migrate - Compiling and Extending#id2779839|Compiling as Stand-Alone Application]]
::[[Migrate - Compiling and Extending#N10D0D|Compiling as Stand-Alone Application]]
::[[Migrate - Compiling and Extending#id2779933|Building and Running Migrate in Eclipse]]
::[[Migrate - Compiling and Extending#N10D42|Building and Running Migrate in Eclipse]]
:[[Migrate - Compiling and Extending#id2780144|Extending Migrate]]
:[[Migrate - Compiling and Extending#N10DC8|Extending Migrate]]
::[[Migrate - Compiling and Extending#id2780156|Source Files]]
::[[Migrate - Compiling and Extending#N10DCF|Source Files]]
::[[Migrate - Compiling and Extending#id2780863|Adding Languages and Locales]]
::[[Migrate - Compiling and Extending#N10F8A|Adding Languages and Locales]]
::[[Migrate - Compiling and Extending#id2781007|Adding Database Vendors]]
::[[Migrate - Compiling and Extending#N10FE3|Adding Database Vendors]]
::[[Migrate - Compiling and Extending#id2781137|To Do]]
::[[Migrate - Compiling and Extending#N1102A|To Do]]


<div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"> </td><td width="20%" align="center"> </td><td width="40%" align="right"> [[Migrate - Introduction|Next]]</td></tr><tr><td width="40%" align="left" valign="top"> </td><td width="20%" align="center"> </td><td width="40%" align="right" valign="top"> Chapter 1. 
<div class="navfooter"><hr><table summary="Navigation footer" width="100%"><tr><td align="left" width="40%">&nbsp;</td><td align="center" width="20%">&nbsp;</td><td align="right" width="40%">&nbsp;[[Migrate - Introduction|Next]]</td></tr><tr><td valign="top" align="left" width="40%">&nbsp;</td><td align="center" width="20%">&nbsp;</td><td valign="top" align="right" width="40%">&nbsp;Chapter&nbsp;1.&nbsp; Introduction</td></tr></table></div>
Introduction
</td></tr></table></div>

Revision as of 04:45, 23 September 2011

Migrate User Manual
Adempiere Migration Tool
by Stefan Christians
2011-07-07

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