Free Webinar
March 7 | 11am PT / 2pm ET
Do you dream of the fastest data transfer rate?
See how to ensure max RDMA network performance!
Speaker: Vladyslav Savchenko, Pre-Sales Engineer, StarWind
Posted by Mikhail Rodionov on February 7, 2019
Migrating K2 database to a different SQL Server instance – how to copy SQL Server instance Master Key

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.

Learn More