Web Scraper and Web Macros FAQs

Page History: How to upgrade to Web Scraper 5.5 or above?

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2008/02/19 21:04

Web Scraper 5.5 and above uses larger database, SQL2k5 express, instead of the SQL 2000 MSDE. This allows you extract fields over 8000 characters into varchar(max) column types. Other features included are dataset within dataset and auto-update.

Instructions to upgrade:

If you have packages and datapages you wish to keep:
  1. Open Web Scraper Plus+ and export all packages you wish to keep by dragging over them, right click -> export.
  2. S

If you have SQL databases you wish to keep:
  1. Go to Control Panel -> Administrative Tools -> Services and stop the MSSQL$PROVIDUSSTD service.
  2. Locate the .mdf and .ldf files for the databases in C:\Program Files\Microsoft SQL Server\MSSQL$PROVIDUSSTD\Data or somewhere similar.
  3. Copy them into a secure folder

If you copied your database mdf and ldf files, do the following to restore them:
  1. Download and install Sql Management Studio if you don't already have it.
  2. Connect to the .\PROVIDUSSTD server instance with SQL Server authentication, username: sa password: velocityscape
  3. Expand the PROVIDUSSTD instance in the left pane (Object Explorer) and right click databases -> attach.
  4. Locate the mdf files in C:\Program Files\Microsoft SQL Server\MSSQL$PROVIDUSSTD\Data or if not there, where you backed them up.
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account