The following guide is designed to upgrade the Framework ECM database and software.

Pre-Requisite Checklist

• Complete the Pre-Requisite Checklist.
• Complete the Environment Setup Checklist.

Step 1 - Shutdown Framework ECM

Before proceeding with the upgrade, Framework ECM needs to be shutdown so that no user can access the system during the upgrade period.

Shutting down Framework ECM logs users out of the system in an orderly fashion.

1. Open Framework Configuration Utility (Start > All Programs > Insula Software > Framework Configuration Utility)
2. Logon to the system.
3. Select the Shutdown tab.
   
   
   
   
4. In the Framework Shutdown group, change the Shutdown? field from No to Yes.
5. Enter the shutdown details.
6. Click the Shutdown Framework button.
7. Click the OK button.

Step 2 - Close Framework Connections

It is a requirement for the Framework Product Suite Upgrade to be successful that all connections to the Framework database be cleared. Please refer to your Microsoft SQL Server documentation for more information on this process.

Step 3 - Implement Framework Product Suite Files

It is a requirement that all Framework Product Suite files are implemented on your server to the [fw folder].

On the system that contains the [fw folder]:

1. Connect to ftp://ftp.insulagroup.com.au/.
   
   
2. Select the relevant application folders until the required application and version are located.
3. Select the Framework APP X.X.XXXX.zip to download.
4. Place the files locally created \[fw folder]\Setup\Framework [APP]\v7.1\Setup\ folders.
5. For each app, access the local Setup folder and double click the Framework APP X.X.XXXX.msi file to launch the install process.
6. Follow the Install Wizard prompts.

Step 4 - Configure Folder And File Permissions

The Framework Folders require different access permissions depending on the folder. The following table displays the list of Framework folders and the network permissions required for each. Network permissions are rules associated with a shared resource on a network, such as a file, folder, or printer. These permissions can be assigned to groups, global groups, or individual users.

The available Microsoft Windows folder security permissions include: 

• Full Control
• Modify
• Read & Execute
• List Folder Contents
• Read
• Write
• Special Permissions

See the Microsoft Windows Help and Support documentation for more information on folder security permissions.

Step 5 - Backup Framework ECM Database

The following topic will backup your Framework ECM Database. This procedure is based on Microsoft SQL Server 2008 (or above).

Backup Framework ECM Database

1. Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 (or above) > SQL Server Management Studio).
2. Connect to the required server.
3. In the Object Explorer pane, expand: [server name] > Databases
4. Right-click on the Framework ECM database (e.g., FworkSQLECM) and select Tasks > Back Up. The Back Up Database (General Page) dialog will be displayed.

5. Specify a Name and Destination for the backup file, if different from the default name and destination details.
   
   

   Write down the name and destination details.
6. Select the Options page.
7. Tick: Overwrite all existing backup sets
8. Tick: Verify backup when finished
9. Click the OK button. The backup will be performed to the selected destination.
10. Click the OK button to close the message prompt.
11. Close SQL Server Management Studio.
12. Browse to the backup location (as detailed in Point 5 above).
13. Copy the backup file to a secure location.

Step 6 - Upgrade Framework ECM Database

The following procedure upgrades the Framework ECM database. 

Framework ECM 7.1.1 Database Upgrade

This is a two-step process:

Framework ECM 7.1.0.23 Upgrade

1. Open Windows Explorer.
2. Browse to: \[fw folder]\Upgrade\Upgrade_v7_1_0_23\ECM\
3. Double-click the FworkECMUpgrade.exe file. A Database Backup confirmation prompt will be displayed.
4. Click Yes to confirm that a manual backup of the Framework ECM database has been performed (if a manual backup has not been performed, see Step 5 - Backup Framework ECM Database). The Start Upgrade confirmation prompt will be displayed.
5. Click Yes to perform the upgrade.
6. If the upgrade was successful, a successfully completed message prompt will be displayed.
7. Click OK.
8. Click Close.

Backup Framework ECM Database

Following the instructions in Step 5, create a separate backup of the database at this point.

Framework ECM 7.1.1.06 Upgrade

1. Open Windows Explorer.
2. Browse to: \[fw folder]\Upgrade\Upgrade_v7_1_1_06\ECM\
3. Double-click the FworkECMUpgrade.exe file. A Database Backup confirmation prompt will be displayed.
4. Click Yes to confirm that a manual backup of the Framework ECM database has been performed (if a manual backup has not been performed, see Step 5 - Backup Framework ECM Database). The Start Upgrade confirmation prompt will be displayed.
5. Click Yes to perform the upgrade.
6. If the upgrade was successful, a successfully completed message prompt will be displayed.
7. Click OK.
8. Click Close.

Database Administration Command Line

By default there are database administration functions that will be performed during the ECM Upgrade to improve database performance.

