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

demandé il y a un an653 vues
2 réponses
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
répondu il y a un an
  • 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
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions