Upgrading from version 3.2.x to 3.3.7

Please completely read these instructions BEFORE beginning your upgrade process.

Please note that the Connect Daily upgrader does not support skipping major versions.

• If you are using 2.5.x you will need to upgrade to 3.0.7.
• If you are using 3.0.x you need to upgrade to version 3.1.5.
• If you are using 3.1.x you need to upgrade to version 3.2.13.
• Finally, you can upgrade from any 3.2.x version to 3.3.7

Backup

Before beginning the upgrade process, ensure that a fresh backup of your Connect Daily installation files and database are made.

Microsoft Access Users

If you are using Microsoft Access, copy your cdaily-3.3.7\WEB-INF\sql\Access\calendar.mdb file to a safe location.

SQL Database Users

Using the appropriate utility for your DBMS, create a backup of your SQL Database.

Instructions for Default Windows Installations

If you used the Connect Daily downloader, then you should follow these steps to upgrade. If you are using a different engine, or OS, then skip to the "Generic Application Server Instructions".

1. Stop the Connect Daily Service.
2. Make a copy of the cdaily-3.3.7/WEB-INF\configuration.properties file and cdaily-3.3.7/WEB-INF\styles.properties files.
3. Backup any custom EMail templates or caption translation files you have created.
4. Backup the cdaily-3.3.7\WEB-INF\sql\Access\calendar.mdb file.
5. Un-install Connect Daily
6. Using the Connect Daily downloader, re-install Connect Daily.
7. Restore the files backed up in steps 1-4.
8. Using a command shell, run the update330.bat file. It may be necessary to copy the file to a Windows XP or Windows 2003 server to run the script.
9. Start the Connect Daily Service.

Generic Application Service Upgrade Steps

1. Stop your application server.
2. Backup your cdaily-3.3.7/WEB-INF/configuration.properties file.
3. Backup any custom EMail templates or caption translation files you have created.
4. Remove the existing calendar application directory.
5. Extract the zip or WAR file containing Connect Daily into the appropriate directory for your application server.
6. Copy the configuration.properties file you saved in step 2 to the WEB-INF directory. If you are using MS Access, copy the calendar.mdb file you saved prior to beginning into the WEB-INF\SQL\Access directory.
7. Follow the instructions in the Database Updates section below.
8. If you copied your database JDBC driver JARs into the WEB-INF/lib directory, recopy them to the WEB-INF/lib.
9. If you are using your own translated caption files, refer to the Installation Guide and User manual for instructions on how to ensure you have all captions in your file.
10. Restart your application server.

Database Updates

All Databases

BACKUP YOUR DATABASE BEFORE PERFORMING THESE STEPS

MS Access Users

1. BACKUP YOUR DATABASE BEFORE PERFORMING THESE STEPS
2. Copy the calendar.mdb file you saved in the backup portion of this procedure to cdaily-3.3.7\WEB-INF\SQL\Access
3. Change to the cdaily-3.3.7\WEB-INF\SQL\Access directory.
4. Run the batch file UPDATE330.bat

We have observed some issues with this script on Windows 2000 servers with certain versions of MDAC. If the upgrade script fails, please send a copy of the Access MDB file to MH Software and we will convert it for you.

SQL Database Users

1. BACKUP YOUR DATABASE BEFORE PERFORMING THESE STEPS
2. JNDI USERS:
   
   Edit your configuration.properties file. For the upgrade script to run, you must create a configuration.properties file that uses a standard JDBC Connect String. This is because the upgrade script will not have access to JNDI variables when it runs. For information on editing configuration.properties, refer to configuration.properties.
3. Edit either RUN330.SH or RUN330.Bat (depending upon your operating system). You must specify the SERVER_LIB_DIR variable as appropriate for your installation.
4. Run the WEB-INF/sql/run330.sh (UNIX) or WEB-INF/sql/RUN330.bat script.