Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
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
Solved! Go to 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.
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.
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.