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:
- Find your TP Admin client version by going to Help menu and click About Training Partner.
- Your version number is actually both your Version and Build numbers. In the example below, your version number will be 2007.1.1.809
- Open up Microsoft SQL Server Management Server or Query Analyzer
- 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