Upgrading From Versions < 4.0

What's new in:
Desktop Helpdesk Software v4.0
Web Helpdesk Software v4.0
Mail-in Server v4.0

Program

Download and install the trial version of the appropriate helpdesk software.

IMPORTANT: You should install the new version to a different folder to your existing version, then follow the instructions below for converting your database(s).

Database conversion

We have included in the Desktop Helpdesk, code which will convert data held in the Access database used by previous versions of either the Web or Desktop helpdesk. Oracle and Sql Server databases can be converted by running the supplied Sql scripts. For conversion of your particular database, please see below:

LBE Desktop Helpdesk 3.1 Database:
Download and install LBE Desktop Helpdesk Version 4 and run it against your database. It will automatically update the database. Please make sure no one else is using the helpdesk whilst it is trying to convert it. Please note, the automatic process will not convert the database to Access 2000 format, you can do this manually yourself by opening it in MS Access 2000 after the initial conversion.

LBE Desktop Helpdesk < 3.1 Database (including Free Helpdesk):
Please zip up your database and forward to LBE for conversion. If you do so on e.g. Friday evening we will have the database back to you for start of business on the following Monday.

Web Helpdesk Access database
Download and install LBE Desktop Helpdesk Version 4 and run it against your database. It will automatically update the database. Please make sure no one else is using the helpdesk whilst it is trying to convert it. Please note, the automatic process will not convert the database to Access 2000 format, you can do this manually yourself by opening it in MS Access 2000 after the initial conversion.

Web Helpdesk MS Sql Server database
You may want to create a new database for your testing of Web Helpdesk v4:

1. Backup your existing database and restore to a new name.
2. Edit convertmssql.sql script in the MSSQL folder created by the install to refer to the new database name.
3. Run convertmssql.sql against the new database
4. Edit the v4 global.asa to connect to the new database.

Web Helpdesk Oracle database
You may want to create a new schema for your testing of Web Helpdesk v4. To do so, edit the sql scripts in the Oracle folder to reflect the new schema. Then when you are ready to move your production site over to v4. run the ConvertOracle.sql script in the Oracle folder against your production schema. If you have changed any of the database user names or passwords from the defaults supplied by LBE, you will need to amend these sql scripts.

If you have any difficulty, please contact LBE.