Installing Inventory Management on Microsoft SQL Server

This chapter describes the prerequisites and instructions for installing the Inventory Management database on Microsoft SQL Server:

Parent topic: Inventory Management

Preparing Microsoft SQL Server for Inventory Management

  1. Start MSSQL Server Management Studio and log into the database server.
  2. Create the Inventory Management database:
    1. Start MSSQL Server Management Studio and log into the database server.
    2. Find the organization short name in COREDB.CORE_ORGANIZATION.organizationShortName.
    3. Right-click Databases and click New Database. Change the name of the database to the organization short name.
  3. If you want to restore the database from a backup:
    1. Right-click Databases, click Tasks, click Restore, and then click Database.
    2. Enter the organization short name in To database.
    3. Select From device, click Browse, and then navigate to and select the .bak file.
    4. Select Overwrite the existing database, and then enter the filepath and filename to which the database files restore.
    5. Select Leave the database ready to use by rolling back..., and then click OK.
  4. Secure the database:
    1. Right-click Security, and then click New.
    2. Enter the organization short name in Login name.
    3. Select SQL Server authentication and enter a password.
    4. Deselect Enforce password policy.
    5. Click Server Roles and verify that dbcreator and sysadmin are selected.

Parent topic: Installing Inventory Management on Microsoft SQL Server

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\myinventory Database Updater\ and open sql.ini in a text editor:
    1. Find the section [win32client.dll] and verify the following line:

      comdll=sqlodb32

    2. Add the following lines to the end of the file:

      [odbcrtr]

      remotedbname=orgshortname,DSN=orgshortname

    3. Update the server name and SIDs:

      <servers>

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

      <ServiceName value=”MSSQL server instance” />

      </server>

      </servers>

  3. Navigate to root\Program Files\myinventory Database Updater\ 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.
  5. Log in to the database and enter the following command to add an index to the DAILYTOTALS database. If you are upgrading a database with a large number of records, work with a database administrator to schedule the update because of the amount of time required by the operation.

    create index DAILYTOTALS_fk_ART_ID on DAILYTOTALS ( ART_ID );

Related Topics

Parent topic: Installing Inventory Management on Microsoft SQL Server