Q. Windows Server 2019 upgrade error

Question

question

06663949 asked Apr 27, '22 DSPatrick commented May 1, '22

I have a question. Help me.

Upgrading server

The in-progress details are: (Windows server 2008 R2 → Windows server 2012 → Windows server 2016 → Windows server 2019)

I have completed until the current Windows server 2016.

When I upgrade from the current Windows server 2016 to the 2019 version, it turns out that I failed as it became 100%.

Please teach me the way.

and

To ask you a further question,

Likewise, we upgraded sql server 2008 to sql server 2019 version, but will the script contents of the procedure be changed?

'uses the old style join syntax which can have poor performance at database compatibility level 90 and higher' This will be displayed.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-27T08:19:29.417Z

OlafHelper-2800 answered Apr 27, '22

'uses the old style join syntax which can have poor performance at database compatibility level 90 and higher'

Regarding SQL Server and that message.
"Old style join" is a deprecated feature and not longer supported in version 2019; you have to modify your SQL code.
See https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-deprecated-features-object?view=sql-server-ver15
=> Non-ANSI = or = outer join operators

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-04-27T14:25:32.107Z

DSPatrick answered Apr 27, '22 DSPatrick commented May 1, '22

The much cleaner / safer / less problematic method is to stand up a new 2019, patch fully, then migrate the roles / applications over to it. You can also review the log files here.
https://docs.microsoft.com/en-us/windows/deployment/upgrade/log-files.

--please don't forget to upvote and Accept as answer if the reply is helpful--

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick · May 01 at 11:53 AM

Just checking if there's any progress or updates?

--please don't forget to upvote and Accept as answer if the reply is helpful--

0 ·