Abstract：The minicomputer equipment supported by the operation of the marketing analysis and auxiliary decision system of State Grid Hebei Corporation has been running for many years. In recent years, the IBM 9116-561 model device voltage regulator module has a family defect. There is a risk that the marketing data report cannot be reported normally due to the equipment failure, affecting the system. Safe and stable operation. Based on the above considerations, this article describes the key technologies involved in the migration of ETL and Sybase databases from existing minicomputer environments to PC server devices. The major technologies include: ① Informatica and workflow export and import; ② Sybase and ETL Extraction of tools; ③ Extraction of new environmental data. Through the technical research in the above aspects, it not only effectively solves the problems existing in the system operation process, lays the foundation for better follow-up operation and maintenance work, but also provides experience for the cross-platform migration of other systems, and has good reference value.
李静, 马超, 黄镜宇, 卢艳艳. 跨平台信息系统数据迁移技术研究与实现[J]. 电气技术, 2019, 20(10): 70-74.
Li Jing, Ma Chao, Huang Jingyu, Lu Yanyan. Research and realization of cross-platform information system data migration technology. Electrical Engineering, 2019, 20(10): 70-74.
2019, Vol. 20 
