Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X
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
Solved! Go to 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.)
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.)