Migrating Databases: Best Practices For Upgrading Legacy Applications
DOI:
https://doi.org/10.63282/3050-922X.IJERET-V5I1P110Keywords:
Database Migration, Legacy Systems, Application Modernization, Data Management, Best Practices, Data Quality, Downtime, Risk Management, Migration StrategiesAbstract
The research examines database migration as a crucial process for upgrading outdated applications through a comprehensive evaluation. The paper explains essential terms while discussing the reasons behind complex projects and describes both the various obstacles and potential dangers that exist. The report utilizes existing literature and industry insights to present multiple migration strategies, focusing on best practices for pre-migration planning and execution, as well as post-migration validation phases. The research provides IT architects and decision-makers with a comprehensive framework for executing database migrations, protecting data integrity, and minimizing system disruptions to achieve the full benefits of a modern system
References
[1] Mudunuri L.N.R.; (December, 2023); “AI-Driven Inventory Management: Never Run Out, Never Overstock”; International Journal of Advances in Engineering Research; Vol 26, Issue 6; 24-36
[2] Praveen Kumar Maroju, "Optimizing Mortgage Loan Processing in Capital Markets: A Machine Learning Approach, " International Journal of Innovations in Scientific Engineering, 17(1), PP. 36-55 , April 2023.
[3] J. Kutay, “An introduction to database migration strategy and best practices,” Striim. https://www.striim.com/blog/an-introduction-to-database-migration-strategy-and-best-practices/
[4] Ralwasser, “Data migration – dangerous or essential?,” Stack Exchange, Feb. 09, 2011. https://softwareengineering.stackexchange.com/questions/50703/data-migration-dangerous-or-essential
[5] IR Team, “What are Legacy Systems and Why Do Companies Still Use Them? | IR.” https://www.ir.com/guides/what-are-legacy-systems-and-why-do-companies-still-use-them
[6] Pavel K., “Legacy System Modernization Approaches: Practical Advice on Dealing with Outdated Software,” Legacy Software Modernization Company | ModLogix, Oct. 30, 2020. https://modlogix.com/blog/legacy-system-modernization-approaches-practical-advice-on-dealing-with-outdated-software/
[7] S. S. Sarmah, “Data migration,” Science and Technology, vol. 8, pp. 1–10, 2018, doi: 10.5923/j.scit.20180801.01.
[8] O. Azeroual and M. Jha, “Without data quality, there is no data migration,” Big Data and Cognitive Computing, vol. 5, no. 2, p. 24, May 2021, doi: 10.3390/bdcc5020024.
[9] Informatica, “All about database migration,” Informatica. https://www.informatica.com/resources/articles/what-is-database-migration.html
[10] H. Dhaduk, “Database migration – what it is, understanding needs, and challenges,” Simform, Feb. 17, 2020. https://www.simform.com/blog/database-migration/
[11] Anton V., “Risks and Approaches of Legacy Application UI and UX modernization,” Legacy Software Modernization Company | ModLogix, Nov. 20, 2020. https://modlogix.com/blog/risks-and-approaches-of-legacy-application-ui-ux-modernization/
[12] M. Elamparithi and V. Anuratha, “A review on database migration strategies, techniques and tools,” World Journal of Computer Application and Technology, vol. 3, no. 3, pp. 41–48, Dec. 2015, doi: 10.13189/wjcat.2015.030301.
[13] M. Srinivas, G. Ramakrishna, K. R. Rao, and E. S. Babu, “Analysis of Legacy System in Software Application Development: A Comparative survey,” International Journal of Electrical and Computer Engineering (IJECE), vol. 6, no. 1, pp. 292–297, Feb. 2016, doi: 10.11591/ijece.v6i1.8367.
[14] M. Ansar, M. W. Ashraf, and M. Fatima, “Data Migration in Cloud: A Systematic Review,” American Scientific Research Journal for Engineering, Technology, and Sciences (ASRJETS), pp. 73–89, 2018, [Online]. Available: http://asrjetsjournal.org/
[15] “Legacy software modernization,” Jan. 2017. [Online]. Available: https://www.altexsoft.com/media/2017/01/Legacy-Software-Modernization.pdf
[16] A. K. Thomer, A. J. Rayburn, and A. R. B. Tyler, “Three approaches to documenting database migrations,” International Journal of Digital Curation, vol. 15, no. 1, p. 5, Aug. 2020, doi: 10.2218/ijdc.v15i1.726.
[17] D. Jones, “Data Migration Test Strategy: Create an effective test plan — Data Migration Pro,” Data Migration Pro. https://www.datamigrationpro.com/data-migration-go-live-strategy
[18] “7 Steps to Include in your Data Migration Plan | Secure Cloud Backup Software | Nordic Backup,” Secure Cloud Backup Software | Nordic Backup. https://nordic-backup.com/blog/7-steps-data-migration-plan/
[19] “Rolling back from a migration with AWS DMS | Amazon Web Services,” Amazon Web Services, Apr. 22, 2020. https://aws.amazon.com/blogs/database/rolling-back-from-a-migration-with-aws-dms/
