ABSTRACTS OF ARTICLES OF THE JOURNAL "INFORMATION TECHNOLOGIES".
No. 9. Vol. 30. 2024

DOI: 10.17587/it.30.462-467

M. V. Voronchikhin, Software Engineer, N. A. Galanina, Dr. of Tech. Sc., Associate Professor,
Chuvash State University named after I. N. Ulyanov, Cheboksary, 428003, Chuvash Republic, Russian Federation

Using the Migration-KS Software Package to Solve the Problem of Database Import Substitution

Ways to solve the problem of import substitution and transfer of software to an open-source database management system (DBMS) in state and municipal institutions are considered (in particular, migration from a foreign SQL Server DBMS to domestic DBMSs based on PostgreSQL, such as PostgreSQL and DBMS-KS). The results of a detailed study of the main stages of database migration are presented, and the advantages and disadvantages of various migration methods are identified. A review of software solutions that enable the transition from MS SQL to PostgreSQL was carried out, such us AWS Database Migration Service, Ispirer MnMTK, Spectral Core: SQLTran, ConvertDB: MS SQL to PostgreSQL Migration and Sync, EasyFrom: ESF Database Migration Toolkit including special attention paid to the Migration-KS software package. The migration process of a territorial unit, performed using the Migration-KS software solution is described. As a result, the migration of users of the Keysystems company (a territorial division of the Ministry of Internal Affairs of Russia) to the PostgreSQL DBMS was carried out through several stages, including the preparation of OS Linux, installation and configuration of Docker containers and the database migration itself using the Migration-KS software package. This made it possible to transfer users to the new DBMS without significant problems and with minimal system downtime. The results were successful: the client continues to use Keysystems products based on PostgreSQL.
Keywords: migration, DBMS, PostgreSQL, SQL Server, import substitution, database, OS Linux, Migration-KS, data schema transformation, Docker

P. 462-467

References

1. Busunin A. S., Rodionov V. V. Review of methods and tools for migration from Microsoft SQL Server to PostgreSQL, Informatika i vychislitel'naya tekhnika, Sbornik nauchnyh trudov X Vserossijskoj nauchno-tekhnicheskoj konferencii aspirantov, studentov i molodyh uchenyh, V. N. Negoda ed. 2018, pp. 37—42 (in Russian).
2. Voronchikhin M. V., Galanina N. A. Import substitution of the database in the Administrator-D software package, XXVI Tupolevskie chyeniya (shkola molodyg uchenyh), Molodezhnaya nauch. konf Kazan, 2023. P. 2993—2996 (in Russian).
3. Voronchikhin M. V., Galanina N. A. Modeling the cal­culation of the batch report "Uploading a list of payment documents for write-off", Dynamics of nonlinear discrete electrical and electronic systems: materials of the XV All-Russian Scientific and Technical Conference, Cheboksary, 2023, pp. 74—76 (in Russian).
4. Voronchikhin M. V., Galanina N. A. Translation of the 'Ad­ministrative Practice" subcomplex, which is part of the Administrator-D information system, to the open source PostgreSQL DBMS, Novye kompetencii cifrovoj real'nosti: teoriya i praktika ih razvitiya u obuchay-ushchihsya: sb. dokl. i nauch. st. IV Vseros. nauch.-prakt. konf., Cheboksary, Chuvash Publishing House. Univ., 2023, pp. 91—96 (in Russian).
5. Voronchikhin M. V., Galanina N. A. Development of the report "Form 0510837. Statement of accrual of budget revenues" in the Administrator-D software package, Informatika i vychislitel'naya tekhnika: sb. nauch. trud., Cheboksary, 2023, pp. 63—67 (in Russian).
6. Rogov E. PostgreSQL 15 from the inside, Moscow, DMK Press, 2023, 662 p. (in Russian).
7. Ferrari L., Pirozzi E. Learn PostgreSQL, Birmingham, Packt Publishing, 2020, 650 p.
8. Drivers of IT import substitution in Russia. [Electron­ic resource]. Access mode: https://www.tadviser.ru/index.php/Article:Drivers_of_IT-import-substitution_in_Russia (access date: 17.12.2023). (in Russian).
9. Import substitution. [Electronic resource], available at: https://www.keysystems.ru/products/importozameshchenie/importozameshchenie/ (access date 17.12.2023) (in Russian).
10. Migration of an Oracle PL/SQL application to Postgres pl/pgSQL: a look two years later [Electronic resource], available at: https://pgconf.ru/media/2021/10/29/Anfinogenov%20Anatoly%20-%20Migration%20Oracle%20PL%20SQL%20at%20Postgres%20 pl%20pgSQL%20look%20two%20years%20later.pdf (access date: 17.12.2023) (in Russian).
11. Experience in migrating a database with business logic from Microsoft SQL Server to PostgreSQL: expectations and reality. [Electronic resource], available at: https://netrika.ru/news/opyt-migracii-bazy-dannyh-s-biznes-logikoy-iz-microsoft-sql-server-v-postgres-pro-ojidaniya-i-realnost (access date: 17.12.2023) (in Russian).
12. Regular expressions (regexp) — basics. [Electronic resource], available at: https://habr.com/ru/articles/545150/ (access date: 17.12.2023). (in Russian).
    

To the contents