Migrating Sage Estimating SQL data

Summary

How do I migrate my Sage Estimating data from one SQL Server to another SQL server?

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.

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)

Install and / or Upgrade Sage Estimating (SQL)

What is the process involved in installing Sage Estimating? (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)

Solution Properties

Solution ID
224924750070879
Last Modified Date
Tue Aug 13 17:49:53 UTC 2024
Views
0