[OOZIE-631] Oozie DB create/upgrade tool

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.2.0
• Assignee: Alejandro Abdelnur
• Reporter: Alejandro Abdelnur
• Created: 08/Dec/11 14:29
• Updated: 06/Jun/12 23:40
• Resolved: 01/Mar/12 21:36

Description

By default creating Oozie database done automatically by Oozie.

While this is convenient for developers, it is not acceptable when setting up a production system.

A tool to create the DB should be provided.

Similarly, upgrading Oozie DB should be supported by such tool.

This should work for all supported DBs.

Currently upgrading Oozie DB is a manual process, not properly documented and the SQL scripts for it work only with Oracle.

A more generic mechanism using OpenJPA schematool should be available.

This could be done with a tool that would indicate if the DB needs to be upgraded, can be upgrade and upgrades/migrates it. The tool would take a currentVersion and a targetVersion of Oozie plus the JDBC information.