Design and Implementation of Heterogeneous Database Exchange Based on Xml
Yu Su, Yin Wang, Kun Hua · International Journal of Advancements in Computing Technology · 2012
Data exchange is one of the important components of all kinds of computer network applications, is the main method to remove the “information isolated island” and is also the difficulty during the development of informalization. This paper presents a method which converts the relational database to XML(Extensible Markup Language). The method can be used to dump data between Heterogeneous Databases using XML. This paper also explains a program for implementing exchange between heterogeneous databases with PHP Programming Language by XML. The program dumps and backups between MySQL and MSSQL using XML as intermediate storage. Both ADODB and native function of PHP are used to connect the databases, and there is a comparison and evaluation about pros and cons between them. SimpleXML class of PHP is used for reading and writing.