Skip to main content
steve23714-Alexandrite
14-Alexandrite
March 28, 2022
Solved

Moving ThingWorx Database to Azure

What modifications must be done to move an existing ThingWorx platform and a thingworx database (SQL) from an on-prem data center to Azure?  Is this even possible, or do we have to start with new installs?

 

Thanks,

Steve

kazunariAnswer
12-Amethyst
March 30, 2022

Hi, are you planning to migrate your environment to Azure VM's? There is are some options for migrating. Please take a look at below help center it might help you.

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Installation/Installation/manual_migration_to_thingworx_9x_windows.html# 

View in thread

2 replies

kazunari12-AmethystAnswer
12-Amethyst
March 30, 2022

Hi, are you planning to migrate your environment to Azure VM's? There is are some options for migrating. Please take a look at below help center it might help you.

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Installation/Installation/manual_migration_to_thingworx_9x_windows.html# 

Translate
steve23714-AlexandriteAuthor
14-Alexandrite
April 5, 2022

kazunari, thanks for the link.

 

I read that article before posting the question, however, it is very incomplete and misleading (a common issue with a lot of the thingworx documentation).  The manual in-place upgrade instructions (listed above your link in the contents section) include scripts to run to modify the existing database schema.  This article doesn't even mention the database, so I assumed that we could just migrate our existing MSSQL database to AzureSQL.  That didn't work.  So, I entered a support ticket.  The support engineer explained that moving from MSSQL to AzureSQL requires a new AzureSQL database to be built just as you would with a brand new install.  The instructions also don't mention that you must add the AzuresqlPersistendProviderPackage to the platform-settings.json.

Translate
Terms & ConditionsAccessibility statement