2

I have SQL server 2008 R2 standard in house server and want to move my database to SQL 2019 Web edition in VM in AWS cloud. Can I just backup database and restore it there? would that work? or standard edition can only be restored to standard not web edition? Database is not that big, under 30GB.

Your help would be highly appreciated.

Thanks

Improve this question
1

1 Answer 1

Reset to default
1

You can restore older versions of SQL Server databases to newer versions. This is how a lot of people upgrade their instances - build a new one and transfer the databases over.

The supported SQL upgrade paths for SQL Server 2019 are here: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15#migrate-to-sql-server-2019 -- note even though SQL Server 2008 R2 is not explicitly listed, it is mentioned that you can do a backup/restore to a 2019 instance.

Improve this answer
3
  • Thank you Mark, yes I saw that link and it does say we can migrate sql 2008 r2 to sql 2019 by manual backup and restore, the confusion I have is between the editions? from standard Edition to Web edition because web edition is only available in clouds and lot cheaper than standard edition. So will that work too? or my destination sql must be standard too? Commented Feb 2, 2022 at 1:01
  • The database will certainly be portable, different SQL editions are often just additional features and hardware licensing. The core database is the same in all editions (exception of Express which has a size limitation) Commented Feb 2, 2022 at 23:19
  • Ok thank you Mark, I'm gonna try and let's see how it goes. Appreciate it. Commented Feb 7, 2022 at 3:34

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.