DATABASE MIGRATION IN CODE-FREE FORMAT

2023;
: pp.34-38
1
Lviv Polytechnic National University
2
Lviv Politechnic National University
3
Lviv Politechnic National University
4
Cracow University of Technology, Poland

Database migration is a critical process for businesses that need to maintain their data integrity and functionality as they transition
to new technologies or systems [7]. The paper has researched the concept of database migration in a code-free format, including the benefits
and challenges of this approach. Code-free migration tools provide an interface that allows users to drag and drop data and automate the migration
process. This eliminates the need for manual coding and speeds up the migration process. Code-free solutions also provide users with visual representations
of the data, making it easier to understand and manage. However, these tools require careful consideration of data quality and security to
ensure that the migration process is successful.
The article provides different types of code-free migration tools, including data mapping software and drag-and-drop interfaces, and how
they can be used to facilitate the migration process [3]. Best practices are provided for successful code-free database migration, including testing
and validation.

[1] Ain El Hayat S., Bahaj M. Modeling and transformation from temporal object relational database into MongoDB: Rules. Advances in Science, Technology and Engineering Systems.
2020. № 5 (4). С. 618–625. DOI: https://doi.org/10.25046/aj050473.
[2] Andreas Wittig, Michael Wittig, “Amazon Web Services in Action”, Second Edition, Manning Publications Co., 2018.
[3] CRUD REST API with Node.js, Express, and PostgreSQL, 2022. [Online]. Available: https://blog.logrocket.com/crudrest-api-node-js-express-postgresql/
[4] Ji L. F., Azmi N. F. M. The development of a new data migration model for NOSQL databases with different schemas in the environment management system. Journal of Environmental
Treatment Techniques, № 8 (2). p. 787 – 793, 2020. http://www.jett.dormaj.com/docs/Volume8/Issue%202/The%20Development%20of...
[5] Michael J Hernandez, “Database Design for Mere Mortals: 25th Anniversary Edition”, Addison-Wesley Professional, 2020.
[6] PostgreSQL, 2023. [Online]. Available:https://www.postgresql.org/docs/
[7] Preston Z., Practical Guide to Large Database Migration. CRC Press, USA, 2021, https://www.routledge.com/ Practical-Guide-to-Large-Database-Migration/Zhang/p/book
[8] Real-Time AWS Cloud Migration Monitoring, 2023. [Online]. Available: https://www.striim.com/blog/real-timeaws-cloud-migration-monitoring/
[9] Steve M. Burnett, “Amazon Web Services For Beginners”, US, chapt.1, pp. 10-16, 2021. https://www.studypool.com/documents/23651179/aws-for-beginners