Solved
ThingWorx migration from Microsoft SQL Server to PostGreSQL
Has anyone tried to migrate ThingWorx from Microsoft SQL server to PostGreSQL. Currently we are using ThingWorx 9.4.2 version.
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.