You can migrate your VMware vRealize ™ Automation 6.2.x environment to a new installation of vRealize Automation 7.1 with a manual backup of the vRealize Automation 6.2.x IaaS Microsoft SQL database.

About this task

This procedure is more dependable for transferring large amounts of data and is the preferred procedure for migration. You must make a full Microsoft SQL database backup and use the backup to restore the database to a new location. For information, see these Microsoft articles:

Procedure

  1. Create a full database backup of the source vRealize Automation 6.2.x IaaS Microsoft SQL database.
  2. Restore the backup as a new database on the Microsoft SQL Server in the target vRealize Automation 7.1 environment.
  3. Obtain the encryption key from your source vRealize Automation 6.2.x deployment.
    1. Run the following command in an administrative command prompt on the virtual machine that hosts active Manager service to obtain the encryption key.

      C:\Program Files (x86)\VMware\vCAC\Server\ConfigTool\EncryptionKeyTool\DynamicOps.Tools.EncryptionKeyTool.exe" key-read -c "C:\Program Files (x86)\VMware\vCAC\Server\ManagerService.exe.config" -v

      If your installation directory is not in the default location, C:\Program Files (x86)\VMware\vCAC, edit the path to your actual installation directory.

    2. Save the key that appears on the screen after you run the command.

      The key is a long string of characters that looks similar to this example:

      NRH+f/BlnCB6yvasLS3sxespgdkcFWAEuyV0g4lfryg=

  4. In your target vRealize Automation 7.1 environment, open the management console for your virtual appliance by using the fully qualified domain name of the virtual appliance: https://va-hostname.domain.name:5480.
  5. Log in with the user name root and the password you specified when the appliance was deployed.
  6. Select vRA Settings > Migration.
  7. On the Migrate from an existing vRA installation page of the management console, leave the Auto Clone Source IaaS DB check box deselected. Select or deselect the Enable SSO2 migration check box according to how you migrated your tenants and identity stores.
  8. Enter the requested information for Source vRA SSO2 Appliance.

    Option

    Description

    Host name

    Host name for the source vRealize Automation 6.2.x SSO2 Identity Server.

  9. Enter the requested information for Source vRA Appliance.

    Option

    Description

    Host name

    Host name for the vRealize Automation 6.2.x appliance.

    Root username

    root

    Root password

    Root password that you entered when you deployed the vRealize 6.2 appliance.

    Re-enter password

    Re-enter root password.

  10. Enter the requested information for the Target vRA Appliance

    Option

    Description

    Default tenant

    Tenant you created when you configured single sign-on in the installation wizard, for example, vsphere.local.

    Administrator username

    Default tenant administrator user name that you entered when you deployed the vRealize 7.1 appliance, for example, administrator@vsphere.local.

    Administrator password

    Administrator password that you entered when you deployed the vRealize 7.1 appliance.

    Re-enter password

    Re-enter administrator password.

    Root username

    root

    Root password

    Root password that you entered when you deployed the vRealize 7.1 appliance.

    Re-enter password

    Re-enter root password.

  11. Enter the requested information for Source vRA IaaS Database Server.

    Option

    Description

    Encryption Key

    Encryption key string from your source vRealize Automation 6.2.x deployment.

  12. Enter the requested information for Target vRA IaaS Database Server.

    Option

    Description

    Database Host Name

    Name of the vRealize Automation 7.1 IaaS Microsoft SQL database host.

    New Database Name

    Name of the Microsoft SQL database you restored on the target vRealize Automation 7.1 environment.

    Passphrase

    New passphrase to re-encrypt sensitive content stored in migrated Microsoft SQL database. A passphrase is a series of words used to generate an encryption key to protect data while at rest in the database, such as endpoint credentials. You use this passphrase each time you install a new IaaS component.

    Database Security

    SQL Server authentication mechanism. Select Windows Authentication or SQL Authentication. If you select SQL Authentication, you must enter a user name and password.

    If the vRealize Automation 6.2.x database and the 7.1 database are on different domains, Windows authentication fails.

  13. Click Migrate.

    Migration Status shows the migration progress and displays a message when migration is finished.

    More migration details are contained in the following log files. You can tail these log files to observe the migration progress.

    • vRealize Automation 6.2.x virtual appliance: /var/log/vcac/migration-package.log

    • vRealize Automation 7.1 virtual appliance: /var/log/vcac/migrate.log

    • IaaS nodes: C:\Program Files (x86)\VMware\vCAC\InstallLogs-YYYYMMDDHHMMSS\Migrate.log

      The installation directory for the IaaS nodes might be in a non-default location.

  14. Submit your vRealize Automation 7.1 license key.
    1. On the management console, click Licensing.
    2. Enter your vRealize Automation 7.1 license key in the New License Key text box.
    3. Click Submit Key.
  15. If you are migrating to a clustered environment, access the management console on each secondary node and join the secondary node to the master node.
    1. Select vRA Settings > Cluster.
    2. Click Join Cluster.
  16. If you are migrating to a clustered environment, configure each secondary node in the load balancer.

What to do next

Validate the vRealize Automation Migrated Environment