he The following guide is designed to upgrade the Framework ECM database and software.
Pre-Requisite Checklist
- Complete the Pre-Requisite Checklist Overview.
- Complete the the Environment Setup Checklist Overview.
Step 1 - Shutdown Framework ECM
...
The following topic will backup your Framework ECM Database. This procedure is based on Microsoft SQL Server 2008. Please consult your Microsoft documentation if you are using Microsoft SQL Server 2005.
Critical:
- The 6.3.0.xx database upgrade process includes an automatic database backup procedure but some tables may be skipped if they exceed a certain size. Therefore, it isHIGHLY recommended that this procedure is performed.
- This MUST be performed on the server that hosts the Framework ECM database.
Backup Framework ECM Database
...
.
Backup Framework ECM Database
- Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
- Connect to the required server.
- In the Object Explorer pane, expand: [server name] > Databases
- 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.
- Specify a Name and Destination for the backup file, if different from the default name and destination details.
Note: Write down the name and destination details.
- Select the Options page.
- Tick: Overwrite all existing backup sets
- Tick: Verify backup when finished
- Click the OK button. The backup will be performed to the selected destination.
- Click the OK button to close the message prompt.
- Close SQL Server Management Studio.
- Browse to the backup location (as detailed in Point 5 above).
- Copy the backup file to a secure location.
...
- Open Windows Explorer.
- Browse to: \[fw folder]\Upgrade\Upgrade7_0_0_[xx]\ECM\
- Double-click the FworkUpgrade.exe file. A Database Backup confirmation prompt will be displayed.
- 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 see Step 5 - Backup Framework ECM Database). The Start Upgrade confirmation prompt will be displayed.
- Click Yes to perform the upgrade.
- If the upgrade was successful, a successfully completed message prompt will be displayed.
- Click OK.
- Click Closeperform the upgrade.
- If the upgrade was successful, a successfully completed message prompt will be displayed.
- Click OK.
- Click Close.
Performance Enhancement Command Line
By default there are functions that will be run during the ECM Upgrade to improve database performance.
To disable the Shrink Database Log and Update Stats functions, a command line switch can be used.
- Open Windows Explorer.
- Browse to: \[fw folder]\Upgrade\Upgrade_v7_0_0_[xx]\ECM\
- Right-click on FworkECMUpgrade.exe and select Create Shortcut. A shortcut to the executable will be created.
- Right-click on the new shortcut and select Properties. The Properties dialog will be displayed.
- 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_0_0_[xx]\ECM\FworkECMUpgrade.exe" -skipDBAdmin - 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
...
- Start Framework ECM (Start > All Programs > Insula Software > Framework).
Tip: Double-click the Framework ECM desktop icon. - 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.
Note: If the Framework Licence Database Validation prompt is not displayed, skip to Point to Point 6. - Click the Yes button to validate the Framework installation. The Update Licence dialog will be displayed.
- Browse to the location of the Framework Licence Zip file.
Tip: The file is typically located in the \\[fw folder]\Service\02 - Upgrade Data\ folder with the filename FrameworkLicence.zip. - Select the file and click the Open button. The validation will be performed.
- Log on to the system.
...