OnCall IVR Designer v7.11.2, part of OnCall IVR Suite v3.3.x

IVR Designer Upgrade Guide

This chapter provides detailed steps and tasks related to upgrading the IVR Designer.

Note

Geomant advises to have the original version of the application as well as its database backed up before upgrading to the newest release.

Creating a Backup

Database Back Up

The GeoIVRDesigner database might be modified during the upgrade, therefore it is recommended to take a snapshot of it.

Note

Backing up the database requires adequate storage space, proper permissions and technical expertise. It should be performed by an DB Administrator.

Web Application Back Up

In order to back up the web application, all you need to do is copy the root folder of the website to a backup location. The default path is:

C:\inetpub\wwwroot\IVRDesigner

Would you have selected a custom location for your website, make a copy of that one.

IVR Designer Upgrade

Preparation for the Database Upgrade

Have a clean script in the SQL Server Management Studio. Delete any remainder information. If you want to delete an existing IVR Designer entirely, delete the GeoIVRDesigner database and the GeoIVRDesigner user from the Microsoft SQL Server.

Acquiring the Upgrade Script

Copy the database upgrade script (.sql file) from the installation media onto the computer you have the SQL Server Management Studio installed.

The database upgrade script's naming convention follows this format:

GeoIVRDesigner_upgrade_from_vX.X.X_to_vX.X.X

Important

Upgrading to a version that is several steps away from the currently deployed version requires the sequential execution of all intermediate database upgrade scripts in the proper order.

Database Upgrade Example

If version 7.4.3 is installed in an environment, but a version several iterations more recent is required (e.g. 7.5.3), the upgrade should be like:

1. Execute the GeoIVRDesigner_upgrade_from_v7.4.3_to_v7.5.0 script file.
2. Then execute the GeoIVRDesigner_upgrade_from_v7.5.0_to_v7.5.1 script file.
3. Then execute the GeoIVRDesigner_upgrade_from_v7.5.1_to_v7.5.2 script file.
4. Then execute the GeoIVRDesigner_upgrade_from_v7.5.2_to_v7.5.3 script file.

Executing the Upgrade Script

1. Locate the particular script file considering the current version of the IVR Designer installed.
2. Click to have it loaded in SQL Server Management Studio.
3. Click Execute to run the script.
4. If the query was successful, refresh the GeoIVRDesigner node.
5. Check the Global Configurations table under Tables to see if the version has been upgraded successfully.
6. Continue with the next upgrade script if you are upgrading from earlier versions than the previous one.

Upgrading the Application

1. After running the upgrade SQL script files, install the latest version of IVR Designer.
2. Run the setup.exe file. You will be presented with the install wizard.
3. Click Next to continue the installation of the new version.
4. Click Install to initiate the setup.
5. Click Finish to complete the installation.

Rolling Back to a Previous Version

If there is a problem with the new IVR Designer, you can have the database backup (created before the upgrade) rolled back by a properly skilled DB Administrator.

The IVR Designer application needs to be uninstalled and the previous version re-installed.