Thanks for your response. But here I am trying to move ThingWorx Foundation from Microsoft SQL to PostgreSQL and not upgrade per say. My requirement is such that business wants to move from using Microsoft SQL to PostgreSQL.

J

Jimwang

Answer

16-Pearl

Assume:

Source system: Thingworx + MSSQL

Target system: Thingworx + Postgresql

Steps:

1) Export the entities and data from the source system refer to https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Getting_Started/ImportingandExportinginThingWorx/ImportingandExportingDataEntitiesandExtensions.html#wwID0E6OJX

2) Copy the exported entities and data to the target system

3) Import the entities and data to the target system refer to the above URL.

C

Chiranjit_994

Author

4-Participant

So, the suggestion is we do a fresh ThingWorx installation with PostgreSQL and do the steps mentioned by you?

J

Jimwang

16-Pearl

Yes

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded