Upgrade SQL Server 2017 to SQL Server 2019 on EC2

0

What are the steps to upgrade a SQL Server 2017 database instance on EC2 to SQL Server 2019 on EC2

asked a year ago628 views
2 Answers
0

In this case forget that it’s an EC2. It’s a Self managed SQL server on a windows server. Same upgrade process applies to any local install of SQL server.

Follow Microsoft published processes.

profile picture
EXPERT
answered a year ago
  • Are the AWS AMI's which include SQL considered a self managed SQL server? If that is the case we can update the OS and SQL as needed?

  • The AWS AMI is a self managed SQL Server instance. I ran the AWSEC2-CloneInstanceAndUpgradeSQLServer automation feature but got a failed error message about wrong SQL Server Version 14 despite my source version being 2017 and target version 2019. I wonder if anybody has come across that error.

  • @rePost-User-4900275 I'm running into the same problem. Did you find a solution?

0
profile picture
EXPERT
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions