Previous blog : http://bitnine.net/blog-useful-information/what-to-consider-before-migration-to-a-new-dbms/
As we noticed in last blog, this blog will handle more detail about migration and recommendation from Gartner. If your company prepares migration to a new DBMS, it is going to help a lot.
Recommend of how to reduce trouble when you migrate data
Compatibility Can Reduce Costs
A compatibility approach can reduce some of the difficulty of migration. As illustrated in the picture above, the overall effort for migrating data structures and logic can be greatly reduced with a compatibility capability. The effort of testing, which is a significant portion of the overall migration effort of the project, is not affected
The Migration Effort for packaged Applications May Be Minimal
While the discussion in the previous analysis is aimed at custom-made systems developed by or for an organization, a packaged application presents a somewhat different profile. The challenges previously discussed are typically reduced with a DBMS migration for a packaged application.
Cross-Platform Retraining and Cost
Moving to a DBMS with a compatibility capability not only reduces the migration effort, but also allows staff to use their skills with little or no retraining. Moving to a DBMS without a compatibility capability, or a DBMS that is based on a different architecture such as an RDBMS to a document or key-value DBMS can involve significant retraining for staff across the board, from developers to data base administrators
Evolving Toward a New Platform Reduces Risk
There are some inherent difficulties in trying to calculate the potential return on investment for a migration effort in part because the efforts and the benefits stem from different parts of the organization, and in part because of the even more tricky nature of ROI calculation for these projects. However, there are ways to implement a migration to another DBMS platform in order to reduce the overall risk of the effort and to diminish the negative side effects and spread these over times.
- Make sure that include the training of personnel on the new DBMS platform as part of your migration project plan. Do not assume that the skills of your existing staff will be adequate to perform even the same tasks on the new DBMS platform. Make sure that the training you schedule is delivered in advance of new DBMS going into production
- Plan on adding some resources and hardware to handle running dual systems during the testing phase of your migration. You will need to have dual systems in place until you are fully confident that your staff has implemented and tested the same backup, availability and disaster recovery introduce the potential for massive data loss.
[Reference] Rick Greenwald, Donald Feinberg, Adam M. Ronthal, “What to Consider Before Migrating to a New DBMS”, Gartner, November 2016
BITNINE GLOBAL INC., THE COMPANY SPECIALIZING IN GRAPH DATABASE
비트나인, 그래프 데이터베이스 전문 기업