Strategy and Practice of Domestic Database Migration Based on Application Soft Switch
This article elucidates a strategic initiative for migrating a pivotal component of the civil aviation sector's"Passenger Service System"—the Open Message Exchange Engine(OMSE)—to a domestically developed database platform.Under escalating operational expenses and technological dependence risks,this venture adeptly navigates the transition from cost-intensive Oracle and SQL Server databases to more economically viable Indigenously Developed and Controllable Database Products.The methodology hinges on the integration of vendor-supplied synchronization tools alongside the open-source ETL utility DataX,thereby ensuring seamless data congruency.Additionally,substantial modifications are made to the OMSE application,including incorporating data source soft switching mechanisms to bolster service continuity and reliability.The paper also delineates an exhaustive testing protocol,which underpins the integrity and efficiency of the migration process.This paradigmatic case not only exemplifies cost reduction but also offers a progressive framework for organizations grappling with analogous technological predicaments.
NETL
NSTL
万方数据
