Installing or Updating the Inventory Management Database

  1. Install the Inventory Management Database Updater on the database server:
    1. Download and extract the installation archive to the database server, double-click setup.exe, and then follow the installation wizard instructions.
    2. On the Choose Database Connection page, enter any connection name, as the name can be changed in a later step. Ignore the Warning message on the next page.
  2. Navigate to root\Program Files\Inventory Management Database Maintenance\ and open sql.config in a text editor:
    1. Add additional server names and SIDs if necessary. The values in bold are specific to your environment:

      <servers>

      <server name="servername”><DbBrand value="SQLSERVER” />

      <ServiceName value="MSSQL server instance” />

      </server>

      </servers>

      <servers>

      <server name="servername”><DbBrand value="ORACLE” />

      <ServiceName value="ORACLE server instance” />

      </server>

      </servers>

  3. Navigate to root\Program Files\Inventory Management Database Maintenance\ and open fmlogini.ini in a text editor:
    1. Add or configure a section for [orgshortname]:

      [orgshortname]

      DBLogin=server name/orgshortname/password,orgshortname ,myinvenMenu.ini

      AppIINI=settings.ini

    2. If you are performing parallel database updates, you can set the maximum number of parallel updates by adding or setting the following lines:

      [BatchUpdate]

      MaxThreads=number of threads

      Depending on your hardware configuration, enter a value between 10 and 30.

  4. Use the Database Updater to install or update the database with the required tables, columns, and views:
    1. From the Microsoft Windows desktop, double-click Single Database, and then log in using your Inventory Management administrator credentials.
    2. On the Settings tab, select the Daily Totals setting for the database.
    3. On the Database Update tab, click Update Database to insert the tables, columns, and views. Verify that the update completes without errors.
    4. Click Reorganization to add and remove database procedures and functions. Verify that the update completes without errors.

Related Topics