(ms-sq2008 R2)에서 (ms-sql 2019) 버전으로 Migration 하려고 합니다.

정완 손 1 Reputation point

(ms-sq2008 R2)에서 (ms-sql 2019) 버전으로 Migration 하려고 합니다.

  1. 성공적 Migration을 위한 체크리스트는?
  2. 기존 DB의 'SQL Server 에이전트' 등등 모든 항목이 다 Migraion 될 수 있습니까?(가/부)
  3. Migration 방법? 이 궁금합니다.
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.
510 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor

    Hi @정완 손 ,

    This is a MS Q&A forum in English, please post your issue in English, then people in this forum can give you a better help.

    Did you want to upgrade SQL server 2008 R2 to SQL server 2019? If so, which method that you choose? in-place upgrade or migrate to a new installation(side by side upgrade)? If you choose in-place upgrade method, please note that we can not upgrade SQL server 2008R2 to SQL server 2019 directly, you need to apply SP3 for SQL server 2008 R2, then upgrade SQL 2008R2 Sp3 to SQL server 2017, then upgrade SQL 2017 to SQL server 2019.

    Refer to Supported version & edition upgrades (SQL Server 2019) and Choose a database engine upgrade method.

    If you migrate SQL server 2008R2 to new installation, please backup all SQL server databases include system databases, then restore these databases to SQL server 2019 instance.

    >What is the checklist for successful migration?

    Pease reading this MS document to get detail information.

    Pre-upgrade planning checklist

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

    0 comments No comments