Update the Inventory Management Database

  1. Create folder DBMaintenance at <drive>:\IMSetup\v91Backup.
  2. Back up FMLOGIN.INI and sql.config from the myinventory Database Maintenance installation path to <drive>:\IMSetup\v91Backup\DBMaintenance.
  3. Uninstall myinventory Database Maintenance by navigating to the Control Panel and then click Uninstall Program.
  4. Unzip <date>_HIM_DBMaintenance(64-bit)_9.1.0.xxx.xxxx.zip in <drive>:\IMSetup\Patch91x. Use the appropriate 32-bit or 64-bit version for your system and for the Oracle Client.
  5. Install the Database Maintenance application by running the setup.exe in <drive>:\IMSetup\Patch91x\<date>_HIM_DBMaintenance(64-bit)_9.1.0.xxx.xxxx. During the install, enter the Oracle Instance name.
  6. Copy the backed up FMLOGIN.INI and sql.config files to the Database Maintenance installation path
  7. To run a single database, either navigate to the installation directory and run DatabaseUpdater.exe or from the desktop run Oracle MICROS Inventory Management Single Database Maintenance. To run a batch update, navigate to the installation directory and run UpdateOrg.exe or from the desktop run Oracle MICROS Inventory Management Single Database Maintenance.
    1. If Single Database, sign in to the organization to update.
    2. Click Settings and then select Daily Totals for the database.
    3. Click Database Update and then select Database Update to insert the tables, columns, and views. Verify that the update completes without errors.
    4. Select Reorganization to add and remove database procedures and functions. Verify that the update completes without errors.