Data synchronization method and device, data synchronization system, server and storage medium
A data synchronization and server technology, applied in the database field, can solve problems such as the failure to synchronize data between SQL Server database and MySQL database, and the inability of triggers to synchronize incremental data, so as to achieve the effect of improving deployment efficiency.
Pending Publication Date: 2021-11-30
BEIJING DAJIA INTERNET INFORMATION TECH CO LTD
View PDF6 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, when the network environment between the SQLServer database and the MySQL database is unstable or not connected, the trigger cannot synchronize incremental data to the MySQL database, and the effect of synchronizing data between the SQLServer database and the MySQL database cannot be achieved.
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0058]In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.
[0059] The SQLServer database and the MySQL database can be applied in different network environments due to their respective characteristics. In practical applications, the data in the SQLServer database needs to be synchronized to the MySQL database in real time. When the data in the SQLServer database changes, the trigger in the SQLServer database will be triggered, and the trigger will be synchronized to the MySQL database based on the incremental method, where the incremental method refers to the method of synchronizing only newly added data each time.
[0060] However, when the network environment between the SQLServer database and the MySQL database is unstable or disconnected, the trig...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention relates to a data synchronization method and device, a data synchronization system, a server and a storage medium. The method comprises the following steps: acquiring the name of a to-be-synchronized source file from a local configuration file; deploying the configuration file through a hot deployment mechanism; based on the name of the source file, polling the source file in a first database to obtain data different from the source file with the same name in a second database, and taking the different data as incremental data to be synchronized in the source file; and synchronizing the incremental data to the second database. According to an embodiment in the invention, the problem that the first database and the second database are limited by a network environment can be solved, so the real-time synchronization effect of the first database and the second database is achieved.
Description
technical field [0001] The present disclosure relates to the technical field of databases, and in particular to a data synchronization method and device, a data synchronization system, a server, and a storage medium. Background technique [0002] The SQLServer database and the MySQL database can be applied in different network environments due to their respective characteristics. In practical applications, the data in the SQLServer database needs to be synchronized to the MySQL database in real time. When the data in the SQLServer database changes, the trigger in the SQLServer database will be triggered, and the trigger will be synchronized to the MySQL database based on the incremental method, where the incremental method refers to the method of synchronizing only newly added data each time. [0003] However, when the network environment between the SQLServer database and the MySQL database is unstable or disconnected, the trigger cannot synchronize incremental data to the ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/27G06F16/16G06F16/28
CPCG06F16/27G06F16/16G06F16/284
Inventor 蒋旺
Owner BEIJING DAJIA INTERNET INFORMATION TECH CO LTD