Migrating CAS to a new platform (local database)

To migrate the CAS from one platform to another, including the local database, you need to make backups of your databases and configurations from your old machine, then install the software on the new machine, and then restore your databases and configurations on the new machine.

Important

For this procedure, it is assumed that your CAS installation uses a local database. If you are using a remote database, see Migrating CAS to a New Platform (Remote Database).

Make backups

These steps are not just to make safety copies. You will need these backups to restore your data and configurations after migration.

  1. Make a backup of the current CAS database.
    For more information, see Backing Up MS SQL Server Databases.
  2. Make a backup of the RUM Console database.
    For more information, see Complete RUM Console backup and restore
  3. Make a backup of the CAS %programfiles%\cas\config\directory.
    Manually copy this folder and its contents to a safe location.
  4. Make a backup of the CAS %programfiles%\cas\classes\customqueriesdirectory.
    Manually copy this folder and its contents to a safe location.

Migrate and install the software

  1. Install MS SQL Server on the new server.
  2. If the RUM Console is also moving to the new machine, install is on the new machine now.
  3. Install the CAS on the new machine.
    It is important that you install exactly the same CAS version (and service packs, if they were present) that you had previously. For more information, see Install CAS.
  4. On the old machine, stop and disable CAS service, SQL Server service, and RUM Console service.
    The rest of this procedure applies to the new machine.

Restore the data and get the new CAS installation running

After the target environment is ready, restore your data and bring the CAS back up.

  1. Restore the RUM Console database.
    For more information, see Complete RUM Console backup and restore

  2. Stop and disable the CAS service.

  3. Restore the CAS database from the backup you made earlier.

  4. Restore the entire %programfiles%\cas\config\ folder from your backup.
    Manually copy the backup files you made earlier back to the target installation.

  5. Restore the entire %programfiles%\cas\classes\customqueriesfolder from your backup.
    Manually copy the backup files you made earlier back to the target installation.

  6. Open %programfiles%\cas\config\repository.properties and make sure that the JDBC_URL property is set to localhost and it points to the restored database.

    Example:

    JDBC_URL=jdbc:jtds:sqlserver://localhost:1433//CAS;tds=8.0;lastupdatecount=true;

  7. Start the CAS service.

  8. Add or correct all necessary devices in the RUM Console configuration.
    If your new CAS is to be the source of time configuration for AMDs, open the configuration of each AMD and set the “IP address of the server authorized to set AMD time” accordingly.