Migration from Thingworx MSSQL 8.5.1 to Thingworx AZure SQL 8.5.1(single instance)

[vi1]

Hello,

Can you provide the steps how to migrate the existing Thingworx version 8.5.1 MSSQL to Thingworx version 8.5.1 Azure SQL(single instance)?

Thanks&Regards,

Latha

[odukiya]

Hello @vi1 

Please refer the following communtiy post. For your answer please check point no 8 in the post

https://community.ptc.com/t5/IoT-Tech-Tips/10-FAQs-on-ThingWorx-with-Azure-SQL/m-p/619921

Please let me know in case it doesn't resolve your query.

Thanks

Om Dukiya

[vi1 · Accepted solution]

Hello Om,

Thank you for response.

As mentioned in document , we have to go with Azure SQL Managed instance to upgrade from MSSQL to AZure SQL. But We have selected Azure SQL single instance option so we will go with general thingworx migration process like import the existing entries and data after connecting to Azure SQL.

Regards,

Latha

[vi1]

Hello Om,

Migrated from Thingworx 8.5.1 MSSQL to Thingworx 8.5.1 Azure SQL successfully. Observed License file name is "ignored_license_capability_response" but License subsystem is showing that License expires in 726days. Imported all the entities and data into thingworx successfully. Do we need to generate the license key again?

I have opened support case: 15742125

Regards,

Latha

 

[odukiya]

Hello @vi1 

I am not sure how come even after license_capability_response.bin get ignored it is still showing 726 days to expire license. Because it is expected to have successful_license_capability_response.bin for valid license. As you have already opened a support case with us, TSE will definetly help you to troubleshoot the issue.

If you feel your question has been answered, please mark the appropriate solution as accepted. If you have further question please feel free to revert.

Thanks

Om Dukiya