Experience of using the Django ORM for Migration, Redesign and Implementation of a Database of MySQL Data to Postgre SQL

Currently, the use of Frameworks helps developers to generate systems more easily, making use of a uniform, consistent and identifiable project structure. Using the ORM it is possible to abstract data from an existing database, regardless of the DBMS to be used. This publication describes the use of the Django Framework and its ORM for the generation of the structure of classes that allow to achieve persistence towards an existing database, identifying and applying the necessary process for the corresponding migration towards a model file in a project of Django, as well as the identification of migrations and the generation of the tables in a physical database in the PostgreSQL Management System.The migration solution proposed in this thesis was implemented as an application case in the Records Management System of the books of the Judicial Power of the State of Tlaxcala, whose information was initially stored in MySQL. The results show the initial database implemented in MySQL. Likewise, the database migration process is outlined, using the Django Framework ORM, including the reconfiguration of the database and the migration to the final physical storage.