Skip to main content
S
SV_1019722111-Garnet
11-Garnet
May 9, 2022
Solved

Making MSSQL as persistent provider for Thing Worx with PostgressSQL setup

  • May 9, 2022
  • 1 reply
  • 855 views

Hi,

 

I have done a Thingworx-PostgresSQL setup. Now I want to make MSSQL as the default persistent provider for the Thing Worx.instance.

- I have installed MSSQL and have the necessary schema and database required for the THingworx.

- Now I am trying to create a new persistence provider for MSSQL and set it as the default Persistence provider.

 

But while creating the Persistence provider its asking for Persistence Provider Package. On selecting the add sign i can only see the package for postgress sql and Influx but not for MSSQL.

 

Now how do i get MSSQL package so that I can create a Persistence provider for MSSQL.

 

Thanks

 

 

 

Best answer by VladimirRosu_116627

You can not set MSSQL as a Persistence Provider in a ThingWorx PostgreSQL instance.

ThingWorx installation files (either installer or war file) differs based on the chosen Persistence Provider. We don't have all the persistence providers in a single package.

You must download ThingWorx MSSQL, and only then you can import manually all the entities.

We do not support in-place migration for different persistence providers (MSSQL->PostgreSQL, PostgreSQL->MSSQL, H2->MSSQL etc.)

1 reply

V
VladimirRosu_11662719-TanzaniteAnswer
19-Tanzanite
May 9, 2022

You can not set MSSQL as a Persistence Provider in a ThingWorx PostgreSQL instance.

ThingWorx installation files (either installer or war file) differs based on the chosen Persistence Provider. We don't have all the persistence providers in a single package.

You must download ThingWorx MSSQL, and only then you can import manually all the entities.

We do not support in-place migration for different persistence providers (MSSQL->PostgreSQL, PostgreSQL->MSSQL, H2->MSSQL etc.)

    Terms & ConditionsCookie settingsAccessibility statement