If you specify a port value as part of the database server address during pre-migration, you must update the database before you can successfully run the migration task.

About this task

If you specified a port value as part of the database server address during pre-migration, the migration task fails with an MSBUILD : error MSB1006: Property is not valid error. A parsing problem occurs during migration with the comma-separated FQDN and port number. Avoid, or later correct, the problem by running a specially formatted query in SQL Management Studio before you run the migration task.

Prerequisites

Procedure

  1. Open SQL Management Studio.
  2. Locate and open the restored SQL database in the target vRealize Automation.
  3. Create a new query and cut and paste the following line into the query.
    UPDATE [DynamicOps.Migration].[Properties] SET [Value] = '"' + [Value] + '"' WHERE [Key] = 'SourceDatabaseAddress'
  4. (Optional) : Save the query.
  5. In SQL Management Studio, select your database from the drop-down menu and click Execute to run the query against the database.

    The query wraps the FQDN, port_number value in quotation mark characters so that the ,port_number string to the right of the FQDN value is correctly parsed along with the FQDN value.

  6. Verify that the value of the SourceDatabaseAddress property in the DynamicOps.Migration.Properties table contains the quotation mark characters.

Results

When you run the migration task, the correct port value is processed.