question

06663949 avatar image
0 Votes"
06663949 asked Cathyji-msft commented

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

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

  1. 성공적 Migration을 위한 체크리스트는?

  2. 기존 DB의 'SQL Server 에이전트' 등등 모든 항목이 다 Migraion 될 수 있습니까?(가/부)

  3. Migration 방법? 이 궁금합니다.


sql-server-migration
· 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 @06663949,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If you have further question, please feel free to let us know.

0 Votes 0 ·

1 Answer

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

Hi @06663949,

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".



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.