This includes shrinking the database log files and updating database statistics.

To disable these functions, a command line switch can be used.

1. Open Windows Explorer.
2. Browse to: \[fw folder]\Upgrade\Upgrade_v7[_X_X_xx]\ECM\
3. Right-click on FworkECMUpgrade.exe and select Create Shortcut. A shortcut to the executable will be created.
4. Right-click on the new shortcut and select Properties. The Properties dialog will be displayed.
5. On the Shortcut tab, edit the Target field and include the command line switch -skipDBAdmin at the end of the line. The target should look similar to the following:
    "C:\Framework\Upgrade\Upgrade_v7[_X_X_xx]\ECM\FworkECMUpgrade.exe" -skipDBAdmin
6. Click the OK button. The Properties dialog will close.

After creating a new shortcut with the command line switch, run the Database Upgrade using the new shortcut.

Unsuccessful Database Upgrade

If the database was unsuccessful, restore the backup database file. Refer to your Microsoft SQL Server documentation for more information.

Step 7 - Upgrade Sentinel Protection Installer

Upgrades the Sentinel Hardware Licence Key security software.

Upgrade - Sentinel Protection Installer

Note: If installing on Windows Vista or Windows 7, the User Account Control (UAC) Consent prompt may be displayed.

1. Open Windows Explorer.
2. Browse to: \[fw folder]\Setup\Sentinel Protection Installer\v7.6.5\
3. Double-click setup.exe. The Sentinel Protection Installer Upgrade will begin and the Confirm Upgrade dialog will be displayed.
4. Click the Upgrade button. The Welcome dialog will be displayed.
5. Click the Next. The Licence Agreement will be displayed.
6. Select I accept the terms in the licence agreement.
7. Click the Next button. The Setup Type dialog will be displayed.
8. Select Complete.
9. Click the Next button. The Ready To Install the Program dialog will be displayed.

10. Click the Install button to begin the installation.
    
    

    If Windows Firewall is detected, click the Yes button.

11. Click the Finish button.

Step 8 - Update Core Components

Installs a set of common software tools used by Framework ECM.

For this process, see Install Insula Core Components.

Step 9 - Update Framework ECM

On ALL systems running Framework ECM:

Uninstall The Existing Version Of Framework ECM

In Microsoft Windows XP

1. Open Add or Remove Programs (Start > Control Panel > Add or Remove Programs). The Add or Remove Programs dialog will be displayed.
2. From the Currently Installed Programs list, select the previous version of Framework ECM.
3. Click the Remove button. The application will be removed.

In Microsoft Windows Vista/Windows 7

1. Open Uninstall a Program (Start > Control Panel > Uninstall a Program). The Uninstall or Change a Program list will be displayed.
2. Select the previous version of Framework ECM.
3. Click the Uninstall button. The application will be removed.

Install The Latest Version Of Framework ECM

1. Open Windows Explorer.
2. Browse to: \[fw folder]\Setup\Framework ECM\v7.0\Setup\
3. Double-click Framework ECM.msi and follow the on-screen prompts.

Step 10 - Restart Framework ECM

After finishing the database and system upgrade, Framework ECM needs to be restarted so that users can access the system.

1. Open Framework Configuration Utility (Start > All Programs > Insula Software > Framework Configuration Utility)
2. Logon to the system.
3. Select the Shutdown tab.
   
   
   
   
4. Under the Framework Availability group, click the Restart Now button.
5. Click the OK button.

Step 11 - Test Framework ECM

On all systems running Framework ECM:

Start Framework ECM

1. Start Framework ECM (Start > All Programs > Insula Software > Framework).

   Double-click the Framework ECM desktop icon.

2. If this is the first installation of Framework ECM or a manual update of the Framework Licence database has not been performed, the Framework Licence Database Validation prompt will be displayed.

   If the Framework Licence Database Validation prompt is not displayed, skip to  Point 6.
3. Click the Yes button to validate the Framework installation. The Update Licence dialog will be displayed.

4. Browse to the location of the Framework Licence Zip file.

   The file is typically located in the \\[fw folder]\Service\02 - Upgrade Data\ folder with the filename FrameworkLicence.zip.

5. Select the file and click the Open button. The validation will be performed.
6. Log on to the system.

Step 12 - User Acceptance Tests

The following is a list of view only User Acceptance Tests (UATs) that must be performed after upgrading the application.

Framework ECM - Production Management

Framework ECM - Land Management

Framework ECM - Administration

Framework ECM - Security

Framework ECM - Report Management

Framework ECM - Variation Price Book

Framework ECM - Client And Contact Management

Additional Support Software

If upgrading the Framework Product Suite on the server, consider installing Microsoft Office as this assists with:

• Remote Support (for Insula Software and your own IT support team).
• Testing of all system components including mail merge and email integration.