Versions Compared

Version Old Version 2 New Version 3
Changes made by

Julie Doyle-Whitelock

Julie Doyle-Whitelock

Saved on

Key

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

...

  1. Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > 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 Database field, enter the Framework Database Name.
    Example: FworkSQLIntMap
  5. In the From Device field, click the Browse The Specify Backup dialog will be displayed.
  6. Click the Add The Locate Backup File dialog will be displayed.
  7. Select the folder and file location of the Microsoft SQL Server backup file.
    • Typical Folder: \[fw folder]\Service\01 - Default Data\
    • Typical File: bak
  8. Click the OK The Locate Backup File dialog will close.
  9. Click the OK The Specify Backup dialog will close.
  10. In the Restore column, tick the backup to be restored.
  11. Select the Options
  12. In the Restore the database file as list, click the Browse button for the Framework Integration database (i.e.,FworkSQLIntMap). The Locate Database Files dialog will be displayed.
    OR
    Use the default file location.
  13. Select the folder location where the database will be restored to.
    Example: \[fw folder]\Data\DataMSSQL\
  14. In the File Name field, enter the file name: FworkSQLIntMap.mdf
  15. Click the OK
  16. In the Restore the database file as list, click the Browse button for the Framework Integration database log (i.e., FworkSQLIntMap_log). The Locate Database Files dialog will be displayed.
    OR
    Use the default file location.
  17. Select the folder location where the database will be restored to.
    Example: \[fw folder]\Data\DataMSSQL\
  18. In the File Name field, enter the file name: FworkSQLIntMap_log.ldf
  19. Click the OK
  20. Click the OK The database restoration will be performed.
  21. Close Microsoft SQL Server Management Studio.

...

Provide Framework Integration with the connection to read and write from the database.Critical:

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 Integration

...