Migrate Appspace 6.2.4 on-prem from Windows Server 2008 to Windows Server 2016 / 2019

This article provides the instructions to migrate your Appspace 6.2.4 on-prem server running Windows Server 2008, to a new server running Windows Server 2016 or Windows Server 2019.

The migration process involves backing up and restoring database tables stored in either MySQL or MS SQL databases, and reinstalling the Appspace 6.2.4 on-prem on to a new server running Windows Server 2016 or Windows Server 2019. It also involves replicating the original Appspace folders to the new server.

Note
The instructions in this article uses the MySQL database as an example.

Prerequisites

Important
  • All devices must be re-registered on the new server after the migration.
  • SSO settings will not be copied over to the new server after the migration.
  • Users whose invitations are pending must be deleted on the existing server, and re-invited again on the new server after migration.

Backup Existing Appspace Databases

Backup the existing Appspace databases from your Windows Server 2008 server to a new location. You may choose to copy the folder to a location within the server, or to an external source such as a USB drive or a secure cloud storage service.

  1. Stop the Internet Information Services (IIS) on the Appspace server, from the command prompt using this command: iisreset /stop

    For more information, please refer to the instructions on the Microsoft website: https://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/95826e7a-bac4-4e1f-bcb6-c52d49c9d7f4.mspx?mfr=true or https://technet.microsoft.com/en-us/library/cc732317(v=ws.10).aspx
  2. Run the MySQL Workbench program from the Windows Start menu.
  3. Click ‘Local instance MySQL’. The ‘Local instance MySQL’ tab will be displayed, with the Data Export and Data Import/Restore links shown on the Navigator sidebar.
    Note
    You may need to enter the root password (if not already stored in the vault).
  4. Select Data Export under Management in the Navigator pane, and in the Local Instance MySQL tab, select one database schema you would like to export, and ensure that all the tables are selected in the Schema Objects window on the right.
  5. Ensure the following ‘Objects to Export’ checkboxes are checked:
    • Dump Stored Procedures and Functions
    • Dump Events
    • Dump Triggers
  6. Select the ‘Export to Self-Contained File’ option, and choose a location to store your .sql file (you may also customize the name of the file to your own preference). Click the Start Export button.
    Allow some time for the export process. The progress bar will indicate the status of the task. The task will be completed once the Status indicates that the file has been exported. You may verify this by navigating to the location of the newly-generated .sql file in Windows Explorer.
  7. Repeat Steps 3 to 5 for all the other database schemas by creating new self-contained .sql files. Ensure that only one database schema is selected at any one time, and that the ‘Export to Self-Contained File’ option is selected before exporting.

    Important
    The following databases are required by Appspace for the backup process:
    • aspnetsession
    • dsnmetrics
    • playoutmetrics
    • tokenman
    • webman
    • ext_*

    Ensure all databases with the prefix “ext_” are copied.

Backup Appspace Folders

Backup the Appspace data and folders from your windows 2008 server to a new location. You may choose to copy the folder to a location within the server, or to an external source such as a USB drive or a secure cloud storage service.
 
  1. From Windows Explorer, copy and paste the following Appspace installation folder to a desired backup location:
    • C:\Appspace
      Note
      In Appspace versions prior to 5.1 (i.e. 5.0.x), the installation and content folders are located here:
      • Installation Folder – C:\Nexus
      • Content Folder – C:\NexusMediaNet\FTPFastNetV2
      It is recommended that these old folders are restructured to match the current installation folder structure:
      • Installation Folder – C:\Appspace
      • Content Folder – C:\Appspace\Content
  2. Repeat the process for other folders that host Appspace files (if any).

Install Appspace on Windows Server 2016 / 2019

Install Apspspace 6.2.x on your new Windows Server 2016 or Windows Server 2019 server.

Please refer to the Install and Configure Operating System section in the Installing Appspace on-prem article.

Restore Databases

You must restore databases in MySQL by manually importing the self-contained SQL files backed up earlier to the Windows Server 2016 or Windows Server 2019 server.

  1. Stop the Internet Information Services (IIS) on the server, by following the instructions on the Microsoft website: https://technet.microsoft.com/en-us/library/cc732778(v=ws.10).aspx
  2. In MySQL Workbench, click Data Import/Restore, and select the ‘Import from Self-Contained File’ option. Locate the .sql file in your server and choose the appropriate Default Target Schema from the drop-down menu.
  3. Click the Start Import button. The progress bar will indicate the status of the task.
  4. Repeat the same procedure for the other database schemas (dsnmetrics, playoutmetrics, etc).

Restore Appspace Folders

Once the databases are restored, you may proceed to restore the installation folders and files from the previous Appspace server to the same location in the new Appspace server. By default the location is:

  • C:\Appspace

Repeat the process for other folders backed up earlier (if any).

Run Appspace Installer

Important
When upgrading your Appspace on-premise instance, we recommend using 24GB of RAM or more for a quicker upgrade installation process.
  1. Rerun the Appspace Installation Center (AIC) and select the Upgrade option. Please refer to the Upgrade Appspace section in the Upgrading an Appspace 6.2.4 on-prem server article.
  2. Start the Internet Information Services (IIS) on the server, by following the instructions on the Microsoft website: https://technet.microsoft.com/en-us/library/cc732778(v=ws.10).aspx

Activate Appspace

Proceed to activate the new license. Please refer to the Activating Appspace on-prem article.

Upgrade to Appspace 7.x On-Prem

Proceed to upgrade the Appspace platform. Please refer to the Upgrade to Appspace 7.x On-Prem article.

 

Related Articles