Training Partner – Rollback to previous version

The following is not recommended in a production environment.  Please test thoroughly if using in a production  as there are some macro differences between TP versions.

Training Partner stamps your database with the TP Admin client version to ensure the database and the version of the client are in sync. This is important since there can be incompatibilities between TP versions and the database schema.

Sometimes, the database and the TP Admin client get out of sync, either by accident or through testing another version of TP against the database. It is always recommended that you test different version of TP against copies of your database to avoid this issue.

Need to Reset Database Version Only

If you have already have the TP files installed, you simply need to reset the database version number as below:

  1. Find your TP Admin client version by going to Help menu and click About Training Partner.
  2. Your version number is actually both your Version and Build numbers. In the example below, your version number will be 2007.1.1.809
    About Training Partner
  3. Open up Microsoft SQL Server Management Server or Query Analyzer
  4. Connect to your TP database

SELECT * FROM ITEMS
WHERE ITEMTYPE=’DEFAULT’ AND ITEMKEY=’TP2000VERSION’

UPDATE ITEMS
SET NAME=’2007.1.1.809′
WHERE ITEMTYPE=’DEFAULT’ AND ITEMKEY=’TP2000VERSION’

SELECT * FROM ITEMS
WHERE ITEMTYPE=’DEFAULT’ AND ITEMKEY=’TP2000VERSION’

Rolling back to a previous version of TP is not hard if you have all the pieces:

  • TP executable
    Depending on your version of TP: TrainingPartner.exe or TP2005.exe
  • TP License file
    Depending on your version of TP: TPLicense.dll or TP2005License.dll
This entry was posted in Training Partner and tagged , . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*