...
In preparation for the upgrade, all databases associated with Framework Sales Advice Management MUST be backed up.
| Warning | ||
|---|---|---|
| ||
- The 6.3.0 database upgrade process includes an automatic database backup procedure, however some tables may be skipped due to size. Therefore, it is HIGHLY recommended that this procedure is performed. |
Backup Framework Sales Advice Management Master Database
- Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > (or above) > SQL Server Management Studio).
- Connect to the required server.
- In the Object Explorer pane, expand: [server name] > Databases
- Right-click on the Framework Sales Advice Master Management database (e.g., FworkSQLSAMaster) 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.
Info 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 SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > (or above) > SQL Server Management Studio).
- Connect to the required server.
- In the Object Explorer pane, expand: [server name] > Databases
- Right-click on the Framework Sales Advice Management database (e.g., FworkSQLSalesAdvice) 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.
Info 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.
...
| Warning | ||
|---|---|---|
| ||
- This MUST be performed on the server that hosts the Framework Sales Advice Management database. |
The following procedure upgrades the Framework Sales Advice Management database(s).
| Tip |
|---|
If during the upgrade process 'Not Responding' appears in the title bar of the Framework Sales Advice Management Upgrade software, this is due to the system performing very long and CPU-intensive calculations. This message will disappear once the upgrade has been completed. |
Framework Sales Advice Management 7.
...
1.
...
1 Master Database Upgrade
| Info |
|---|
| This is a two-step process: |
Framework Sales Advice Management 7.1.0.01 Upgrade
- Open Windows Explorer.
- Browse to: \[fw folder]\Upgrade\
...
- Upgrade_v7_
...
- 1_0_
...
- 01\SalesAdvice\
- Double-click the FworkSAMasterUpgrade.exe file. 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 Close.
Backup Framework Sales Advice Management Database
Following the instructions in Step 2, create a separate backup of the database at this point.
Framework Sales Advice Management 7.1.1.03 Upgrade
- Open Windows Explorer.
- Browse to: \[fw folder]\Upgrade\Upgrade_v7_1_1_03\SalesAdvice\
- Double-click the FworkSAMasterUpgrade.exe file. 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 Close.
Unsuccessful Database Upgrade
If the database upgrade was unsuccessful, restore the backup database file. Refer to your Microsoft SQL Server documentation for more information.
Framework Sales Advice Management 7.
...
1.
...
1 Database Upgrade
| Info |
|---|
| This upgrade can be skipped if your organisation does not use a separate Sales Advice database.is a two-step process: |
Framework Sales Advice Management 7.1.0.01 Upgrade
- Open Windows Explorer.
- Browse to: \[fw folder]\Upgrade\
...
- Upgrade_v7_
...
- 1_0_
...
- 01\SalesAdvice\
- Double-click the FworkSAUpgrade.exe file. 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 Close.
Framework Sales Advice Management 7.1.1.03 Upgrade
- Open Windows Explorer.
- Browse to: \[fw folder]\Upgrade\Upgrade_v7_1_1_03\SalesAdvice\
- Double-click the FworkSAUpgrade.exe file. 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 Close.
Unsuccessful Database Upgrade
...
- Open Windows Explorer.
- Browse to: \[fw folder]\Setup\Framework Sales Advice Management\v67.31\Setup\
- Double-click Framework Sales Advice Management.msi and follow the on-screen prompts.
...