Study And Implementation Of Heterogeneous Data Migration In Financial Accounting System

In recent years,due to the rapid development of science and technology,the informatization construction of Banks and other financial enterprises is also making steady progress.In the era of explosive growth of information data,the traditional financial system can no longer bear such a huge amount of data accumulation,and the upgrading of related information systems keeps emerging.With the upgrade of the system,it will inevitably bring frequent data migration problems.Data is an important basis to support the business of the financial industry.A large amount of historical data accumulated during the use of the old system has inheritance and use value for the upgraded new system.The integrity and correctness of historical data migration become the key elements of system upgrade and data migration.Therefore,it is of certain practical significance to carry out the research and implementation of heterogeneous data migration of financial accounting system based on the system upgrade of the work unit.This paper plans the whole process of the data migration of accounting system of China railway construction finance co.,LTD.The objective of the migration is to transfer the data of the existing accounting system to the GS system of inspur company.In this paper,according to each stage of data migration,an overall scheme design is made for the migration of accounting system,and detailed verification rules are made for the system data verification after migration.Since this project is a relatively large and integrated project,this paper decomposes the migration steps,including the investigation of the new and old system environment,the program design of data migration,the development of data migration tools,and the verification of data migration and data migration results.This paper focuses on the development of data migration tools and data verification.Data migration tools are generally divided into two categories: common module and business module.Public modules include public variable module,database operation module,log processing module,progress processing module,total scheduling module and so on.Business modules include basic data migration module,general ledger migration module and data verification module.The verification of data mainly includes the verification of balance relationship,the verification of account balance,the verification of voucher and entry quantity,etc.According to the original plan and requirements,this project successfully completed the data transfer of the accounting system of China railway construction finance co.,LTD.,developed the corresponding data transfer tool,and verified the completeness and correctness of the data after the transfer.Verification results show that all valid historical data have been fully and accurately migrated to the new system.