version or edition consideration when SQL Server migrate or upgrade

version or edition consideration when SQL Server migrate or upgrade

如果SQL Server 2000並採用資料庫備份還原來移轉Migration，步驟如下

1.restore to SQL 2008 R2

2.changet db's compatibility level from 80 to 100

3.take a backup

4.restore the backup on SQL Servre 2022 

如果採用原機升級 Upgrade in-place

Supported version & edition upgrades (SQL Server 2019)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15

Upgrades from Earlier Versions to SQL Server 2019 (15.x)

SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server:

• SQL Server 2012 (11.x) SP4 or later
• SQL Server 2014 (12.x) SP3 or later
• SQL Server 2016 (13.x) SP2 or later
• SQL Server 2017 (14.x)

Supported version & edition upgrades (SQL Server 2017)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-ver15

SQL Server 2017 (14.x) supports upgrade from the following versions of SQL Server:

• SQL Server 2008 SP4 or later
• SQL Server 2008 R2 SP3 or later
• SQL Server 2012 SP2 or later
• SQL Server 2014 or later
• SQL Server 2016 or later

Supported version & edition upgrades (SQL Server 2016)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-ver15

SQL Server 2016 supports upgrade from the following versions of SQL Server:

• SQL Server 2008 SP4 or later
• SQL Server 2008 R2 SP3 or later
• SQL Server 2012 (11.x) SP2 or later
• SQL Server 2014 (12.x) or later