Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
Has anyone tried to migrate ThingWorx from Microsoft SQL server to PostGreSQL. Currently we are using ThingWorx 9.4.2 version.
Please refer below links
Windows - Manual Migration to ThingWorx 9.x: Windows (ptc.com)
Linux - Manual Migration to ThingWorx 9.x: Linux (ptc.com)
/VR
Hello Velkumar,
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.
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.
So, the suggestion is we do a fresh ThingWorx installation with PostgreSQL and do the steps mentioned by you?
Yes
Okay ... I will try it and let know the findings.