Home > Software Downloads > Update Shared Database and Software

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 2011 Q4 version.

    Script to update from 2011 Q3 to 2011 Q4

    If necessary, you should first run the following scripts to update from a version which is older than 2011 Q3.

    Script to update from 2011 Q2 to 2011 Q3

    Script to update from 2011 Q1 to 2011 Q2

    Script to update from 2010 Q4 to 2011 Q1

  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.

  8. Determine if you have Microsoft .Net 4 Framework installed. If it is not installed, download and install the Microsoft .Net 4 Framework.

    (Contact your IT support if you have questions about this step.)

    9. A. Update Utility


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

    B. Manual Update


    • STEP 1: Update the ECMPS Update Utility:

      • Save and unzip the file to the ECMPS folder (which is C:\Program Files\ECMPS, by default)

      • Click "Yes" when prompted to overwrite the existing file

    • STEP 2: 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 2011_Q4.xml file

      • Click the Perform Update button

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