Skip to main content
V
vi116-Pearl
16-Pearl
February 2, 2021
Solved

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

  • February 2, 2021
  • 1 reply
  • 1980 views

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

Best answer by vi1

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

 

 

1 reply

O
odukiya16-Pearl
16-Pearl
February 2, 2021

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

V
vi116-PearlAuthorAnswer
16-Pearl
February 3, 2021

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

 

 

V
vi116-PearlAuthor
16-Pearl
February 3, 2021

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

 

Terms & ConditionsCookie settingsAccessibility statement