Incremental Data Transmission Based On SQLSERVER2008 Log

With the rapid promotion and popularization of information, the basic information in all walks of life increases rapidly. Mass storage and big concurrent become a mark of the mainstream large database. That at the same time and in different places, and cross industry data information exchange through database server is more and more frequent and the amount of the interactive information is bigger and bigger result in a problem:How to transmit real-time mass data effectively:the usual ways adopted to improve transmission efficiency, minimize machine failures and system latencies are more cost-effective task schedulers and algorithms, or a transmission control through a group of datasets, or data-relay or transmission through Router. No matter what way is adopted, mass data requiring real-time communication is a bottle-neck. In order to reduce daily interactive mass data, it is necessary to change the transmission of mass data into that of incremental dataThis paper studies the achievement of CDC(Chang Data Capture)technology on the basis of database log, and that of incremental data through Query optimizer algorithm, and then resolving and reassembling incremental data and transmitting them to destination through MobiLink components and finally dividing and restoring the data and writing them in target database to finish the transmission process.