Moving WebWatchBot's Database from one SQL Server Instance to Another

From WebWatchBotWiki
Jump to: navigation, search
 Share 

Summary

DIFFICULTY: Intermediate

To move WebWatchBot's database from one SQL Server Instance to another, follow these instructions. These instructions apply to moving the database on the same machine or a different machine.

This process does not move data files. To move data files, refer to the following: KB: Moving WebWatchBot Data Files From One Location to Another on the Same Machine


Instructions

  1. Stop the WebWatchBot service: In WebWatchBot Manager, select Tools -> Stop Service
  2. Close WebWatchBot Manager
  3. (Optional) If you wish to move your data files, you should do so now. Refer to the following: KB: Moving WebWatchBot Data Files From One Location to Another on the Same Machine
  4. Open SSMS (SQL Server Management Studio) and log in.
  5. In the "Object Explorer", on the left, expand the node for "Databases". If a database named "WebWatchBot" exists, either rename the database or delete the database if it is not in use.
  6. Backup the WebWatchBot database: Right-click on "Databases", then select "Tasks", and then select "Backup". Follow the instructions and refer to SSMS help for more information.
  7. Open Windows Explorer and locate the backup.
  8. Copy the backup to the new machine (if moving to another machine)
  9. Restore the WebWatchBot database: Right-click on "Databases", then select "Tasks", and then select "Restore". Follow the instructions and refer to SSMS help for more information. Ensure you create a new database in the process, named "WebWatchBot".
  10. Start WebWatchBot Manager. When prompted to start the WebWatchBot service, click "No".
  11. Select the menu options: "Tools", "WebWatchBot Preferences"
  12. Select "Advanced Properties", and then select "Database"
  13. In the "Advanced" section, either change "Auto Generate" to "True", to enter in the fields for "Microsoft SQL Server" "Source", "Username", and "Password", change "Auto Generate" to "False", to enter the connection string manually.
  14. Regardless of the option chosen for "Auto Generate", ensure the correct instance and credentials are specified.
  15. Click OK to close the "WebWatchBot Preferences" window and have WebWatchBot test the new database connection settings.
  16. If WebWatchBot fails to connect to the database, repeat the above steps, starting with entering "WebWatchBot Preferences".
  17. Your database should now be recognized and your Watch Items accessible and visible in the Watch List.