Perform the database upgrade procedure
If your update requires a database upgrade, you must run aPriori's database upgrade or patch script against every aPriori schema in your existing database. (For testing purposes, the testing schemas are initially COPIES of your production schemas that you created in the "Prepare for the upgrade" section.)
If you are upgrading to 2019 R2 (19.2.x.x) from any 2019 R1 release (19.1.x.x) you must run the upgrade script.
The upgrade script is in the following location of the new aPriori installation:
<apriori_install>\bin\updateDB.cmd
The scripts take the following arguments:
• /dbflavor – Either mysql, oracle, or sqlserver. If oracle is specified, one of the following sub-arguments is required:
{/sid <sid>|/servicename <servicename>}
• /h – The host name of the server where the database is located.
• /P – The port used by the database (typical values are 3306 for MySQL, 1521 for Oracle, 1433 for SQL Server).
• /schemaname – The aPriori schema to be upgraded.
• /user – A database user account with privileges to modify the aPriori schema.
• /password –The password for the privileged database user account for modifying the aPriori schema.
Run the upgrade script
1 From the command line, navigate to the bin directory of the test aPriori installation and run the database upgrade script against your old schema(s):
updateDB.cmd /dbflavor [mysql|
{oracle {/sid <sid>|/servicename <servicename>}}|sqlserver]
/h <hostname> /P <port> /schemaname <schemaname>
/user <user> /password <password>
For example, for an Oracle database upgrade, the command lines might be similar to
cd apriori_<vers>\bin
updateDB.cmd /dbflavor oracle /servicename orcl.acme.com /h testhost01 /P 1521 /schemaname apdb1
/user apadmin02 /password k73M06nn!
The above is only an example. Make sure to substitute valid arguments for your particular situation. The script displays "updateDB complete" when done.
2 If you have multiple schemas, repeat the previous step for each schema that needs to be updated.