Versions Compared

Version Old Version 2 New Version 3
Changes made by

Nic Pohl

Julie Doyle-Whitelock (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following steps are required to upgrade a blank Framework Logistics Tablet database.


Step 1 - Restore Framework Logistics Tablet Blank Database

...

  1. Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server > SQL Server Management Studio).
  2. Connect to the required server.
  3. Right-click on Databases and click Restore Database.... The Restore Database dialog will be displayed.
  4. In the To Databases field, enter the Framework Logistics Tablet blank database name.

    Example: FworkSQLCstLTablet_Blank
  5. In the From Device field, click the Browse button. The Specify Backup dialog will be displayed.
  6. Click the Add button. The Locate Backup File dialog will be displayed.
  7. Browse to the folder location of the backup file.

    Example: C:\Framework\
  8. Select the backup file.

    Example: FworkSQLCstLTabletXX.bak
  9. Click the OK button. The Locate Backup File dialog will close.
  10. Click the OK button. The Specify Backup dialog will close.
  11. In the Restore column, tick the backup to be restored.
  12. Select the Options tab.
  13. In the Restore the database file as list, click the Browse button for the Framework Logistics Tablet database (e.g., FworkSQLCstLTablet). The Locate Database Files dialog will be displayed.
    OR
    Use the default file location.
  14. Select the folder location where the database will be restored to.

    Example: C:\Framework\
  15. In the File Name field, enter the file name: FworkSQLCstLTablet_Blank.mdf
  16. Click the OK button.
  17. In the Restore the database file as list, click the Browse button for the Framework Logistics Tablet database log (i.e., FworkSQLCstLTablet_log). TheLocate Database Files dialog will be displayed.
    OR
    Use the default file location.
  18. Select the folder location where the database will be restored to.

    Example: C:\Framework\
  19. In the File Name field, enter the file name: FworkSQLCstLTablet_log.ldf
  20. Click the OK button.
  21. Click the OK button. The database restoration will be performed.
  22. Close Microsoft SQL Server Management Studio.


Step 2 - ODBC DSN Configurations

Provides the computer system with a connection to the Framework Logistics Tablet database.

...

Warning

Microsoft 64-Bit Operating Systems include two ODBC Data Source Administrator executable files. Depending on the operating system, use the following to open the correct ODBC Data Source:

On 32-Bit Operating Systems: Use either:
Start Menu > Control Panel > Administrative Tools > Data Sources (ODBC)
OR
\\%SystemRoot%\system32\odbcad32.exe (e.g., C:\Windows\system32\odbcad32.exe).
On 64-Bit Operating System: Use: 
\\%SystemRoot%\SysWOW64\odbcad32.exe (e.g., C:\Windows\SysWOW64\odbcad32.exe).


ODBC DSN Configuration - Framework Logistics Tablet

  1. Open Data Sources (ODBC).
  2. Select the System DSN tab.
  3. Click the Add button. The Create New Data Source dialog will be displayed.
  4. Select SQL Server Native Client XX.0.
  5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
  6. Enter the following details: 
    • Name: FworkSQLCstLTablet_Blank
    • Description (optional): Enter a description for the database connection. For example, Framework Logistics Tablet Blank Database.
    • Server: Select the SQL server from the Server drop-down list.
      OR
      Enter the SQL Server name.
  7. Click the Next button.
  8. Click the Next button.
  9. Tick: Change the default database to
  10. From the drop-down list select the required database.

    Example: FworkSQLCstTablet_Blank
  11. Click the Next button.
  12. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
  13. Click the Test Data Source... button.
  14. If successful, click the OK button.
  15. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
  16. Click the OK button. The Data Sources (ODBC) Administrator dialog will close.


Step 3 - Upgrade Framework Logistics Tablet Database

...

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



Step 4 - Backup Framework Logistics Tablet Database

...

Warning

This MUST be performed on the system(s) that host a Framework Logistics Tablet database.

...


Creates a backup of the upgraded Framework Logistics Tablet blank database to be used as the default database that will be upgraded for the next major version ofFramework Logistics Tablet.

...