We have Sql 2014 and migrating to new server Sql Server 2022.
We have currently Express edition and will migrating also to the Express edition.
What's the best way to migrate/upgrade Logshipping databases (Primary and Secondary) to New server?
- Install Sql Server 2022 on New server on bot the Primary and Secondary
- create current empty database structure (SqlDB) on Primary and Secondary with existing logins
Turn off Logshipping job (including TLog backup and Restore Log job) in respective server first then
[A] Use Sql Server Migration Assistant (DMA) and just migrate Sql Server 2014 PRIMARY database "SqlDB" to Sql Server 2022 on Primary Server with current logins
[B] Use Sql Server Migration Assistant (DMA) and just migrate Sql Server 2014 Secondary database "SqlDB" to Sql Server 2022 on Secondary Server with current logins
- Turn On the Logshipping job (Backup og Tlog on PRIMARY Server and Restore Log job on Secondary Server)
Is it the right steps?
Thanks in advance!