Project description MIGRATIONS PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Complex Microsoft SQL Server - migration into a cluster

Mann+Hummel, Speyer, Deutschland

MS SQL Server

Mann+Hummel, Speyer, Germany

PROJECT LINK: Not available
People in PROJECT: Stefan Troehler
PROJECT Duration: Nov 2020 - Dec 2020
PROJECT Value: SFR. 00'000.00

Migrationen

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Due to the technical conditions of the customer, a direct migration from the existing cluster to the new cluster is not possible. For this reason, a node of the existing cluster is removed during this migration, a local SQL server is created on it and the original SQL server on the cluster is migrated to this local SQL server. This in the form of a pre-migration. The new cluster is then created and the databases of the local SQL server are then migrated to this cluster. The reason for this procedure lies in the use of the SUN, which are decisive for the fact that the old cluster environment can no longer be accessed after the cluster has been migrated.

  • Premigration of the database server on the cluster to a local installation.
  • Create the new cluster.
  • Migration of the local installation of the database server to the new cluster.