Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Upgrade Considerations

  1. Last updated
  2. Save as PDF
Upgrade Considerations
This page houses all of the instructions for upgrading your Lawtrac instance.

Mitratech continually strives to produce the best ELM products on the market; as we improve Lawtrac, database updates may be necessary. However, not all releases will require database updates or upgrade instructions. This page details the upgrade path that should be taken when upgrading your Lawtrac instance. 
 

 

IMPORTANT NOTE: Only run the Internal Upgrade Scripts (Step 6) if you are upgrading from a version prior to 4.0. 

 

 

Download the PDF version of these instructions here.

Steps to Upgrade

It is important to begin this process from the script that is equal or nearest to your current Lawtrac version. For example, clients on Lawtrac 4.0.2 would start at LT401to405.

  1. Take a backup of your existing Lawtrac database (i.e., XXXLegal).
  2. Run the Lawtrac Installer for the version you are upgrading to. For example, if a client is upgrading to Lawtrac 4.2 they would run the Lawtrac 42 Installer.
  3. Follow the steps outlined on the Installing Lawtrac page.
  4. Locate the scripts/upgrade directory within the Lawtrac4X root directory on your web server and update the existing DB by running the following scripts in the order seen in the Upgrade Scripts list below.

    Note: The scripts below should be executed in the order they appear. Not all scripts will be used when upgrading. The .sql scripts referenced in the instructions below can be found in the Lawtrac Root Directory under the Scripts > Upgrade folder on your web server. Follow the steps listed above to upgrade your Lawtrac instance. 

    List of Upgrade Scripts
    LT_37to40.sql
    LT_40to401.sql
    LT_401to405.sql
    LT_405to407.sql
    LT_407to408.sql
    LT_408to409.sql 
    LT_409to412.sql
    LT_412to42.sql
    LT_42to421.sql
    LT_421to422.sql
    LT_422to43.sql
    LT_43to431.sql
    LT_431to432.sql
    LT_432to433.sql
    LT_433to434.sql
    LT_434to435.sql
    LT_435to437.sql
    LT_437to438.sql
    LT_438to439.sql
    LT_439to440.sql
    LT_440to441.sql
    LT_441to442.sql
    LT_442to443.sql
    LT_443to444.sql
  5. Access the respective starting script and run it against your Lawtrac database in the SQL Server Management Studio. Repeat this process until you have upgraded to the desired version of Lawtrac. 

  6. If upgrading from a version prior to 4.0 follow the path below to run the Internal Upgrade Script:

    My Lawtrac | Application Administration | Application & Database | Database Administration and click the Run Upgrade Scripts link.

    Once complete, the script window displays the number of tables that need to be examined and the tables that were already examined. Both values should be the same (i.e., 285 Tables to Examine (285).

 

This completes the upgrade process. If you require assistance with the upgrade process, please contact Mitratech's Lawtrac Support department at Support@mitratech.com or +1 888-784-7224. 

Considerations & Exceptions 

  • Contact Support if you are upgrading from Lawtrac 4.1.0 or Lawtrac 4.1.1.
  • If you are upgrading from a 4.1.2 Patch 1-8 to Lawtrac 4.2, see the instructions below that best fit your needs.

 

 

Upgrading to 4.2 from 4.1.2 Patches

The following section details the upgrade process of upgrading from Lawtrac 4.1.2 Patch 1-8 to Lawtrac 4.2. The .sql scripts referenced in this procedural can be found in the LAWTRAC42 root directory under scripts > upgrade folder on your web server. Please locate the instructions that best reflect your current version of Lawtrac.

It is important to begin this process from the script that is equal or nearest to your current Lawtrac version. For example, clients on Lawtrac 4.0.2 would start at LT401to405.

Clients upgrading from 4.1.2 Patch 1 

  1. Take a backup of your current Lawtrac database (i.e., XXXLegal).
  2. Run the Lawtrac 42 Installer.
  3. Follow the steps outlined on the Installing Lawtrac page.
  4. Locate the scripts/upgrade directory within the Lawtrac42 Installer root directory on your web server, and update the existing 4.1.2 DB by running the following scripts against your LAWTRAC database in the SQL Server Management Studio:
  • Access the Lawtrac412Patch2SQLScript.sql script and run it
  • Access the MSSQL_Lawtrac_412_Patch5.sql script and run it
  • Access the LT_412P5to42.sql.sql script and run it

Once these scripts have been executed, log into the Lawtrac 4.2 instance as a Lawtrac administrator.

Navigate to My Lawtrac | Application Administration | Application & Database | Database Administration and click the Run Upgrade Scripts link.

Once complete, the script window displays the amount of tables to be examined and the tables that were already examined. The value should be the same for both (i.e., 285 Tables to Examine (285).

This completes the upgrade to Lawtrac 4.2.

Clients upgrading from 4.1.2 Patch 2, 3, or 4 

  1. Take a backup of your current Lawtrac database (i.e., XXXLegal).
  2. Run the Lawtrac 42 Installer.
  3. Follow the steps outlined on the Installing Lawtrac page.
  4. Locate the scripts/upgrade directory within the Lawtrac42 Installer root directory on your web server, and update the existing 4.1.2 DB by running the following scripts against your LAWTRAC database in the SQL Server Management Studio:
  • Access the MSSQL_Lawtrac_412_Patch5.sql script and run it
  • Access the 412P5to42.sql script and run it

Once these scripts have been executed, log into the Lawtrac 4.2 instance as a Lawtrac administrator.

Navigate to My Lawtrac | Application Administration | Application & Database | Database Administration and click the Run Upgrade Scripts link.

Once complete, the script window displays the amount of tables to be examined and the tables that were already examined. The value should be the same for both (i.e., 285 Tables to Examine (285).

This completes the upgrade to Lawtrac 4.2.

Clients upgrading from 4.1.2 Patch 5, 6, 7, or 8 

  1. Take a backup of your current Lawtrac database (i.e., XXXLegal).
  2. Run the Lawtrac 42 Installer.
  3. Follow the steps outlined on the Installing Lawtrac page.
  4. Locate the scripts/upgrade directory within the Lawtrac42 Installer root directory on your web server, and update the existing 4.1.2 DB by running the following scripts against your LAWTRAC database in the SQL Server Management Studio:
  • Access the 412P5to42.sql script and run it

Once these scripts have been executed, log into the Lawtrac 4.2 instance as a Lawtrac administrator.

Navigate to My Lawtrac | Application Administration | Application & Database | Database Administration and click the Run Upgrade Scripts link.

Once complete, the script window displays the amount of tables to be examined and the tables that were already examined. The value should be the same for both (i.e., 285 Tables to Examine (285).

This completes the upgrade to Lawtrac 4.2.

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Article type
    Guide
  2. Tags
    1. lawtrac
    2. upgrade
    3. upgrade scripts