Migration SQL Server 2012 to 2019

Arief Hardiansyah 51 Reputation points
2022-09-20T06:47:01.19+00:00

Hi all,

We want to ask about migration or upgrade SQL Server, currently we have three SQL Servers with 2012 version. And we have created a new server with SQL server version 2019. We are planning to do SQL server migration from 2012 to 2019 version, but we don't have the experience for it.
Can you help us to provide what things need to be prepared so that we can do the migration?

Really appreciate for your answer.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,815 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,781 Reputation points
    2022-09-20T07:55:54.463+00:00

    Why don't you just follow the Microsoft documentation

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

    Followed by documentation on how to migrate from an old to a new version of SQL Server
    https://learn.microsoft.com/en-us/sql/sql-server/migrate/guides/sql-server-to-sql-server-upgrade-guide?view=sql-server-ver16

    Maybe a different approach might be a migration using PowerShell => dbatools
    https://dbatools.io/

    They have a migration command for migrating SQL Server very easily and quickly (but still should know what you/the script are doing)
    https://docs.dbatools.io/Start-DbaMigration

    ----------

    If this answer helps you - please accept this answer.

  2. PandaPan-MSFT 1,901 Reputation points
    2022-09-20T08:42:00.453+00:00

    Hi @Arief Hardiansyah ,
    I'm agree with @Bjoern Peters that the official article has provided enough information.
    I recommned that you can check this link to download the tool DMA at first :https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16

    After downloading the tool you can check this article to do the assessment: https://learn.microsoft.com/en-us/sql/dma/dma-assesssqlonprem?view=sql-server-ver16

    At last to prevent the rare accident happens you can do the experiment like this official article says:https://learn.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver16

    Wish you good luck!

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

  3. PandaPan-MSFT 1,901 Reputation points
    2022-09-21T07:52:31.807+00:00

    Hi @Arief Hardiansyah ,
    We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    0 comments
  4. Muhammad Kamran 0 Reputation points
    2023-05-21T17:27:50.7866667+00:00

    Upgrading SQL server from 2012 to 2019 is not that tricky, you will need to confirm that the upgrade version support your current SQL version, the steps to upgrade are easy to follow. Check the following article to upgrade from SQL 2012 to 2019, all the prerequisites and steps are mentioned in simple manner. https://www.dbsection.com/how-to-upgrade-sqlserver-2012-to-2019/

    0 comments