The Research of Heterogeneous Database Migration Based on XML and Middleware
Sai Dong Lv, Yao Wen Xia · Applied Mechanics and Materials · 2014
For many government departments or enterprises to use new system upgrades, data transfer between heterogeneous database problem, this paper puts forward a kind of heterogeneous database based on XML and middleware model of data migration.The model by using XML technology to build a middleware, through the ODBC interface connected to the source database and target database.After extracting data from the source database into a unified XML documents, again according to the mapping relationship between old and new database and XSL document, and converts it to meet the needs of the target XML document, the target database and load the data to the target database.The model including data extraction, transformation, validation, write, and other functions, is a cross-platform, easy extensibility and reusability.