ThingWorx migration from Microsoft SQL Server to PostGreSQL

[Chiranjit_994]

Has anyone tried to migrate ThingWorx from Microsoft SQL server to PostGreSQL. Currently we are using ThingWorx 9.4.2 version.

[Velkumar]

Hi @Chiranjit_994 

Please refer below links

Manual Upgrade (ptc.com)

Windows - Manual Migration to ThingWorx 9.x: Windows (ptc.com)

Linux - Manual Migration to ThingWorx 9.x: Linux (ptc.com)

/VR

[Chiranjit_994]

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.

[Jimwang · Accepted solution]

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.

[Chiranjit_994]

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

[Jimwang]

Yes

[Chiranjit_994]

Okay ... I will try it and let know the findings.

[vnamboodheri]

Hello @CC_10940407, 

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.