Could it be possible to restore the SQL Server 2005 database into the SQL Server 2019

Question

I am using SQL Server 2005 from the year 2010. Now I am wishing to install SQL Server 2019 in the same machine. Is there any problem if I restore the previous version in new version ?

Answer 1

AFAIK you need to make a migration step between to an other version, like 2012 before you can go on to 2019.
See Supported version & edition upgrades (SQL Server 2019) => Migration

"Backup and restore: A backup taken on SQL Server 2008 or SQL Server 2008 R2 can be restored to SQL Server 2019"
But not 2005 backups.

Answer 2

I need to correct Olaf. You can restore a database from SQL 2005 on SQL 2019. I just tested this.

Only if you have a database from SQL 2000, you need to go by an intermediate version, either SQL 2005 or SQL 2008.

Answer 3

Hi PrasantaKumarBiswas-4575,

Welcome to Microsoft Q&A.
In addition, you can use Data Migration Assistant (DMA) to help you migrate SQL Server 2005 database to SQL Server 2019.

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. Please refer to Data Migration Assistant.
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.