Moving ThingWorx Database to Azure

[steve237]

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

[kazunari · Accepted solution]

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# 

[steve237]

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.