ms sequel server on Linux

[rleir]

Team

The req'ts for DB for WC (12.0.2.11) are:

• MS SQL Server Enterprise & Standard 2016+
• MS SQL Server Enterprise & Standard 2017+
• MS SQL Server Enterprise & Standard 2019
• Oracle 18c Enterprise & Standard 18.3.0.0.0+
• Oracle 19c Enterprise & Standard 19.0.0.0.0+

Does this assume that MS SQL is running on Windows? Who has experience running MS SQL on Linux? Redhat says it is a good choice:

https://www.redhat.com/en/explore/microsoft-sql-server-on-rhel

https://www.redhat.com/en/technologies/linux-platforms/enterprise-linux/sql-server

MS says some features are not supported:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2022?view=sql-server-ver16#unsupported-features-and-services

I prefer Linux and would like to know your experiences

cheers -- Rick

[VladimirN]

For Linux you can also consider as an option - PostgreSQL.

[rleir]

For ThingWORx, yes. But for Windchill? Are you sure? ( I hope you are right).  Are the published req'ts incorrect?

[VladimirN]

"PostgresSQL Database to be Supported for Windchill": https://community.ptc.com/t5/Windchill-Ideas/PostgresSQL-Database-to-be-Supported-for-Windchill/idi-p/464274

[rleir]

Let's not talk about Postgres here.

The question is about WC 12.0.2.11 running with MS SQL: who has experience running the MS SQL DB on Linux?

thanks -- Rick

[HelesicPetr]

Hi @rleir 

I am sure that 2017 is supported. 

The best thing is to try installing the MSSQL on the linux. 

It is possible.

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver16

Some features are not supported but are not supported  features really so needed for Windchill? I don't think so . 

so go for it.

PetrH

[rleir]

the PTC guide to configuring MSSQQL (link below) says you should use the Windows collation (otherwise known as a character set) Latin1_General_100_CS_AS_SC.

But we have Windchill on RedHat, and MSSql on RedHat ... why would we want to use a Windows collation?

This Latin1_General_100_CS_AS_SC represents a base collation of 

   Latin1_General_100 

with some modifiers:

•  Case-sensitive, 
• Accent-sensitive and 
• Supplementary characters

Just maybe this results in a Linux-friendly collation? 

https://support.ptc.com/help/windchill/r12.1.2.0/en/index.html#page/Windchill_Help_Center/WCInstallConfigGuide/WCInstall_SQLBeforeBegin.html#

[HelesicPetr]

Hi @rleir 

a general answer is because Microsoft 😄  

I set the collection manually in the past if the collection was not in the list that PTC guide mention to use with MSSQL.  

Latin1_General_100 with correct set CS AS SC is ok to use in my opinion.

PetrH