Migrating Sage Estimating SQL data
Description
Cause
Resolution

On the Old Server

  1. Check-in all checked out databases in Database Editor.
  2. Use the Sage Estimating Management Console (Tools, Backup) to back up all databases.
    • Estimate Database
    • Standard Databases
    • Address Book Database
  3. Copy the *.BAK files to a place that you can access from the new server.
  4. Use License Administration XX.X to deauthorize the license server.

 

On the New Server

  1. Install SQL Server Standard / Enterprise and create a SQL Instance.
  2. Install Sage Estimating.
  3. Use License Administration XX.X to authorize the license server.
  4. Use the Sage Estimating Management Console (Tools, Restore) to restore all databases.
    • Estimate Database
    • Standard Databases
    • Address Book Database
  5. Open the Configuration Wizard.
  6. Go to the Data tab and switch the estimates folder to the newly restored location.
Steps to duplicate
Related Solutions

Getting Started: Welcome to Estimating (SQL)

How do I back up and restore my Sage Estimating database, using the Estimating Management Console? (SQL)

See Sage Estimating / Product Documents / Sage Estimating SQL Server Guide

Error: "You are not currently set up as a user of the selected Estimating server" (Security.Fix required) (SQL)