Development Environment Setup - Schema

Development schema is different from schema created from an official release as it is not finalized yet. So, please make sure development schema is only used for testing/development purpose.

There are two ways to create a development schema:

1) Create from kwok-schemasetup project.

From kwok-schemasetup project, run build.bat or "C:\Kwok\Server\apache_ant_1.7.0\bin\ant clean dist". This creates a kwok-schema-<version>-dev.jar in dist\database folder.

Then, use the jar file to create a brand new schema, e.g.

<path to java>\bin\java -jar kwok-schemasetup-<version>.jar install database=<database name> username=<database user> password=<database password>

See User Guide for details.

2) Upgrade from an existing schema:

- First, backup a current schema using pgAdmin's backup option (or use pg_dump command, not covered here)

- Then, create a new database and restore the backup using pgAdmin's restore option

- Upgrade the database using the jar file (WARNING: Do not upgrade any production database using schemasetup jar intended for development purpose)

e.g.

<path to java>\bin\java -jar kwok-schemasetup-<version>.jar upgrade database=<database name> username=<database user> password=<database password>