Steps of Database Deployment

Prior to successfully starting the application itself, an initial database schema has to be created. Besides the application war file ( RegistryCxn.war ) a zip package (e.g. RegistryCxn.zip ) is provided that contains a script responsible for creating the DB.

Extract the zip file into a selected folder.
Make sure that the location of the registry.properties file containing the DB connectivity information is referred by the environment variable REGISTRYCXN_HOME.
Start ./RegistryCxn bash script or RegistryCxn.bat in the RegistryCxn/bin folder of the extracted content (depending on the OS type). The following are available:

 -disableGlobalProjectAccess   together with sqldeploy, disables global
                               project access rights
 -dropSchema                   drops all database objects from
                               registration schema
 -dropSchemaDS                 drops all database objects from downstream
                               schema
 -help                         print this help summary
 -migrateSchema                create or upgrade database objects in
                               registration schema
 -migrateSchemaDS              create or upgrade database objects in
                               downstream schema
 -schemaInfo                   prints informations about the registration
                               schema
 -schemaInfoDS                 prints informations about the downstream
                               schema

In order to create an initial DB schema or clean an existing one completely, please use the following command line:

./RegistryCxn -migrateSchema
./RegistryCxn -dropSchema -migrateSchema

Since version 16.09.05-917:

./RegistryCxn install -migrateSchema
./RegistryCxn install -dropSchema -migrateSchema