Database (SQL) patching tool for Endeavour Health projects.
Supports Postgresql. MySQL support to be added.
------------------------------------------------------------
DBPatcher v1.0
------------------------------------------------------------
usage: java -jar DBPatcher.jar DB_XML_FILE [options]
or: java -jar DBPatcher.jar ZIP_FILE [options]
options: --host=hostname Override hostname in DB_XML_FILE
--port=port Override port in DB_XML_FILE
--db=dbname Override databasename in DB_XML_FILE
--user=username Override username in DB_XML_FILE
--pass=password Override password in DB_XML_FILE
--xml=DB_XML_FILE Specify DB_XML_FILE file name in root of
ZIP file; default database.xml
--dropfns Prompts to drop all functions before
applying fns in DB_XML_FILE
--autodropfns Automatically drops all functions before
applying fns in DB_XML_FILE
--generatesamplexml Write sample DB_XML_FILE file
--help Print this message
<Database>
<DisplayName>sampledb</DisplayName>
<DatabaseType>postgresql</DatabaseType>
<Connection>
<!-- note: connection details passed via command line take precedence -->
<Hostname>localhost</Hostname>
<Port>5432</Port>
<DatabaseName>sampledb</DatabaseName>
</Connection>
<Paths>
<Schema>schema</Schema>
<Functions>functions</Functions>
<Scripts>scripts</Scripts>
</Paths>
</Database>