Skip to main content
A
AliBenBelgacem14-Alexandrite
14-Alexandrite
September 4, 2024
Solved

Install Separate Thingworx Database

  • September 4, 2024
  • 1 reply
  • 686 views

Hello,

 

For best practice reason, I am trying to install a second thingworx database for my project.

I will have a first database dedicated to my thingworx instance.

All data (stream, value stream , datatable..) will be installed in separated database : 'project_db'

So the idea is to use thingworx script to install the second database, i am using this article as a starting point :

https://www.ptc.com/en/support/article/CS262935 

the scripts are:

  1. thingworx-model-schema.sql
  2. thingworx-property-schema.sql
  3. thingworx-data-schema.sql
  4. thingworx-grants-schema.sql

 

My questions are :

 

  1. Do I need to install all thingwrox db scripts to install the second database, or I just need to install only thingworx-data-schema.sql script since we only need to store data ?
  2. If I have to install only thingworx-data-schema.sql, I notice a lot of table created ? Do I need them all or just a few tables? Can I clean the database and keep only needed tables, if yes witch tables should I keep ?
  3. The article I am following is dedicated to versions 8.5 to 9.4. I am using 9.5.1 version. is it OK ? I didn't find on official documentation any articles related to this version.

Thank you for your help 

 

 

 

 

 

Best answer by Rocko

1) You will have to install all scripts. Also makes updating the DB easier later on.

2) Why would you want to clean the DB? It would be a) unsupported then and b) if tables aren't used later on, how much do you save by deleting them, 1kb?

3) That's a question for support, but as 9.5 release notes do not mention anything about it it's a safe bet the mechanism wasn't changed, so go ahead.

1 reply

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
September 4, 2024

1) You will have to install all scripts. Also makes updating the DB easier later on.

2) Why would you want to clean the DB? It would be a) unsupported then and b) if tables aren't used later on, how much do you save by deleting them, 1kb?

3) That's a question for support, but as 9.5 release notes do not mention anything about it it's a safe bet the mechanism wasn't changed, so go ahead.

    Terms & ConditionsCookie settingsAccessibility statement