Upgrade databases from 2012 to 2019

Question

We have databases in SQLserver 2012. We will be creating new servers in 2019 and then we have to migrate 2012 databases to 2019. Checking documents in microsoft found this article https://learn.microsoft.com/en-us/answers/questions/1014987/migration-sql-server-2012-to-2019. Is there any other methods to upgrade databases from one server to another (2012 - 2019)?

Answer 1

Hi Avyayah

thanks for using QandA

As the previous question from ur link, its really straight forward upgrading SQL server from 2012 to 2019, apart from this I don't think there is a process as simple as this.

but ensure a supported upgrade path from SQL Server 2012 to 2019. from the below link

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

for more info follow the documentation below.

https://learn.microsoft.com/en-us/sql/sql-server/migrate/guides/sql-server-to-sql-server-upgrade-guide?view=sql-server-ver16

https://www.dbsection.com/how-to-upgrade-sqlserver-2012-to-2019/

If this helps kindly accept the answer thanks much.

Answer 2

Hi @Avyayah,

If you only want to upgrade database, you may consider using either the backup and restore method or detach and attach method.

In addition, you may need to change compatibility levels.

See Upgrading SQL Server databases and changing compatibility levels

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Is there any other methods to upgrade databases

And what for other methods are you looking for? There are 2: In-place and side-by-side migrations.