Skip to main content
R
rleir17-Peridot
17-Peridot
May 18, 2023
Question

ms sequel server on Linux

  • May 18, 2023
  • 2 replies
  • 2275 views

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

 

2 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
May 18, 2023

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

R
rleir17-PeridotAuthor
17-Peridot
May 18, 2023

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

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
May 18, 2023

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

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
May 18, 2023

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

R
rleir17-PeridotAuthor
17-Peridot
May 25, 2023

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
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
May 26, 2023

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

Terms & ConditionsAccessibility statement