question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked Criszhan-msft edited

SQL Database migration

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Vishu-2318 avatar image
0 Votes"
Vishu-2318 answered Criszhan-msft edited

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

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

The compatibility level of the database will not be changed after the migration.

If you restore a full database backup(or attach a database) that was taken on an older version of SQL Server to an instance that is running a newer version of SQL Server, then the database compatibility level will stay the same as it was on the older version of SQL Server, unless the old database compatibility level is lower than the minimum supported database compatibility level for the newer version of SQL Server. In that case, the database compatibility level will be changed to the lowest supported version for the newer version of SQL Server.

0 Votes 0 ·