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]

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.