question

06663949 avatar image
0 Votes"
06663949 asked DSPatrick commented

Q. Windows Server 2019 upgrade error

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.


windows-serverwindows-server-2019windows-server-2016sql-server-migration
5 |1600 characters needed characters left characters exceeded

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

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

'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

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

DSPatrick avatar image
0 Votes"
DSPatrick answered DSPatrick commented

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

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

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 Votes 0 ·