Install Separate Thingworx Database

[AliBenBelgacem]

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 

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