CN106302473B - A kind of the duplication maintaining method and system of SQL Server database - Google Patents
A kind of the duplication maintaining method and system of SQL Server database Download PDFInfo
- Publication number
- CN106302473B CN106302473B CN201610688340.7A CN201610688340A CN106302473B CN 106302473 B CN106302473 B CN 106302473B CN 201610688340 A CN201610688340 A CN 201610688340A CN 106302473 B CN106302473 B CN 106302473B
- Authority
- CN
- China
- Prior art keywords
- server
- database
- publication
- distribution
- duplication
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/08—Configuration management of networks or network elements
- H04L41/0876—Aspects of the degree of configuration automation
Abstract
The present invention is suitable for SQL Server database field, provides the duplication maintaining method and system of a kind of SQL Server database, which comprises receives server log information and verifies to the server log information；If the server log Information Authentication passes through, it is connected to pre-set publisher server, the distribution server and Subscriber；One-key duplication instruction set is received, the configuration information is called according to the one-key duplication instruction set, and publication is created according to the configuration information automatically and is subscribed to.The present invention is by carrying out security verification to the server log information, guarantee the legitimacy of login user, when receiving one-key duplication instruction set, the configuration information of pre-set publisher server, the distribution server and Subscriber is called, to create publication automatically and subscribe to the function, it can be achieved that one-key duplication database, simplify database duplication operation, database duplicating efficiency is improved, the workload of operator is reduced, reduces maintenance cost.
Description
Technical field
The invention belongs to a kind of duplication of SQL Server database field more particularly to SQL Server database maintenances
Method and system.
Background technique
SQL Server database is the Relational DBMS that (Microsoft) company, Microsoft releases.It is led
It is used to solve the problems, such as database real-time synchronization, data and database object are replicated and are distributed to another from a database by it
It in a or several databases, is then synchronized between database, comparison database snapshot is to guarantee the integralities of data.
However, the database that the duplication operation of SQL Server database requires operator to have profession replicates knowledge,
Upgrade include SQL Server database system before must first delete duplication, duplication is rebuild after upgrading again, operate compared with
For complexity, for the system that needs are frequently upgraded and updated, the duplication of traditional SQL Server database is operated
Method inefficiency increases the working strength of operator.
Summary of the invention
The purpose of the present invention is to provide a kind of duplication maintaining method of SQL Server database and systems, it is intended to solve
The duplication operation of SQL Server database requires operator to have the database duplication knowledge of profession, includes SQL in upgrading
Duplication must be first deleted before the system of Server database, rebuilds duplication again after upgrading, and complicated operation, for needing
For the system for frequently being upgraded and being updated, the duplication operating method inefficiency of traditional SQL Server database increases
The problem of having added the working strength of operator.
The invention is realized in this way a kind of duplication maintaining method of SQL Server database, which comprises
It receives server log information and the server log information is verified；
If the server log Information Authentication passes through, it is connected to pre-set publisher server, the distribution server
And Subscriber；
One-key duplication instruction set is received, the pre-set issuing service is called according to the one-key duplication instruction set
The configuration information of device, the distribution server and Subscriber, and publication is created according to the configuration information automatically and is subscribed to.
The present invention also provides a kind of duplication maintenance system of SQL Server database, the system comprises:
Authentication module, for receiving server log information and being verified to the server log information；
Server-connection module is connected to pre-set hair if passing through for the server log Information Authentication
Cloth server, the distribution server and Subscriber；
One-key duplication module is called described pre- for receiving one-key duplication instruction set according to the one-key duplication instruction set
The configuration information of the publisher server, the distribution server and the Subscriber that are first arranged, and it is automatically new according to the configuration information
Build publication and subscription.
Compared with prior art, the present invention the beneficial effect is that:
By carrying out security verification to the server log information, just it is connected to when being verified pre-set
Publisher server, the distribution server and Subscriber guarantee the legitimacy of login user, by referring to receiving one-key duplication
When enabling collection, the configuration information of pre-set publisher server, the distribution server and Subscriber is called, to create hair automatically
Cloth is operated with the function, it can be achieved that one-key duplication database, simplified database duplication is subscribed to, raising database duplicating efficiency, drop
The workload of low operator reduces maintenance cost.
Detailed description of the invention
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment
Attached drawing is briefly described, it should be apparent that, drawings in the following description are some embodiments of the invention, for ability
For the those of ordinary skill of domain, without creative efforts, it can also be obtained according to these attached drawings other attached
Figure.
Fig. 1 is the flow diagram of the duplication maintaining method for the SQL Server database that the embodiment of the present invention one provides；
Fig. 2 is the flow diagram of the duplication maintaining method of SQL Server database provided by Embodiment 2 of the present invention；
Fig. 3 is the structural block diagram of the duplication maintenance system for the SQL Server database that the embodiment of the present invention three provides；
Fig. 4 is the structural block diagram of the duplication maintenance system for the SQL Server database that the embodiment of the present invention four provides.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical solution in the embodiment of the present invention are explicitly described, it is clear that described embodiment is the present invention one
The embodiment divided, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not doing
Every other embodiment obtained under the premise of creative work out, should fall within the scope of the present invention.
Description and claims of this specification and term " includes " and their any deformations in above-mentioned attached drawing, meaning
Figure, which is to cover, non-exclusive includes.Such as process, method or system comprising series of steps or module, product or equipment do not have
It is defined in listed step or module, but optionally further comprising the step of not listing or module, or optionally also wrap
Include the other steps or module intrinsic for these process, methods, product or equipment.
Embodiment one:
As shown in Figure 1, the duplication maintaining method of SQL Server database provided in this embodiment comprising:
Step S101: it receives server log information and the server log information is verified.
In the present embodiment, the duplication of QL Server database refers to: to needs synchronization on the server of data source data library
Data are issued, and are then subscribed on targeting database server to the publication, to realize the reality of database data
When it is synchronous.Data source data library server, that is, publisher server, targeting database server, that is, Subscriber, the distribution server
Database data for issuing to publisher server carries out transfer, to be sent respectively to one or more Subscribers.
In a particular application, the server log information includes publisher server, the distribution server and Subscriber
Database user log-on message and computer user's log-on message, the user login information specifically include server name,
Login name and password.By being verified to server log information, it can increase and SQL Server database is replicated
With the safety of attended operation, criminal or unauthorized user is avoided arbitrarily to issue and subscribe to SQL Server database
In data.
Step S102: it if the server log Information Authentication passes through, is connected to pre-set publisher server, divides
Send out server and Subscriber.
In a particular application, every kind of clothes in the pre-set publisher server, the distribution server and Subscriber
The quantity of business device includes at least one, it can presets one or more publisher servers, one or more distribution services
Device and one or more Subscribers.
In one embodiment, before step S101 further include:
Safeguard the configuration information of the pre-set publisher server, the distribution server and Subscriber.
In a particular application, the configuration information specifically includes:
The title of the pre-set publisher server, publisher server run the computer user of snapshot agent process
The mode of publisher server is connected with snapshot agent, the title of the publication database, username and password are described to preset
's；
Title, user name, password and the file of the title of the pre-set the distribution server, the distribution database
Name and snapshot；
The title of the pre-set Subscriber, distributing proxy isochronous, this subscribes to computer use of luck traveling journey
Family and distribution agency connect this Subscriber mode, and the title of the subscription database, user name, password are described to set in advance
The Subscriber set.
It in a particular application, can be to pre-set one or more publisher servers, one or more distribution services
The configuration information of device and one or more Subscribers is safeguarded that the attended operation specifically includes:
Increase, modify or delete the configuration of the pre-set publisher server, the distribution server and Subscriber
Information can also increase or delete the quantity of publisher server, the distribution server and Subscriber.
Step S103: receiving one-key duplication instruction set, is called according to the one-key duplication instruction set described pre-set
The configuration information of publisher server, the distribution server and Subscriber, and according to the configuration information automatically create publication and
It subscribes to.
In the present embodiment, the one-key duplication instruction set is specifically referred to: being made of the instruction of one or more one-key duplications
Set.In a particular application, when the duplication operation of the SQL Server database includes to multiple publisher servers and correspondence
Multiple the distribution servers and multiple Subscribers be performed simultaneously multiple publications and when subscription operation, the one-key duplication instruction
Collection includes: the multiple one-key duplications instruction for being performed simultaneously multiple publications and subscription operation.It can be according to one key of configuration information
All publication and subscription operation are executed, the publication and subscription operation of part can also be only carried out.
In a particular application, the data of publisher server publication can be distributed by a distribution server, and by extremely
One few (that is, one, two or more) Subscriber is subscribed to, and multiple publisher servers can correspond to a distribution and service
Device.
In one embodiment, the method also includes:
It receives a key and deletes instruction set, instruction set is deleted according to a key, deletes the publication and subscription created.
In a particular application, a key is deleted instruction set and is specifically referred to: deleting the collection that instruction is constituted by one or more keys
It closes.When having created multiple publications and subscription operation, executes a key and delete instruction set, can be deleted according to a key
Instruction, which is deleted, except the key in instruction set deletes corresponding publication and subscription operation.All hairs created can be deleted with a key
Cloth and subscription can also only delete part and issue and subscribe to.
The present embodiment is just connected to pre- by carrying out security verification to the server log information when being verified
Publisher server, the distribution server and the Subscriber being first arranged, guarantee the legitimacy of login user, by receiving one
When one-key duplicating instruction set, the configuration information of pre-set publisher server, the distribution server and Subscriber is called, with certainly
It is dynamic to create publication and subscribe to the function, it can be achieved that one-key duplication database, simplify database duplication and operate, improves database duplication
Efficiency reduces the workload of operator, reduces maintenance cost.
The present embodiment can also realize the newly-built and delete operation of multiple publications and subscription simultaneously, to realize to SQL
The batch duplicating of Server database and deletion by the key batch duplicating and delete function when system needs frequently upgrading
The step of updating operation can be can simplify, improves upgrading efficiency, reduces the workload of operator, facilitate operation maintenance personnel management.
Embodiment two:
As shown in Fig. 2, the present embodiment is in example 1 before step S101, further includes:
Step 201: presetting publisher server, the distribution server and Subscriber.
In a particular application, it is described preset publisher server, the distribution server and Subscriber specifically refer to it is pre-
First select and configured the configuration information of publisher server, the distribution server and Subscriber.
Step S202: selection publication database selects distribution database, creates publication.
In a particular application, selection publication database specifically refers to, and selection executes the publication clothes of the newly-built publication operation
Business device, all or part of number in database or database that then selection needs to issue in selected publisher server
According to.It is corresponding, select distribution database to refer to, selection executes the distribution server of the newly-built publication operation, then in institute
The distribution database of default is selected in the distribution server of selection, the distribution database defaulted if it does not exist then automatically creates silent
The distribution database recognized.
In a particular application, the quantity for creating publication can create one or more hairs by being used for customized setting, user
Cloth.
Step S203: selecting the newly-built publication, selects subscription database, creates and subscribes to.
In a particular application, step S203 is specifically referred to, in newly-built one or more publications selection to some or
Multiple publications are subscribed to.After having selected the publication for needing to subscribe to, what selection was issued for synchronizing the publisher server
The subscription database of data creates the subscription database in corresponding Subscriber and subscribes to.
Step S204: the configuration information of the publication and the subscription is saved.
In a particular application, the configuration information for saving the publication and the subscription is to execute a key below for convenience
It is convenient when duplicate instructions collection that these configuration informations are transferred, to realize one-key duplication function.
Step S205: one-key duplication instruction set associated with the configuration information is established.
In a particular application, the incidence relation between the configuration information and the one-key duplication instruction set can be mapping
Relationship.
For example, the configuration information, comprising:
Publication database A ' corresponding with publisher server A, the distribution server a, distribution database a ', to publication database
The subscription database a " of the Subscriber A " that data in A ' are subscribed to, the data in synchronous publication database A '；
Publication database B ' corresponding with publisher server B, the distribution server b, distribution database b ', to publication database
The subscription database b " of the Subscriber B " that data in B ' are subscribed to, the data in synchronous publication database B '；
One-key duplication instruction set includes:
One-key duplication for data in one-key duplication publication database A ' corresponding with publisher server A instructs A " '；
One-key duplication for data in one-key duplication publication database B ' corresponding with publisher server B instructs B " '；
Then, the incidence relation between the configuration information and the one-key duplication instruction set is, A " ' and A, A ', a, a ',
A " and a " is associated；B " ' and B, B ', b, b ', B " and b ' are associated.
Execute includes that one-key duplication instructs the one-key duplication instruction set of A " ' and B " ' to refer to:
Publisher server A and the distribution server a is controlled to issue the data in publication database A ', controls Subscriber
Data in publication database A ' are synchronized to subscription database a " by A "；
Publisher server B and the distribution server b is controlled to issue the data in publication database B ', controls Subscriber
Data in publication database B ' are synchronized to subscription database b " by B ".
In one embodiment, include: after step S205
Increase new publication and new subscription；
The configuration information is updated according to the new publication and new subscription；
Modify the configuration information of the publication and the subscription that have been saved；
Alternatively, deleting the configuration information of the publication and the subscription that have been saved.
By increase, modification or the configuration information pre-set is deleted, may be implemented to publication and the number subscribed to
According to change, can according to need user and create new publication and subscription, or modification, delete the publication that has created and order
It reads.
Embodiment three:
As shown in figure 3, the duplication maintenance system of SQL Server database provided in this embodiment comprising:
Authentication module 101, for receiving server log information and being verified to the server log information；
Server-connection module 102 is connected to pre-set if passing through for the server log Information Authentication
Publisher server, the distribution server and Subscriber；
One-key duplication module 103, for receiving one-key duplication instruction set, according to one-key duplication instruction set calling
The configuration information of pre-set publisher server, the distribution server and Subscriber, and it is automatic according to the configuration information
Newly-built publication and subscription.
In one embodiment, the system also includes maintenance module, for safeguard the pre-set publisher server,
The configuration information of the distribution server and Subscriber；
In a particular application, maintenance module, can be to pre-set one or more publisher servers, one or more
The configuration information of the distribution server and one or more Subscribers is safeguarded that the attended operation specifically includes:
Increase, modify or delete the configuration of the pre-set publisher server, the distribution server and Subscriber
Information can also increase or delete the quantity of publisher server, the distribution server and Subscriber.
In a particular application, one-key duplication module 103, can be according to pre-set multiple publisher servers and corresponding
The configuration information of multiple the distribution servers and multiple Subscribers is performed simultaneously multiple publications and subscription operation, is criticized with realizing
Measure the function in replicate data library.
In a particular application, the data of publisher server publication can be distributed by the distribution server, can be by
At least one Subscriber is subscribed to, and multiple publisher servers can correspond to a distribution server.
In one embodiment, the system also includes:
One key removing module, deletes instruction set for receiving a key, deletes instruction set according to a key, deletion has been created
The publication and subscription built can delete all publications and subscription that have created with a key, can also only delete part and issue and order
It reads.
Example IV:
As shown in figure 4, the duplication maintenance system of SQL Server database is in example IV provided by the present embodiment
On the basis of further include:
Server setup module 201, for presetting publisher server, the distribution server and Subscriber；
Creation module 202 is issued, for selecting publication database, distribution database is selected, creates publication；
Creation module 203 is subscribed to, for selecting the newly-built publication, subscription database is selected, creates and subscribe to；
Memory module 204, for saving the configuration information of the publication and the subscription；
One-key duplication instruction set establishes module 205, for establishing one-key duplication instruction associated with the configuration information
Collection.
In a particular application, server setup module 201 is specifically used for pre-selecting and having configured publisher server, distribution
The configuration information of server and Subscriber.
In a particular application, creation module 202 is issued, the publication for executing the newly-built publication operation specifically for selection takes
Business device, all or part of number in database or database that then selection needs to issue in selected publisher server
According to；The distribution server for selecting the newly-built publication operation, then selects the distribution of default in selected the distribution server
Database, the distribution database defaulted if it does not exist then automatically create the distribution database of default.
In a particular application, the quantity for creating publication can create one or more hairs by being used for customized setting, user
Cloth.
In a particular application, creation module 203 is subscribed to, specifically for selecting in newly-built one or more publications to certain
One or more publication is subscribed to, and after having selected the publication for needing to subscribe to, is selected for synchronizing the publisher server institute
The subscription database of the data of publication creates the subscription database in corresponding Subscriber and subscribes to.
In a particular application, memory module 204 can select high speed RAM memory, can also select non-volatile memories
Device (non-volatile memory), such as magnetic disk storage.
In a particular application, one-key duplication instruction set establishes module 205, is also used to establish the configuration information and described one
Mapping relations between one-key duplicating instruction set.
In one embodiment, the system also includes:
Increase module, for increasing new publication and new subscription；
Update module, for updating the configuration information according to the new publication and new subscription；
Modified module, for modifying the configuration information of the publication and the subscription that have been saved；
Removing module, for deleting the configuration information of the publication and the subscription that have been saved.
By increase, modification or the configuration information pre-set is deleted, may be implemented to publication and the number subscribed to
According to change, can according to need user and create new publication and subscription, or modification, delete the publication that has created and order
It reads.
Module in all embodiments of the invention can pass through universal integrated circuit, such as CPU (Central
Processing Unit, central processing unit), or pass through ASIC (Application Specific Integrated
Circuit, specific integrated circuit) Lai Shixian.
The steps in the embodiment of the present invention can be sequentially adjusted, merged and deleted according to actual needs.
Module in system of the embodiment of the present invention can be combined, divided and deleted according to actual needs.
Step in the function and method of module in system of the embodiment of the present invention corresponds.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the program can be stored in a computer-readable storage medium
In, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, the storage medium can be magnetic
Dish, CD, read-only memory (Read-Only Memory, ROM) or random access memory (Random Access
Memory, RAM) etc..
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all in essence of the invention
Made any modifications, equivalent replacements, and improvements etc., should all be included in the protection scope of the present invention within mind and principle.
Claims (8)
1. a kind of duplication maintaining method of SQL Server database, which is characterized in that the described method includes:
It receives server log information and the server log information is verified；
If the server log Information Authentication passes through, it is connected to pre-set publisher server, the distribution server and orders
Read server；
One-key duplication instruction set is received, the pre-set publisher server is called according to the one-key duplication instruction set, is divided
The configuration information of server and Subscriber is sent out, and publication is created according to the configuration information automatically and is subscribed to；
It is described to be connected to before pre-set publisher server, the distribution server and Subscriber, comprising:
Preset publisher server, the distribution server and Subscriber；
Publication database is selected, distribution database is selected, creates publication；Wherein, it is selected in selected the distribution server silent
The distribution database recognized, the distribution database defaulted if it does not exist then automatically create the distribution database of default；
The newly-built one or more publication of selection, selects subscription database, creates and subscribe to, in newly-built one or more institutes
It states in publication, selects to some or multiple distribution subscriptions；
Save the configuration information of the publication and the subscription；
Establish one-key duplication instruction set associated with the configuration information.
2. the duplication maintaining method of SQL Server database as described in claim 1, which is characterized in that foundation is matched with described
Include: after the associated one-key duplication instruction set of confidence manner of breathing
Increase new publication and new subscription；
The configuration information is updated according to the new publication and new subscription；
Modify the configuration information of the publication and the subscription that have been saved；
Alternatively, deleting the configuration information of the publication and the subscription that have been saved.
3. the duplication maintaining method of the SQL Server database as described in any one of claims 1 to 2, feature exist
In the configuration information includes:
The title of the pre-set publisher server, the computer user of publisher server operation snapshot agent process and fast
According to the mode of agency's connection publisher server, the title of the publication database, username and password are described pre-set；
The title of the pre-set the distribution server, title, user name, password and the filename of the distribution database and
Snapshot；
The title of the pre-set Subscriber, distribution proxy isochronous this subscribe to luck traveling journey computer user and
Distribution agency connects this Subscriber mode, and the title of the subscription database, user name, password are described pre-set
Subscriber.
4. the duplication maintaining method of SQL Server database as described in claim 1, which is characterized in that the method is also wrapped
It includes:
It receives a key and deletes instruction set, instruction set is deleted according to a key and deletes the publication and subscription created.
5. a kind of duplication maintenance system of SQL Server database, which is characterized in that the system comprises:
Authentication module, for receiving server log information and being verified to the server log information；
Server-connection module is connected to pre-set publication clothes if passing through for the server log Information Authentication
Business device, the distribution server and Subscriber；
One-key duplication module is set for receiving one-key duplication instruction set according to one-key duplication instruction set calling is described in advance
The configuration information of publisher server, the distribution server and the Subscriber set, and hair is created according to the configuration information automatically
Cloth and subscription；
Server setup module, for presetting publisher server, the distribution server and Subscriber；
Creation module is issued, for selecting publication database, distribution database is selected, creates publication；Wherein, at selected point
The distribution database of default is selected in hair server, the distribution database defaulted if it does not exist then automatically creates the distribution of default
Database；
Creation module is subscribed to, for selecting the newly-built one or more publication, selection subscription database is created and is subscribed to,
In the newly-built one or more publication, select to some or multiple distribution subscriptions；
Memory module, for saving the configuration information of the publication and the subscription；
One-key duplication instruction set establishes module, for establishing one-key duplication instruction set associated with the configuration information.
6. the duplication maintenance system of SQL Server database as claimed in claim 5, which is characterized in that the system is also wrapped
It includes:
Increase module, for increasing new publication and new subscription；
Update module, for updating the configuration information according to the new publication and new subscription；
Modified module, for modifying the configuration information of the publication and the subscription that have been saved；
Removing module, for deleting the configuration information of the publication and the subscription that have been saved.
7. the duplication maintenance system of the SQL Server database as described in any one of claim 5 to 6, feature exist
In the configuration information includes:
The title of the pre-set publisher server, the computer user of publisher server operation snapshot agent process and fast
According to the mode of agency's connection publisher server, the title of the publication database, username and password are described pre-set；
The title of the pre-set the distribution server, title, user name, password and the filename of the distribution database and
Snapshot；
The title of the pre-set Subscriber, distribution proxy isochronous this subscribe to luck traveling journey computer user and
Distribution agency connects this Subscriber mode, and the title of the subscription database, user name, password are described pre-set
Subscriber.
8. the duplication maintenance system of SQL Server database as claimed in claim 5, which is characterized in that the system is also wrapped
It includes:
One key removing module, deletes instruction set for receiving a key, deletes instruction set according to a key, what deletion had created
Publication and subscription.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610688340.7A CN106302473B (en) | 2016-08-18 | 2016-08-18 | A kind of the duplication maintaining method and system of SQL Server database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610688340.7A CN106302473B (en) | 2016-08-18 | 2016-08-18 | A kind of the duplication maintaining method and system of SQL Server database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106302473A CN106302473A (en) | 2017-01-04 |
| CN106302473B true CN106302473B (en) | 2019-09-17 |
Family
ID=57661502
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610688340.7A Active CN106302473B (en) | 2016-08-18 | 2016-08-18 | A kind of the duplication maintaining method and system of SQL Server database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106302473B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10798165B2 (en) * | 2018-04-02 | 2020-10-06 | Oracle International Corporation | Tenant data comparison for a multi-tenant identity cloud service |
| CN111309790A (en) * | 2018-11-27 | 2020-06-19 | 千寻位置网络有限公司 | Automatic ETL configuration method and device based on maxcomputer database and control system |
| CN112181677A (en) * | 2020-09-02 | 2021-01-05 | 珠海格力电器股份有限公司 | Service processing method and device, storage medium and electronic device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1547118A (en) * | 2003-12-12 | 2004-11-17 | 中兴通讯股份有限公司 | Synchronous configuration copying method based on MS SQL Server |
| CN101000619A (en) * | 2006-12-25 | 2007-07-18 | 华为技术有限公司 | Data synchronous method and device based on SQL |
| CN103870357A (en) * | 2012-12-17 | 2014-06-18 | 中国移动通信集团河南有限公司 | Method and system for carrying out data replication |
| CN104809199A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
-
2016
- 2016-08-18 CN CN201610688340.7A patent/CN106302473B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1547118A (en) * | 2003-12-12 | 2004-11-17 | 中兴通讯股份有限公司 | Synchronous configuration copying method based on MS SQL Server |
| CN101000619A (en) * | 2006-12-25 | 2007-07-18 | 华为技术有限公司 | Data synchronous method and device based on SQL |
| CN103870357A (en) * | 2012-12-17 | 2014-06-18 | 中国移动通信集团河南有限公司 | Method and system for carrying out data replication |
| CN104809199A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106302473A (en) | 2017-01-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102026225B1 (en) | Apparatus for managing data using block chain and method thereof | |
| CN103595730B (en) | A kind of ciphertext cloud storage method and system | |
| CN101410800B (en) | System and method for a software distribution service | |
| CN103023875B (en) | A kind of account management system and method | |
| US20210126977A1 (en) | Single Agent for Logs, Metrics, Traces, Synthetics, Security, and End Point Monitoring | |
| US11431558B2 (en) | Data shipper agent management and configuration systems and methods | |
| CN106302473B (en) | A kind of the duplication maintaining method and system of SQL Server database | |
| CN106209754B (en) | To the method and system of software package automatic signature in version control system | |
| CN103034735A (en) | Big data distributed file export method | |
| KR102475435B1 (en) | Apparatus for managing data using block chain and method thereof | |
| CN109144785A (en) | Method and apparatus for Backup Data | |
| CN115859362A (en) | Data storage system, method, device and medium based on block chain side chain | |
| CN111382985A (en) | To-do message integrated pushing system and working method | |
| CN111026711A (en) | Block chain based data storage method and device, computer equipment and storage medium | |
| CN102932443A (en) | HDFS (hadoop distributed file system) cluster based distributed cloud storage system | |
| CN110913017B (en) | File compression transmission method based on cloud desktop | |
| CN105141418A (en) | Certificate authentication method and system | |
| CN113312669B (en) | Password synchronization method, device and storage medium | |
| CN108156201B (en) | Method and device for uniformly managing configuration data of application system | |
| CN111191261B (en) | Big data security protection method, system, medium and equipment | |
| TWI723622B (en) | Data management method and system capable of safely accessing and deleting data | |
| CN107332840A (en) | Authority intelligent management system and its method | |
| JP2015121886A (en) | Information processing device, information processing method, and program | |
| CN112800066A (en) | Index management method, related device and storage medium | |
| CN108595291B (en) | Medical data backup system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |