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:
- Backup your existing database and restore to a new name.
- Edit convertmssql.sql script in the MSSQL folder created by
the install to refer to the new database name.
- Run convertmssql.sql against the new database
- 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. | 
