Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
Hi there,
We are hoping to migrate our current TW env out of a Postgres back end and move it into SQL Server. We are running the application on a RHEL7 Linux box. I am finding the PTC installer fails to connect to SQL server.
By using SQLCMD in Linux we can connect to SQL Server using the -C switch which turns off certificate validation. Can this switch be used the installer ?
Solved! Go to Solution.
@CM_10425792, @pshashipreetham,
Because you are moving an application from ThingWorx with Postgresql to ThingWorx with SQL Server, Please review Article - CS303818 - ThingWorx migration from other databases to Microsoft SQL Server
If you have a requirement to move existing data from Postgresql to SQL Server the articles discuss some issues which need to be considered.
HTH
PEHowe
Hi @CM_10425792 ,
Can you share the logs of when this issue occurred? The logs are found in ThingworxStorage Folder---> Logs ---> Application Logs; sharing the Application log or posting the Error that is happening will help.
Thanks,
@CM_10425792, @pshashipreetham,
Because you are moving an application from ThingWorx with Postgresql to ThingWorx with SQL Server, Please review Article - CS303818 - ThingWorx migration from other databases to Microsoft SQL Server
If you have a requirement to move existing data from Postgresql to SQL Server the articles discuss some issues which need to be considered.
HTH
PEHowe