Migrating to a New Microsoft SQL Server

Prerequisites: Before migrating ActivID CMS data to a new Microsoft SQL Server.

  • The ActivID CMS database must be installed on your previous Microsoft SQL Server.

  • The new Microsoft SQL Server must be installed and running on a different system.

This version of ActivID CMS is supported on Microsoft SQL Server 2012 SP1, Microsoft SQL Server 2014 SP1, Microsoft SQL Server 2016, Microsoft SQL Server 2017 and Microsoft SQL Server 2019.

If you intend to upgrade an existing ActivID CMS deployment with an older version of Microsoft SQL Server database to a newer one, complete the following two steps.

  1. Migrate your data from your previous Microsoft SQL Server to your new Microsoft SQL Server. For details, see Migrating Data to a New Microsoft SQL Server.

  2. Reconnect the ActivID CMS server from your previous Microsoft SQL Server to your new Microsoft SQL Server. For details, see Reconnecting ActivID CMS Server to a New Microsoft SQL Server Database.

Migrating your data as described in this section is the preferred upgrade method (as opposed to performing a direct database upgrade) for the following reasons.

  • Migration enables you to retain a backup database that is not directly impacted by the upgrade process.

  • Migration enables you to have the two databases on separate systems.

Note: Although the upgrade concept is basically the same, you may need to adapt the steps to the version you are using.

Topics in this section: