The Design and Implementation of Database Synchronization System Based on Web Service
Abstract
We can construct the Heterogeneous database synchronous system using Web Service. It has realized the function of one-way synchronous from SQL Server2000 to Oracle. It has some functions, the security authentication of IP, the data transmission of IP, the Synchronization configuration using XML storage and the windows application program UI which can make this system be operated easily.
Because the synchronous environment will be real-time synchronous for heterogeneous database on the Internet, in the design and implementation, this system has showed the synchronization of heterogeneous database and data transmission reliability, achieving the synchronization of reliable data, the security methods of data transmission, and the efficiency transmission. It will display the ideas of realization and the necessary critical technologies. There are some relevant technologies that this system used, for example, the capture technology, the windows tray service, multi-thread processing, and the network news mechanism, and so on.
Key words: Web Service; Heterogeneous Database; Synchronization; ADO.NET;