Initialize the ADempiere Database

From ADempiere
Revision as of 12:50, 3 January 2007 by Afalcone (Talk)

Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

WORK IN PROGRESS - Alejandro 01/04/07

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:

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 ==

CD Run ImportAdempiere.PNG

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.

CD Run ImportAdempiere2.PNG

At the process end, you should see: no (error) rows selected

CD Run ImportAdempiere3.PNG

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