Summary

This article explains how to transfer your adTempus installation from one computer to another.

Overview

The process of transferring an adTempus installation involves the following steps:

  1. Copying instance configuration data
  2. Installing the software
  3. Registry configuration
  4. Transferring the Captured File data
  5. Transferring the database

Preventing Duplicate Job Execution

Before beginning the migration process, review Preventing duplicate job execution during server migration to ensure that you do not end up with jobs running on both servers at the same time.

Copying instance configuration data

A few bits of important information configuration information are stored in the Registry and should be copied over.

  1. On the source computer, run the Registry Editor and go to "HKEY_LOCAL_MACHINE\SOFTWARE\Arcana Development\adTempus\Instances". Right-click this key and choose Export, then export to a file.
  2. On the target computer, run the Registry Editor and select Import from the File menu, then import the file you created in step 1.

Installing the Software

Download the appropriate version of adTempus and install it on the target computer, choosing the same engine mode options as on the source computer.

Licensing

At the end of the software installation process, the License Activation wizard will start. You will not be able to take advantage of the default 30-day evaluation period, because the "installation" date that adTempus uses to calculate the evaluation period is stored in the database, and thus will be the date of the original installation on the source computer.

You may use any of the following approaches to licensing:

A. Use an extra license

If you have an extra adTempus license in your license account, you can use that license to activate the target computer.

B. Reuse existing license from source computer

If you no longer need to run adTempus on the source computer, you can immediately reuse your existing license from that computer. To do this, run the License Manager tool from the adTempus program group on the source computer. Select your adTempus license, right-click it, choose the Remove option, and follow the instructions to return the license to your account for reuse. On the target computer, you can now activate the computer using this license.

Note: Once you have deactivated the source computer, adTempus will continue to function normally until the next time the adTempus service is restarted. At this time, it will fail to start because you will no longer have a valid license on the source computer.

C. Use a temporary license

If you are not able to reuse the license from the source computer, you can get a 30-day temporary license. To do this, choose the "Continue Evaluation" option in the License Wizard, then complete the remaining software installation steps.

After installation is complete, run the License Manager from the adTempus program group and choose the "Get a temporary license" option from the "License" menu. Complete the steps to activate the computer using a 30-day temporary license.

Before the 30 days have elapsed, you will need to transfer the license from another computer (as described in option B above), or purchase an additional license.

Database Configuration

After the License Wizard finishes, the Database Configuration wizard will run.

  • If you are currently using the default SQL Server Express database on the source computer, follow the wizard steps to install and configure SQL Server Express on the target computer. This will create a new, empty adTempus database on this computer.
  • If you are currently using a standalone SQL Server database instance, you will configure the target computer to connect to your existing database. Cancel the database wizard at this time. Note that the adTempus service will fail to start after installation completes, because no database has yet been configured.

Transferring the Captured File Data

The files that adTempus has captured and stored as part of your job history are stored outside the database and therefore must be copied separately to the new computer.

On the source computer, use Windows Explorer to navigate to the folder "C:\Program Files\Arcana Development\adTempus\Instances\Default\Data". Copy the "CapturedFiles" folder to the "C:\Program Files\Arcana Development\adTempus\Instances\Default\Data" folder on the target computer. This folder contains the contents of all files captured by adTempus.

Transferring the Database

The procedure for transferring the database depends on whether you are using the default SQL Server Express database, or a standalone SQL Server instance.

SQL Server Express

If you are using the default SQL Server Express database on the source, you will copy the database to the target computer:

  1. Stop the adTempus service on the source computer.
  2. On the source computer, run the adTempus Database Utility found in the adTempus group on the Start menu.
  3. In the adTempus Database Utility, choose the Backup Database option on the Tools menu.
  4. Follow the on-screen instructions to create a backup of the database.
  5. If necessary, copy the backup file to a location that is accessible to the the target computer.
  6. Stop the adTempus service on the target computer.
  7. On the target computer, run the adTempus Database Utility.
  8. In the adTempus Database Utility, choose the Restore Database option on the Tools menu.
  9. Follow the on-screen instructions to restore the data into the adTempus database.
  10. Start the adTempus service on the target computer using the startup option "-resetdbowner". If the service fails to start due to a database login error, refer to article K00000481.

The source and target computers now have independent copies of the adTempus database, and both instances can continue to operate if you wish.

Standalone SQL Server Instance: Reuse Existing Database

If you are using a standalone SQL Server instance to host the adTempus data, and you will no longer be running adTempus on the source computer, you can simply configure the adTempus instance on the target computer to use the existing adTempus database. It is not necessary to copy any data.

Note: Once you point the new adTempus instance at the existing adTempus database, you must not continue to run adTempus on the source computer. Having two adTempus instances pointing at the same database will result in data corruption and incorrect operation of adTempus. If you need to continue running adTempus on the source computer, you must create a copy of your database as described in the next section.

To transfer the database to the target computer:

  1. Stop the adTempus service on both the source and target computers.
  2. On the source computer, run the Registry Editor and navigate to key "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\Instances\Default\Database".
  3. Right-click the "Database" key and choose the Export option to create an export of the key.
  4. Once the export is complete, right-click the "Database" key and choose the Delete option. This will ensure that the adTempus instance on the source computer cannot be inadvertently started against this database.
  5. On the target computer, run the Registry Editor.
  6. Choose the Import command from the File menu and import the export file created on the source computer.
  7. Start the adTempus service on the target computer using the startup option "-resetdbowner". If the service fails to start due to a database login error, refer to article K00000481.

The target computer is now using the same database that the source computer was using. The adTempus instance on the source computer has been disabled, as you cannot have two adTempus instances using the same database.

Standalone SQL Server Instance: Duplicate Database

If you are using a standalone SQL Server instance to host the adTempus data, and you want to be able to continue running adTempus on the source computer in addition to the target computer, you must make a copy of the adTempus database to be used by the adTempus instance on the target computer. This is necessary because two adTempus instances cannot share the same database.

To do this, use the "Copy Database" option in SQL Server Management Studio to make a copy of your existing adTempus database.

After copying the database you must also copy the database connection and login information for adTempus:

  1. On the source computer, run the Registry Editor and navigate to key "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\Instances\Default\Database".
  2. Right-click the "Database" key and choose the Export option to create an export of the key.
  3. On the target computer, run the Registry Editor.
  4. Choose the Import command from the File menu and import the export file created on the source computer.
  5. Edit the "Database" value and change it to the name of the new database you created.
  6. Make a note of the "userID" value under the "Database" key.
  7. In SQL Server Management Studio, expand the node for the new database, then go to the Security/Users node.
  8. Right-click the Users node and select New User....
  9. Enter the user ID you noted in step 6 for both the User name and Login name fields.
  10. In the Database role membership list, check the boxes next to the following roles:
    • db_datareader
    • db_datawriter
    • db_backupoperator
  11. Click OK to save the user.
  12. Start the adTempus service on the target computer using the startup option "-resetdbowner". If the service fails to start due to a database login error, refer to article K00000481.