SQL Database migration

Question

Experts,

I have to migrate databases from SQL 2017 to 2019. The databases contain a mix of 2008,2012,2014 as well 2017 in backward compatibility.
Please advise if liable to face any issues when migrating in backward compatibility. Do I need to run DMA
Would the application face any compatibly issues or would it not as running in backward compatibility

Answer 1

Do I need to run DMA

It's not mandatory for migration, but you should to avoid possible issues before you begin the migration.

Would the application face any compatibly issues or would it not as running in backward compatibility

We can not say, because we don't know the application and which T-SQL statement / features it is using.
Some old feature are deprecated, removed or have different behaviour in new version.
See e.g. Breaking Changes to Database Engine Features in SQL Server 2017 (14.x)

Answer 2

Thanks , but is an assessment required if we are migrating in backward compatibility

Answer 3

Hi,

>The databases contain a mix of 2008,2012,2014 as well 2017 in backward compatibility

SQL Server 2019 is backwards compatible for the below SQL Server versions:

SQL Server 2019 (150)
SQL Server 2017 (140)
SQL Server 2016 (130)
SQL Server 2014 (120)
SQL Server 2012 (110)
SQL Server 2008/R2 (100)

The minimum version of SQL Server 2019 for backward compatibility is SQL Server 2008/R2 (100).

You can always run DMA to do an assessment for migration or use it to migrate multiple databases. This is an easy-to-use and helpful tool.