A data migration method for upgrading a water company's operating charging system

Abstract

The invention relates to a data migration method for upgrading a service charging system of a water company, which relates to the technical field of data processing, comprising the following steps: establishing a data mapping relationship: comparing and analyzing a data structure of a source database and a target database; establishing a data mapping relationship between the source database and the target database; data migration: extracting data from the source database and migrating to the intermediate database through SQL program corresponding to the source database, and comparing, analyzing and verifying the data migrated to the intermediate database according to the data mapping relationship between the source database and the target database, and correcting the error and abnormal data; through the SQL program corresponding to the target database, the data matching the data mapping relationship between the source database and the target database is extracted from the intermediatedatabase and migrated to the target database. The data in the two-tier C / S structure database can be migrated to the three-tier B / S structure database by the method, so as to realize the smooth switching and upgrading of the new and old systems.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data migration method used for upgrading a business charging system of a water service company. Background technique [0002] With the gradual deepening of informatization construction in the water industry, the water company has higher requirements for the response speed and functional improvement of the business charging system. For this reason, a new charging system has been developed to meet the business needs in the current situation. [0003] The database of the traditional business charging system is a two-tier C / S structure, and the database of the new business charging system is a three-tier B / S structure. Compared with the two-tier C / S structure, the B / S can be divided into three layers reasonably The function of the structure keeps it relatively independent logically, so that the logical structure of the entire system is clearer and smoother, and it can also ...

AI Technical Summary

Problems solved by technology

The process of data migration is the process of converting the above data in the source database to the target database. From two-tier structure to three-tier structure, from C / S to B / S, the success of data migration will determine the performance of the entire business charging system. Whether to achieve smooth upgrade and update, once the migration fails, the new system will not be able to run normally. In addition, in order to ensure the normal operation of the water company, the efficiency of data migration must also be focused

Images