Software Download Icon

Update Shared Database and Software

Steps to be taken by the Database Administrator (DBA):

  1. Follow these steps exactly. If you encounter any problems, immediately contact technical support.

  2. Verify that you have SQL Server Native Client installed.

  3. In each folder where the Client Tool is saved (which is C:\Program Files\ECMPS, by default), verify that there are two folders named "Update" and "Downloads". If they do not exist, create them.

  4. Back up the three ECMPS Client Tool databases on the shared network ECMPS Client Tool database server: ECMPS, ECMPS_WS, and ECMPS_AUX.

  5. Close all Client Tools connected to the shared network database.

  6. Run the following script to update the database to the 2010 Q2 version.

    IMPORTANT: If you have not updated your Client Tool database since 2009 Q3, do not run the following script. Contact technical support for assistance with updating.

    Run Script to update from 2010 Q1 to 2010 Q2

  7. Update each Client Tool that is connected to the database using the Update Service (see Section A below) or manually (see Section B below).

    NOTE: The manual update is for users who do not have a login.

    A. Update Utility


    • STEP 1: Login to each Client Tool and click OK when prompted to update.

    B. Manual Update


    • Step 1: Download the 2010 Q2 Client Tool Update Utility:

    • STEP 2: Extract the zipped files to the ECMPS folder (which is C:\Program Files\ECMPS\, by default)

    • STEP 3: Update each Client Tool connected to the shared network database:

      • Save the two files to the ECMPS Update folder (which is C:\Program Files\ECMPS\Update, by default)

      • Navigate to Start | All Programs | ECMPS | ECMPS Client | ECMPS Update Utility

      • Select the 2010_Q2.xml file

      • Click the Perform Update button

      For additional assistance with the update, click the links below: