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.
Specify a port value as part of the database server address when you run the pre-migration task, for example if you used the following or similar syntax to enter the SQL instance:
For related information, see Run the Pre-Migration Task.
Finish running the pre-migration task. See Run the Pre-Migration Task.
Finish restoring the source database over the target system database. See Replacing the Target vRealize Automation Database with the Source vCloud Automation Center 5.2 Database.
- Open SQL Management Studio.
- Locate and open the restored SQL database in the target vRealize Automation.
- Create a new query and cut and paste the following line into the query.
UPDATE [DynamicOps.Migration].[Properties] SET [Value] = '"' + [Value] + '"' WHERE [Key] = 'SourceDatabaseAddress'
- (Optional) Save the query.
- 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.
- Verify that the value of the SourceDatabaseAddress property in the DynamicOps.Migration.Properties table contains the quotation mark characters.
When you run the migration task, the correct port value is processed.