Skip to main content
D
dharitac1-Visitor
1-Visitor
July 26, 2018
Question

Migrate Thingworx database to external MySQL

  • July 26, 2018
  • 7 replies
  • 5172 views

I have thousands of data table each with at least 100000 records. Till now I was using Thingworx Internal database and to access data I wrote all services by using built-in snippets given by twx platform for data tables. Now I have to change the framework and the new framework is supposed to use MySQL database. So there any way to migrate all of the Thingworx data to MySQL? 

7 replies

S
supandey5-Regular Member
5-Regular Member
July 26, 2018

Hi @dharitac but MySQL is not supported as persistence provider. Were you using 2 persistence provider previously? What were those? Since DataTable is stored in the persistence provider, to migrate the persistence provider you'll have to run through the Upgrade guide for ThingWorx, it includes the topic on migration as well between different persistence provider.

D
dharitac1-VisitorAuthor
1-Visitor
July 26, 2018

Hi @supandey, best of my knowledge, no persistence provider is used. 

S
supandey5-Regular Member
5-Regular Member
July 26, 2018

There has to be one, you can check that from the ThingWorx Composer > Data Storage > Persistence Proviers

 

You may have to enable the visibility on system objects to be able to see the Persistence Provider by clicking on the Filter and check the Show System Objects to view the entity

Terms & ConditionsAccessibility statement