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

posta un anno fa653 visualizzazioni
2 Risposte
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
ESPERTO
con risposta un anno fa
  • 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
ESPERTO
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande