I-DataMig: An Intelligent Tool for Efficient Database Migration

• Victor Misael B. F. Carneiro Federal University of Ceará (UFC)
• Gustavo Moraes Federal University of Ceará (UFC)
• Angelo Brayner Federal University of Ceará (UFC)

DOI: https://doi.org/10.5753/sbbd_estendido.2024.240758

Abstract

Efficient database migration between different systems is crucial in a constantly evolving technological landscape, where adaptability and minimizing downtime are critical. This paper presents the I-DataMig tool, a solution developed to automate the database migration process, providing an intuitive interface, as well as a fault-tolerant and auditable process. The I-DataMig allows detailed control of the migration steps, from the transfer of schemas and table instances to the migration of integrity constraints and indexes between different database systems. This work details the architecture, overview, and performance analysis of the tool.

Keywords: Database Migration, Schema Transfer, Migration Tool

References

Difallah, D. E., Pavlo, A., Curino, C., and Cudré-Mauroux, P. (2013). Oltp-bench: An extensible testbed for benchmarking relational databases. PVLDB, 7(4):277–288.

Elamparithi, M. and Anuratha, V. (2015). A review on database migration strategies, techniques and tools. World Journal of Computer Application and Technology, 3(3):41–48.

Kurako, E. A. and Orlov, V. L. (2023). Database migration from oracle to postgresql. Programming and Computer Software, 49(5):455–463.

Matthes, F., Schulz, C., and Haller, K. (2011). Testing & quality assurance in data migration projects. In 2011 27th IEEE International Conference on Software Maintenance (ICSM), pages 438–447.

Neto, P. S., Neto, J. R., Júnior, F. R., and Oliveira, P. (2013). Requisitos para ferramentas de migração de dados. In Anais do IX Simpósio Brasileiro de Sistemas de Informação, pages 887–898, Porto Alegre, RS, Brasil. SBC.

Sarmah, S. S. (2018). Data migration. Science and Technology, 8(1):1–10.