Making MSSQL as persistent provider for Thing Worx with PostgressSQL setup

[SV_10197221]

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

[VladimirRosu · Accepted solution]

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.)