0

I am running existing legacy applications in production using an older version of SQL Server 2008 R2 Standard Edition, my goal here is to perform an inline/in-place upgrade to SQL Server 2019 Standard Edition while retaining the same IP address and the server name.

How can I achieve this with minimal downtime?

Do I install the new SQL Server 2019 in the same server, and then use https://docs.dbatools.io/#Start-DbaMigration?

However, from the article: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?redirectedfrom=MSDN&view=sql-server-ver15#upgrades-from-earlier-versions-to-

I cannot see the SQL Server 2019, only SQL Server 2008R2 to SQL Server 2016

I look forward to your reply.

Improve this question
2
  • 1
    Why do you want to keep same hostname and IP? You can use cliconfg for client-side aliases, or create an A-record / CNAME for the old name for the new IP address.
    – vonPryz
    Jan 18 at 6:51
  • \@vonPryz so what are the steps to use the cliconfg utility from the server side ?
    – Senior Systems Engineer
    Jan 18 at 13:05

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.