Thingworx Upgrade to the 9.7 using Foundation Installer

[pshashipreetham]

Hi, 

I was researching how to upgrade from 9.0 to 9.7. The use case for this is to use the Foundation Installer instead of the WAR file installation. 

As far as I know, the Foundation installer requires an empty database to proceed with the installation. So, in this case, how can I attach the Upgraded DB to the Foundation Installer?

Currently, I plan to use an empty database for installation. Once PTC ThingWorx 9.7 is installed, I will update the database configuration in the Platform-settings.json file to reflect the upgraded database. Will this work?

Thingworx Version: 9.0.0

Thanks,

[AdamK_93]

Hello @pshashipreetham ,

As per the Upgrade steps, described by PTC, from 9.0 you need to upgrade to an intermediate version e.g. 9.4 and then upgrade to 9.7 (using installers in both cases). You don't need separate empty database to proceed with.

This covers all the steps you would nee to take care of I belive. >>> Installer Upgrade (Thingworx 9.7) 

We did the same without having empty db, so hope it helps a bit.

Regards,

Adam

[Jimwang]

If source system 9.0 is installed via Foundation Installer, you can use Foundation Installer for the Upgrade, otherwise, you can't use Foundation Installer for the Upgrade.

It is required to upgrade through an intermediate version from 9.0 to 9.7, for detailed guide, refer to Upgrade Overview. 

[pshashipreetham]

Hi @Jimwang , 

Thanks for the response. The present system is installed with Foundation, and the version is 9.1. If I directly download the 9.7 installer and attempt to install it, will it upgrade from 9.1 to 9.7, including the schema in the DB?

Thanks, 

[Jimwang · Accepted solution]

No, if source system is 9.1, you can not upgrade to 9.7 directly refer to Supported Upgrade Path. You can upgrade to an intermediate phase like 9.3 firstly, and then upgrade to 9.7

[TonyZhang]

Hi @pshashipreetham,

It appears that a response this post answers your question.  For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

In the event that this response did not answer your question, please post your current status so that we can continue to support.

Thanks for using the PTC Community!

Regards,

[avillanueva]

A bit of feedback on current installer instructions. Terrible. Spun my wheels for weeks trying to figure out the right path. I ended up installing 9.7 from scratch and using export/import to bring custom stuff over. In my case, what's missing is the practical aspects of upgrades. Screenshot, step by step instructions. Information about alternate paths. When changing versions, you often are upgrading underlying OS, Java and DB components in a rehearsal mode. This means having to create clones or rehost and practice steps if you were to upgrade in place like we can do now. Couple the fact that we are likely connecting to a Windchill system that is also a rehearsal instance. I think I hit every possible error along the way, often being left in a questionable state and having to start all over again.