Initialize the ADempiere Database
WORK IN PROGRESS - Alejandro 01/04/07
Contents
README
- Further requests for assistance please direct to the HELP Forum. This wiki provides only written and publishable support.
- Further private, local, or commercial assistance can be sought at World-wide Directory where consultants all over register themselves. The fee charges are up to the respective consultants and under their own responsilibity or control.
- Please adhere to our bazaar etiquette to enjoy better support from us.
Introduction
This Create Database HELP is for create the database for your ADempiere installation. After this you can Complete ADempiere Server Install.
Pre-requisite Utilities
Before starting with the database creation, you should have the following installed:
- Database supported by ADempiere
- Java JDK1.5.x
- ADempiere Server Installation
Start with Database Creation
The ADempiere initial database is into the Adempiere.dmp file, located at $ADEMPIERE_HOME/data directory; this file contains the seed database for your ADempiere installation. To start, open a console window and go to this directory. Verify the Adempiere.dmp file is located there.
Oracle
Run the script RUN_ImportAdempiere (.bat or .sh). You will see information about adempiere.dmp file (such as date creation, size, etc.) and the message: == The import will show warnings. This is Ok ==
Press any key to start the process or Ctrl-C to cancel.
No worry if you see some warnings (such as Warning: object created with compilation warnings) ; this is normal and you can ignore it. After the import program, a SQL procedure makes sure that everything is imported correctly and will list all invalid objects if they exists.
At the process end, you should see: no (error) rows selected
PostgreSQL
Notes
- Be careful: the script RUN_AdempiereImport DROP the database, so if you run the script all your datas will be losed!. Don't execute this script if you have data and you need for them