International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
Since Year 2012 | Open Access | Double Blind Reviewed

ISSN: 2319-7064




Downloads: 4 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1

Masters Thesis | Computer Technology | Mexico | Volume 10 Issue 11, November 2021


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

Ing. Beatriz Mercedes Carrasco Perez | M.C. Juan Ramos Ramos [7] | Dr. Jose Juan Hernandez Mora [3] | Ing. Miriam Curiel Arenas | M.C. Mar?a Janai Sanchez Hernandez


Abstract: 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.


Keywords: Framework, Django, ORM, Migration, Persistence


Edition: Volume 10 Issue 11, November 2021,


Pages: 96 - 98


How to Cite this Article?

Ing. Beatriz Mercedes Carrasco Perez, M.C. Juan Ramos Ramos, Dr. Jose Juan Hernandez Mora, Ing. Miriam Curiel Arenas, M.C. Mar?a Janai Sanchez Hernandez, "Experience of using the Django ORM for Migration, Redesign and Implementation of a Database of MySQL Data to Postgre SQL", International Journal of Science and Research (IJSR), Volume 10 Issue 11, November 2021, pp. 96-98, https://www.ijsr.net/get_abstract.php?paper_id=SR211030134428

How to Share this Article?






Similar Articles with Keyword 'Framework'

Downloads: 48

Research Paper, Computer Technology, India, Volume 10 Issue 3, March 2021

Pages: 1223 - 1237

Artificial Intelligence and Machine Learning: Face Detection and Image Recognition with Python

Vishaal Chandrasekar

Share this Article

Downloads: 82

Informative Article, Computer Technology, China, Volume 9 Issue 9, September 2020

Pages: 1272 - 1276

New Paradigm of Computing (Distributed Computing)

Yeboah Derrick | George K. Agordzo | Lu Ye

Share this Article


Top