Posted by Mikhail Rodionov on February 7, 2019
Initially my plan for this blog post was to write up a short explanation of how to copy SQL Server instance master key between SQL Server instances, but too many people around me keep saying “start with why”, so I decided to go through some practical example from K2 world to illustrate when you may need to perform this operation. We will consider scenario of migration of already existing K2 database to a new SQL Server instance. This scenario will serve us as an illustration and essential “why part”. I also feel that it may facilitate understanding of the process itself.