Skip to main content

1E 8.1 (on-premises)

Side-by-side upgrade of ActiveEfficiency Server for Nomad

This scenario is for an existing Nomad and ActiveEfficiency installation, where Tachyon Platform is on a different server, either newly installed or upgraded from on earlier version of SLA Platform or Tachyon. The old ActiveEfficiency Server is eventually decommissioned. There is no requirement for HTTP redirection on the Tachyon server, because old Nomad clients will continue to use the ActiveEfficiency server, and new Nomad clients will use Content Distribution on the upgraded Tachyon Platform. Each set of clients functions independently. Some data is manually migrated from the ActiveEfficiency server, as described below.

If your Tachyon license includes Nomad, and you choose to install Nomad, and a local installation of ActiveEfficiency Server is detected, then you are doing an In-place upgrade of ActiveEfficiency Server for Nomad.

If a local installation of ActiveEfficiency Server is not detected, the ActiveEfficiency database is retained even if it is on the same SQL instance you specified for the ContentDistribution database.

Steps for side-by-side upgrade of ActiveEfficiency

  1. Review your requirements to determine which features you need of 1E Client and Tachyon Platform, please refer to Planning for Tachyon Platform pages

  2. Upgrade your server hardware as required- please refer to Server sizing requirements

  3. Run Tachyon Setup on the existing SLA Platform or Tachyon server to upgrade it to Tachyon Platform - please refer to Tachyon Setup

  4. Run Tachyon Setup on remote Tachyon Response Stack servers (if used) - please refer to Tachyon Setup

  5. Verify existing clients (if upgrading SLA Platform or Tachyon)

  6. Run Tachyon Setup on remote Tachyon DMZ Server (if used) - please refer to Implementing a Tachyon DMZ Server

  7. Verify existing Internet based clients (if upgrading Tachyon)

  8. Deploy new 1E Client to some test devices (with Tachyon and Nomad client enabled)

  9. Verify the test devices

  10. Upgrade Nomad Admin Tools and server components - please refer to Upgrading Nomad

    1. Upgrade Nomad Admin Tools and server components

    2. Update OS Deployment Task Sequence actions to use the Tachyon Platform

    3. Manually migrate data from ActiveEfficiency Server

    4. Configure Nomad Sites.

  11. Deploy new 1E Client to remaining devices

  12. When all Nomad clients have been upgraded, then you can decommission the old ActiveEfficiency Server (unless you need to retain it for Shopping).

Manually migrate data

Use the following migration scripts to manually migrate sites, pre-cache jobs, and paused collections, from ActiveEfficiency, so they can be managed by upgraded installations of the Nomad Configuration Manager Console Extensions. After migration, you can review these in the Nomad app.

Locations, Single-site data, and content registrations are not migrated, but are copied to legacy database tables for reference only. This data is not shared with new clients, so that legacy and new clients function independently. New clients will re-register their content automatically up to 24 hours later, or can be forced by using the NomadBranch command-line parameter -cdssync as described in NomadBranch.exe command-line switches. Old and new clients will perform master elections and peer-share content if they are the same subnet, but they will only use SSD with their own set of clients.

You will maintain Nomad Sites (previously known as Locations) using the one of the new versions of the example PowerShell scripts provided with the Nomad Admin Tools. Alternatively, you can use the examples to modify your existing script to use Content Distribution instead of ActiveEfficiency.

You may continue to maintain Locations in ActiveEfficiency as before, to continue supporting old clients.

Click here to download - AE-CD Data Migration Scripts.zip

Note

  1. ExportData.ps1 - run on any computer that has read access to the ActiveEfficiency database

  2. CreateTables.sql - run on the SQL Server instance that hosts the ContentDistribution database created by Tachyon Setup

  3. ImportData.ps1 - run on any computer that has write access to the ContentDistribution database.

Prerequisites

  • The ability to run PowerShell scripts and SQL script

  • A SQL Login on each SQL Server instance for the user running the scripts

  • db_datareader rights on the ActiveEfficiency database

  • db_datawriter rights on the ContentDistribution database

Before running the scripts you will need to prevent clients, administrators, and scheduled jobs from updating ActiveEfficiency and Nomad.

  1. Stop IIS on the Tachyon Master Stack server (where Content Distribution is installed)

    1. Open command prompt in administrator mode and run iisreset /stop

  2. Stop IIS on the server where ActiveEfficiency Server is installed

    1. Open command prompt in administrator mode and run iisreset /stop

  3. Temporarily disable any Task Scheduler jobs related to ActiveEfficiency

    1. From the Start screen, start typing Task Scheduler then click on Task Scheduler in the search results

    2. Expand Task Scheduler Library → ActiveEfficiency

    3. Right-click on each job and select Disable

  4. If you have any custom jobs to run import scripts for Sites and Subnets then also disable these temporarily.

Create Tables

Open SQL Management Studio and connect to ContentDistribution database. Execute SQL script CreateTables.sql. This will create all the required legacy tables in the ContentDistribution database.

Note

This script only needs to be executed once.

Export Data

Run the ExportData.ps1 script in a PowerShell admin command prompt using a command line similar to below.

.\ExportData.ps1 -AEServerName "AEServer" -AEDBName "ActiveEfficiency" -CDServerName "CDServer" -CDDBName "ContentDistribution" -folderPath "C:\migration" -logsPath "C:\migration\logs"

This command will create a series of CSV files that we will later import into the ContentDistribution database.

Import Data

Run the ImportData.ps1 script in a PowerShell admin command prompt using a command line similar to below.

.\importData.ps1 -CDServerName "CDServer" -CDDBName "ContentDistribution" -folderPath "C:\migration" -logsPath "C:\migration\logs"

This command will populate the tables from the CSV files exported earlier.

Restart IIS

  1. Restart IIS on the ActiveEfficiency Server and Tachyon Master Stack server (where Content Distribution is installed)

    1. Open command prompt in administrator mode and run iisreset /start

  2. Enable the Task Scheduler jobs again on the ActievEfficiency Server

Script parameters

Parameter

Description

AEServerName

Name of the SQL Server hosting ActiveEfficiency database. If the server is not running on the default instance, enter the server name and instance name separated by backslash, for example DBServer\DB

AEDBName

Name of the ActiveEfficiency database.

CDServerName

Name of the server hosting ContentDistribution database. If the sever is not running on the default instance, enter the server name and instance name separated by backslash, for example DBServer\DB

CDDBName

Name of the ContentDistribution database.

folderPath

Folder location to save CSV files. If the path doesn't exist, it will be created by the script.

logsPath

Folder location to save log files. If the path doesn't exist, it will be created by the script.

In this section: