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

Moving ThingWorx Database to Azure

  • March 28, 2022
  • 1 reply
  • 1142 views

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

Best answer by kazunari

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# 

1 reply

K
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# 

S
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.

Terms & ConditionsAccessibility statement