Replacing the target SQL database with the source SQL database is the last manual task you need to perform before you start the vRealize Automation migration task. The migration task upgrades the replaced database.

Replace the database before migration. For information about the required order of operations to be performed before you start migration, see Performing Manual Operations After Pre-Migration.

The database name must remain constant. For example, if the target database name is database_name_abx, the source database must also be named database_name_abx.

This task assumes that you are using the step sequence published by Microsoft to back up and restore a SQL database by using Microsoft SQL Server Management Studio.

The procedure to back up and restore a SQL database is described in the following Microsoft Developer Network documentation topics.

  • Back Up and Restore of SQL Server Databases

  • Create a Full Database Backup (SQL Server)

  • Restore a Database Backup (SQL Server Management Studio)

Important:

After you replace the database, do not rerun pre-migration.

  1. Verify that the source and target Model Manager Web Service are online.

  2. Log in to Windows by using your Domain or SQL administrator credentials.

  3. Verify that IIS service is not running on the target Web site Host machine.

    Communication between the target database and its components must be stopped during this procedure.

  4. Replace the target vRealize Automation SQL database with the source vCloud Automation Center 5.2 SQL database using your preferred method.

    The following example procedures are provided for reference purposes. Your procedure might vary.

  5. After you have replaced the database, restart the IIS service on the target Web site Host machine before you start the migration task.

  6. Verify that the Iaas Component services remain stopped while you run the migration task.