Synchronous configuration copying method based on MS SQL Server

Abstract

The present invention discloses a synchronous configuration copying method based on MS SQL Server. By invoking the SQL-DMO API interface provided by the MS SQL Server database system, in combination with the module packaging technique, the process executes internal encapsulation and manipulation simplifying for the operation steps for the synchronous configuration copying to realize the automatic allocation functions of data-base synchronization copying. According to the process, the synchronous configuration copying course is completed through four steps as follows: a) selecting and connecting a publishing server; b) creating a publishing; c) selecting and connecting a subscription server; d) creating a subscription. Compared with the process for executing allocation through the graphical user interface of the MS SQL Server database and the executing acting edition, said process in accordance with the present invention possesses obvious advantages as follows: 1) the synchronous configuration copying process is simple; 2) the maintenance cost is reduced; 3) the adaptability is improved.

Description

technical field [0001] The invention relates to the field of MS SQL Server database network synchronization application, in particular to a method for synchronous replication configuration based on MS SQL Server. Background technique [0002] Synchronous replication is an advanced function of the database management system (DBMS), which plays a key role in the distributed application of the database, so it has attracted much attention and has been widely used; It is a recognized problem in the industry. There are two methods of synchronous replication configuration currently in use: [0003] (1) Manually complete the configuration process through the graphical user interface interface provided by the database management system (DBMS); [0004] (2) Complete the configuration process by executing the database script; [0005] However, the method of configuration, whether through the database's graphical user interface or through the execution of scripts, has significant fla...

AI Technical Summary

Problems solved by technology

[0005] However, the method of configuration, whether through the database's graphical user interface or through the execution of scripts, has significant flaws:

[0006] (1) The graphical interface configuration method of the database, the configuration method is completely manual, the configuration steps are complicated, and the general technical maintenance personnel are simply not competent, especially when the number of database tables is very large, the synchronous replication configuration is performed according to the database table , very error-prone

[0007] (2) Synchronous replication configuration through the database graphical interface undoubtedly requires professional training for maintenance personnel, and the maintenance cost is very high

[0008] (3) The synchronous replication configuration script of the database can only be generated after the manual synchronous replication configuration is completed, and the flexibility is very limited. Once the installation location of the database and the name of the database server participating in the synchronous replication change, it needs to be manually modified Scripts are required for synchronous replication configuration, which is cumbersome and error-prone

Images