Data Conversion Of Heterogeneous Databases

With the rapid development of computer technology the production of people living more and more without it and database for future development of the core technology has been paid more attention. Different software companies have developed their own demand tendency of database software, the software often have their own model, since the data model is not the same as that in such different database software for transmission convert increase the difficulty, heterogeneous database data conversion between just is an enterprise at present needs, the use of a heterogeneous database conversion software can greatly enhance enterprise work efficiency saving human and material costs.The development of a heterogeneous database conversion system based on actual demand, it is using C#uander.net framework. Article resolved the specific problem of heterogeneous database one by one, to achieve heterogeneous database integration in necessary to resolve the various conflicts and transparent access, clear understanding of heterogeneous databases integration approach is the inevitable requirement to develop a good system. The system based on ADO.NET to achieve the ACCESS、SQL Server、Oracle、MySQL database:1.unified reading,2.data conversion,3.unified written,4.source database and destination database visual connection,5.conversion of visual design 6.data storage and execution.Heterogeneous database system developed for SMEs, to meet the need of SME data conversion between databases.The future direction of the system to achieve automatic conversion to improve the synchronization of data conversion, database expansion system consists of the type of databases to improve the breadth of applications.