topic Re: ms sequel server on Linux in Windchill

ms sequel server on Linux

rleir — Thu, 18 May 2023 09:51:24 GMT

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

Re: ms sequel server on Linux

VladimirN — Thu, 18 May 2023 09:47:11 GMT

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

Re: ms sequel server on Linux

rleir — Thu, 18 May 2023 09:54:44 GMT

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

Re: ms sequel server on Linux

VladimirN — Thu, 18 May 2023 10:02:15 GMT

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

Re: ms sequel server on Linux

rleir — Thu, 18 May 2023 10:29:19 GMT

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

Re: ms sequel server on Linux

HelesicPetr — Thu, 18 May 2023 10:45:49 GMT

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

Re: ms sequel server on Linux

rleir — Thu, 25 May 2023 16:26:33 GMT

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#

Re: ms sequel server on Linux

HelesicPetr — Fri, 26 May 2023 05:51:00 GMT

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