Learn more

Using the Estimating Management Console

About "shell" databases

Sage Estimating Database Installer window

Use this window to install sample and commercial databases and activate commercial databases for use with Sage Estimating.

If you maintain your own item list, you can also install one or more of the "shell" databases that come with Sage Estimating. These databases include standard CSI phase codes, but no items. You add your own items to the standard phases either manually or by importing items from an Excel spreadsheet.

After installing and activating your databases, the database list you generate appears on the Standard Databases tab.

You can open this window at any time in the Estimating Management Console by clicking [Install Databases].

  1. From any tab in the Estimating Management Console, click [Install Databases].

    The Sage Estimating Database Installer window opens automatically.

    The Registration name box displays the name you used to register the software.

  2. Select the type of database you want to install and activate from the category list:
    • Sample databases contain sample data and do not require an activation code.
    • Shell databases include standard CSI phase codes (no items) and do not require an activation code.
    • Optional, Advanced Assembly, and industry-specific databases (including Means) require an activation code.

    A corresponding list of all databases of the selected type that are available for installation on the selected instance appears in the left-hand pane.

    Note: The list of available databases is determined from the database support files loaded on the computer or server where you initially installed the Sage Estimating software.

  3. Select one or more databases you want to be available for use in Sage Estimating and click the right-arrow button An image of the arrow button that you click to move your selection from the left to the right side to move them to the Databases to install list.

    You can also click the left-arrow button An image of the Right Selection Arrow that you click to move your selection from the right to the left side to move selected databases from the Databases to install list back to the left-hand pane.

    Notes:  

    • Databases appear on the Standard Databases tab of the Estimating Management Console after you install them.
    • If you select a database that was installed on the selected SQL Server instance previously, the database name is appended with a five-digit sequential number. For example, if you select the SampleExtendedConMas database, and it was installed by a previous user, the database is added again as SampleExtendedConMas_00001.

  4. Type the activation code in the Activation code box for each database in the Databases to Install list.

    Databases that do not require an activation code (such as sample databases) do not display a corresponding Activation code box. You can find the activation code for each database listed on the original shipment's packing list.

  5. Click [Install].

  6. When the results window appears, click [Close].

  7. Repeat steps 1-6 for any databases you want to install on other computers or servers.

Items in this window

Items in the Sage Estimating Database Installer window
Item Notes
Registration name

The registration name entered during software registration appears in this box.
<Server selection list>

Displays the SQL Server instance (server) where you want your databases installed.
<Available databases>

Displays a list of all SQL databases that are available for installation on the SQL Server instance (server).

Click the right-arrow button to move selected databases to the Databases to install list. An image of the arrow button that you click to move your selection from the left to the right side
Databases to install

Displays a list of databases that are selected to be installed on the specified instance (server) when you click [Install].

Select any database in the list and then click the left-arrow button to remove it from the list. An image of the arrow button that you click to move your selection from the right to the left side

Note: If you select a database that was installed on the instance previously, the database name is appended with a five-digit sequential number. For example, if you select the SampleExtendedConMas database, and it was installed by a previous user, the database is added again as SampleExtendedConMas_00001.

<Right arrow button>

An image of the arrow button that you click to move your selection from the left to the right side

Click to move any database selected in the Available databases list over to the left-hand pane.

The Estimating Management Console installs databases in the Databases to install list to the specified instance (server) when you click [Install].

<Left arrow button>

An image of the Right Selection Arrow that you click to move your selection from the right to the left side

Click to move any database selected in the Databases to install list back to the left-hand pane.

[Install]

Click to add install all SQL databases in the Databases to install list to your specified instance (server).

A list of installed databases appears on the Standard Databases tab of the Estimating Management Console and throughout the Sage Estimating software.

Note: The Estimating Management Console temporarily elevates your system privileges when you install the selected databases.