CN106302473A - The duplication maintaining method of a kind of SQL Server data base and system - Google Patents
The duplication maintaining method of a kind of SQL Server data base and system Download PDFInfo
- Publication number
- CN106302473A CN106302473A CN201610688340.7A CN201610688340A CN106302473A CN 106302473 A CN106302473 A CN 106302473A CN 201610688340 A CN201610688340 A CN 201610688340A CN 106302473 A CN106302473 A CN 106302473A
- Authority
- CN
- China
- Prior art keywords
- server
- subscription
- issue
- configuration information
- 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.)
- Granted
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Databases & Information Systems (AREA)
- Signal Processing (AREA)
- General Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Data Mining & Analysis (AREA)
- Automation & Control Theory (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is applicable to SQL Server database field, it is provided that the duplication maintaining method of a kind of SQL Server data base and system, and described method includes: receives server log information and verifies described server log information；If described server log Information Authentication is passed through, then it is connected to publisher server, Distributor and the Subscriber pre-set；Receive one-key duplication instruction set, call described configuration information according to described one-key duplication instruction set, and according to the automatic newly-built issue of described configuration information and subscription.The present invention is by carrying out security verification to described server log information, ensure the legitimacy of login user, when receiving one-key duplication instruction set, call the configuration information of the publisher server, Distributor and the Subscriber that pre-set, with automatic newly-built issue and subscription, the function of one-key duplication data base can be realized, simplify data base and replicate operation, improve data base's duplicating efficiency, reduce the workload of operator, reduce maintenance cost.
Description
Technical field
The invention belongs to SQL Server database field, the duplication particularly relating to a kind of SQL Server data base is safeguarded
Method and system.
Background technology
SQL Server data base is the Relational DBMS that Microsoft (Microsoft) company releases.It is main
Being used for solving data base's real-time synchronization problem, data and database object from data base's duplication and are distributed to another by it
In individual or several data base, then synchronizing between data base, comparison database snapshot is to ensure the integrity of data.
But, the operation that replicates of SQL Server data base requires that operator have professional data base and replicate knowledge,
Must first delete duplication before upgrading includes the system of SQL Server data base, rebuild duplication after upgrading again, operation is relatively
For complexity, for needing the system frequently upgraded and update, the duplication operation of traditional SQL Server data base
Method inefficiency, adds the working strength of operator.
Summary of the invention
It is an object of the invention to provide duplication maintaining method and the system of a kind of SQL Server data base, it is intended to solve
The operation that replicates of SQL Server data base requires that operator have professional data base and replicate knowledge, includes SQL in upgrading
Must first delete duplication before the system of Server data base, rebuild duplication after upgrading again, operate complex, for needs
For the system frequently upgraded and update, the duplication operational approach inefficiency of traditional SQL Server data base, increase
The problem having added the working strength of operator.
The present invention is achieved in that the duplication maintaining method of a kind of SQL Server data base, and described method includes:
Receive server log information and described server log information is verified；
If described server log Information Authentication is passed through, then it is connected to publisher server, the Distributor pre-set
And Subscriber；
Receive one-key duplication instruction set, according to described one-key duplication instruction set call described in the issuing service that pre-sets
The configuration information of device, Distributor and Subscriber, and according to the automatic newly-built issue of described configuration information and subscription.
The present invention also provides for the duplication of a kind of SQL Server data base and safeguards system, and described system includes:
Authentication module, is used for receiving server log information and verifying described server log information；
Server-connection module, if passing through for described server log Information Authentication, then be connected to pre-set sends out
Cloth server, Distributor and Subscriber；
One-key duplication module, is used for receiving one-key duplication instruction set, calls described pre-according to described one-key duplication instruction set
The configuration information of the publisher server, Distributor and the Subscriber that first arrange, and the newest according to described configuration information
Build issue and subscribe to.
Compared with prior art, it has the beneficial effects that the present invention:
By described server log information is carried out security verification, just it is connected to when being verified to pre-set
Publisher server, Distributor and Subscriber, it is ensured that the legitimacy of login user, by referring to receiving one-key duplication
During order collection, call the configuration information of the publisher server, Distributor and the Subscriber that pre-set, with the most newly-built
Cloth and subscription, can realize the function of one-key duplication data base, simplifies data base and replicates operation, improves data base's duplicating efficiency, fall
The workload of low operator, reduces maintenance cost.
Accompanying drawing explanation
For the technical scheme being illustrated more clearly that in the embodiment of the present invention, in embodiment being described below required for make
Accompanying drawing be briefly described, it should be apparent that, below describe in accompanying drawing be some embodiments of the present invention, for ability
From the point of view of the those of ordinary skill of territory, on the premise of not paying creative work, it is also possible to obtain the attached of other according to these accompanying drawings
Figure.
Fig. 1 is the FB(flow block) replicating maintaining method of the SQL Server data base that the embodiment of the present invention one provides；
Fig. 2 is the FB(flow block) replicating maintaining method of the SQL Server data base that the embodiment of the present invention two provides；
Fig. 3 is the structured flowchart replicating maintenance system of the SQL Server data base that the embodiment of the present invention three provides；
Fig. 4 is the structured flowchart replicating maintenance system of the SQL Server data base that the embodiment of the present invention four provides.
Detailed description of the invention
In order to make those skilled in the art be more fully understood that the present invention program, below in conjunction with in the embodiment of the present invention
Accompanying drawing, is explicitly described the technical scheme in the embodiment of the present invention, it is clear that described embodiment is the present invention one
The embodiment divided rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art are not doing
Go out the every other embodiment obtained under creative work premise, all should belong to the scope of protection of the invention.
Term in description and claims of this specification and above-mentioned accompanying drawing " includes " and they any deformation, meaning
Figure is to cover non-exclusive comprising.Such as comprise series of steps or the process of module, method or system, product or equipment do not have
Have and be defined in the step or module listed, but the most also include step or the module do not listed, or the most also wrap
Include other step intrinsic for these processes, method, product or equipment or module.
Embodiment one:
As it is shown in figure 1, the duplication maintaining method of the SQL Server data base of the present embodiment offer, comprising:
Step S101: receive server log information and described server log information is verified.
In the present embodiment, QL Server data base replicates and refers to: to needing synchronization on the server of data source data storehouse
Data are issued, and then subscribe to described issue on targeting database server, to realize the reality of database data
Time synchronize.The data source data storehouse i.e. publisher server of server, targeting database server i.e. Subscriber, Distributor
Database data for issuing publisher server carries out transfer, to be sent respectively to one or more Subscriber.
In a particular application, described server log information includes publisher server, Distributor and Subscriber
Database user log-on message and computer user's log-on message, described user login information specifically include server name,
Login name and password.By server log information is verified, can increase and SQL Server data base is replicated
Safety with attended operation, it is to avoid lawless person or the random issue of unauthorized user and subscribe to SQL Server data base
In data.
Step S102: if described server log Information Authentication is passed through, then the publisher server being connected to pre-set, point
Send out server and Subscriber.
In a particular application, every kind of clothes in the publisher server, Distributor and the Subscriber that pre-set described in
The quantity of business device at least includes one, i.e. can pre-set one or more publisher server, one or more distribution service
Device and one or more Subscriber.
In one embodiment, also include before step S101:
The configuration information of the publisher server, Distributor and the Subscriber that pre-set described in maintenance.
In a particular application, described configuration information specifically includes:
The title of the described publisher server pre-set, publisher server run the computer user of snapshot agent process
With snapshot agent connect publisher server mode, the title of described publication database, username and password, described in pre-set
's；
The title of the described Distributor pre-set, the title of described distribution database, user name, password and file
Name and snapshot；
This computer subscribing to luck traveling journey of the title of the described Subscriber pre-set, distribution proxy isochronous is used
Family and distribution agency connect this Subscriber mode, the title of described subscription database, user name, password, described set in advance
The Subscriber put.
In a particular application, can be to the one or more publisher servers pre-set, one or more distribution service
The configuration information of device and one or more Subscriber is safeguarded, described attended operation specifically includes:
The configuration of the publisher server, Distributor and the Subscriber that pre-set described in increasing, revise or deleting
Information, it is also possible to increase or delete the quantity of publisher server, Distributor and Subscriber.
Step S103: receive one-key duplication instruction set, according to described one-key duplication instruction set call described in pre-set
The configuration information of publisher server, Distributor and Subscriber, and according to the automatic newly-built issue of described configuration information and
Subscribe to.
In the present embodiment, described one-key duplication instruction set specifically refers to: be made up of the instruction of one or more one-key duplications
Set.In a particular application, include multiple publisher servers and correspondence when the duplication of described SQL Server data base operates
Multiple Distributors and multiple Subscriber when simultaneously performing multiple issue and subscription operation, described one-key duplication instructs
Collection includes: perform multiple one-key duplications instruction of multiple issue and subscription operation simultaneously.Can be according to described configuration information one key
Perform all of issue and subscription operation, it is also possible to only carry out issue and the subscription operation of part.
In a particular application, the data of a publisher server issue can be distributed by a Distributor, and by extremely
Few one (that is, one, two or more) Subscriber is subscribed to, and multiple publisher servers can a corresponding distribution service
Device.
In one embodiment, described method also includes:
Receive a key and delete instruction set, delete instruction set according to a described key, delete the issue and subscription created.
In a particular application, a key deletion instruction set specifically refers to: deleted, by one or more keys, the collection that instruction is constituted
Close.When having created multiple issue and subscription operation, perform a described key and delete instruction set, can delete according to a described key
Delete instruction except the key in instruction set and delete corresponding issue and subscription operation.All created can be deleted by a key
Cloth and subscription, it is also possible to only delete part and issue and subscribe to.
The present embodiment, by described server log information is carried out security verification, is just connected to pre-when being verified
Publisher server, Distributor and the Subscriber first arranged, it is ensured that the legitimacy of login user, by receiving one
During one-key duplicating instruction set, call the configuration information of the publisher server, Distributor and the Subscriber that pre-set, with certainly
Dynamic newly-built issue and subscription, can realize the function of one-key duplication data base, simplifies data base and replicates operation, improves data base and replicates
Efficiency, reduces the workload of operator, reduces maintenance cost.
The present embodiment can also realize the newly-built and deletion action of multiple issue and subscription simultaneously, to realize SQL
The batch duplicating of Server data base and deletion, when system needs frequently to upgrade, by this key batch duplicating and deletion merit
Can simplify the step of updating operation, improve and rise stage efficiency, reduce the workload of operator, facilitate operation maintenance personnel to manage.
Embodiment two:
As in figure 2 it is shown, the present embodiment before step S101, also includes in embodiment one:
Step 201: pre-set publisher server, Distributor and Subscriber.
In a particular application, pre-set publisher server, Distributor and Subscriber described in and specifically refer to pre-
First select and configured the configuration information of publisher server, Distributor and Subscriber.
Step S202: select publication database, selects distribution database, newly-built issue.
In a particular application, select publication database to specifically refer to, select to perform the described newly-built issue clothes issuing operation
Business device, then selects to need all or part of number in the data base of issue or data base in selected publisher server
According to.Corresponding, select distribution database i.e. to refer to, select to perform the described newly-built Distributor issuing operation, then in institute
The Distributor selected selecting the distribution database of acquiescence, if there is not the distribution database of acquiescence, then automatically creating silent
The distribution database recognized.
In a particular application, the quantity of newly-built issue is by for self-defined setting, and user can be with newly-built one or more
Cloth.
Step S203: select newly-built described issue, selects subscription database, newly-built subscription.
In a particular application, step S203 specifically refers to, select in newly-built one or more issues to some or
Multiple issues are subscribed to.After have selected the issue needing to subscribe to, select for synchronizing what described publisher server was issued
The subscription database of data, creates described subscription database in corresponding Subscriber and subscribes to.
Step S204: preserve described issue and the configuration information of described subscription.
In a particular application, preserve described issue and the configuration information of described subscription, be to perform a key for convenience below
Conveniently these configuration informations are transferred, to realize one-key duplication function during duplicate instructions collection.
Step S205: set up the one-key duplication instruction set being associated with described configuration information.
In a particular application, the incidence relation between described configuration information and described one-key duplication instruction set can be to map
Relation.
Such as, described configuration information, including:
The publication database A ' corresponding with publisher server A, Distributor a, distribution database a ', to publication database
Data in A ' carry out the Subscriber A subscribed to ", the subscription database a of the data synchronized in publication database A ' "；
The publication database B ' corresponding with publisher server B, Distributor b, distribution database b ', to publication database
Data in B ' carry out the Subscriber B subscribed to ", the subscription database b of the data synchronized in publication database B ' "；
One-key duplication instruction set includes:
The one-key duplication instruction A of data in the publication database A ' that one-key duplication is corresponding with publisher server A " '；
The one-key duplication instruction B of data in the publication database B ' that one-key duplication is corresponding with publisher server B " '；
Then, and the incidence relation between described configuration information and described one-key duplication instruction set is, A " ' with A, A ', a, a ',
A " and a " be associated；B " ' with B, B ', b, b ', B " and b ' be associated.
Execution includes that one-key duplication instructs A " the one-key duplication instruction set of ' and B " ' i.e. refers to:
Control publisher server A and Distributor a and issue the data in publication database A ', control Subscriber
A " by the data syn-chronization in publication database A ' to subscription database a "；
Control publisher server B and Distributor b and issue the data in publication database B ', control Subscriber
B " by the data syn-chronization in publication database B ' to subscription database b ".
In one embodiment, include after step S205:
Increase new issuing and new subscription；
According to described new issuing and the new subscription described configuration information of renewal；
Revise the most saved described issue and the configuration information of described subscription；
Or, delete the most saved described issue and the configuration information of described subscription.
By increasing, revising or delete the configuration information pre-set, it is possible to achieve to the number issued and subscribe to
According to change, make user can the most newly-built new issue and subscription, or amendment, delete the issue that created and order
Read.
Embodiment three:
As it is shown on figure 3, system is safeguarded in the duplication of the SQL Server data base of the present embodiment offer, comprising:
Authentication module 101, is used for receiving server log information and verifying described server log information；
Server-connection module 102, if passing through for described server log Information Authentication, then is connected to pre-set
Publisher server, Distributor and Subscriber；
One-key duplication module 103, is used for receiving one-key duplication instruction set, calls described according to described one-key duplication instruction set
The configuration information of the publisher server, Distributor and the Subscriber that pre-set, and automatic according to described configuration information
Newly-built issue and subscription.
In one embodiment, described system also includes maintenance module, the publisher server that pre-sets described in safeguard,
Distributor and the configuration information of Subscriber；
In a particular application, maintenance module, can be to one or more publisher servers pre-set, one or more
The configuration information of Distributor and one or more Subscriber is safeguarded, described attended operation specifically includes:
The configuration of the publisher server, Distributor and the Subscriber that pre-set described in increasing, revise or deleting
Information, it is also possible to increase or delete the quantity of publisher server, Distributor and Subscriber.
In a particular application, one-key duplication module 103, can be according to the multiple publisher servers pre-set and correspondence
Multiple Distributors and the configuration information of multiple Subscriber, perform multiple issue and subscription operation simultaneously, to realize criticizing
Amount replicates the function of data base.
In a particular application, the data that publisher server is issued can be distributed by a Distributor, can be by
At least one Subscriber is subscribed to, and multiple publisher servers can a corresponding Distributor.
In one embodiment, described system also includes:
One key removing module, deletes instruction set for receiving a key, deletes instruction set according to a described key, deletes and created
The issue built and subscription, can delete all issues and subscription created by a key, it is also possible to a deletion part is issued and ordered
Read.
Embodiment four:
As shown in Figure 4, the maintenance system that replicates of the SQL Server data base that the present embodiment is provided is in embodiment four
On the basis of also include:
Server arranges module 201, is used for pre-setting publisher server, Distributor and Subscriber；
Issue creation module 202, be used for selecting publication database, select distribution database, newly-built issue；
Subscribe to creation module 203, for selecting newly-built described issue, select subscription database, newly-built subscription；
Memory module 204, for preserving described issue and the configuration information of described subscription；
One-key duplication instruction set sets up module 205, for setting up the one-key duplication instruction being associated with described configuration information
Collection.
In a particular application, server arranges module 201 specifically for being pre-selected and configured publisher server, distribution
Server and the configuration information of Subscriber.
In a particular application, issue creation module 202, specifically for selecting to perform the described newly-built issue clothes issuing operation
Business device, then selects to need all or part of number in the data base of issue or data base in selected publisher server
According to；Select the described newly-built Distributor issuing operation, in selected Distributor, then select the distribution of acquiescence
Data base, if there is not the distribution database of acquiescence, then automatically creates the distribution database of acquiescence.
In a particular application, the quantity of newly-built issue is by for self-defined setting, and user can be with newly-built one or more
Cloth.
In a particular application, creation module 203 is subscribed to, specifically for selecting certain in newly-built one or more issues
One or more issues are subscribed to, and after have selected the issue needing to subscribe to, select to be used for synchronizing described publisher server institute
The subscription database of the data issued, creates described subscription database in corresponding Subscriber and subscribes to.
In a particular application, memory module 204, high-speed RAM memorizer can be selected, it is also possible to select non-volatile memories
Device (non-volatile memory), such as disk memory.
In a particular application, one-key duplication instruction set sets up module 205, is additionally operable to set up described configuration information and described
Mapping relations between one-key duplicating instruction set.
In one embodiment, described system also includes:
Increase module, for increasing new issuing and new subscription；
More new module, for according to described new issuing and the new subscription described configuration information of renewal；
Modified module, for revising the most saved described issue and the configuration information of described subscription；
Removing module, for deleting the most saved described issue and the configuration information of described subscription.
By increasing, revising or delete the configuration information pre-set, it is possible to achieve to the number issued and subscribe to
According to change, make user can the most newly-built new issue and subscription, or amendment, delete the issue that created and order
Read.
Module in all embodiments of the invention, can pass through universal integrated circuit, such as CPU (Central
Processing Unit, central processing unit), or by ASIC (Application Specific Integrated
Circuit, special IC) realize.
Step in embodiment of the present invention method can carry out order according to actual needs and adjust, merges and delete.
Module in embodiment of the present invention system can merge according to actual needs, divides and delete.
The function of the module in embodiment of the present invention system and the step one_to_one corresponding in method.
One of ordinary skill in the art will appreciate that all or part of flow process realizing in above-described embodiment method, be permissible
Instructing relevant hardware by computer program to complete, described program can be stored in a computer read/write memory medium
In, this program is upon execution, it may include such as the flow process of the embodiment of above-mentioned each method.Wherein, described storage medium can be magnetic
Dish, CD, read-only store-memory body (Read-Only Memory, ROM) or random store-memory body (Random Access
Memory, RAM) etc..
The foregoing is only presently preferred embodiments of the present invention, not in order to limit the present invention, all essences in the present invention
Any amendment, equivalent and the improvement etc. made within god and principle, should be included within the scope of the present invention.
Claims (10)
1. the duplication maintaining method of a SQL Server data base, it is characterised in that described method includes:
Receive server log information and described server log information is verified；
If described server log Information Authentication is passed through, then it is connected to the publisher server, the Distributor that pre-set and orders
Read server；
Receive one-key duplication instruction set, according to described one-key duplication instruction set call described in pre-set publisher server, point
Send out server and the configuration information of Subscriber, and according to the automatic newly-built issue of described configuration information and subscription.
2. the duplication maintaining method of SQL Server data base as claimed in claim 1, it is characterised in that described in be connected to pre-
Before the publisher server, Distributor and the Subscriber that first arrange, including:
Pre-set publisher server, Distributor and Subscriber；
Select publication database, select distribution database, newly-built issue；
Select newly-built described issue, select subscription database, newly-built subscription；
Preserve described issue and the configuration information of described subscription；
Set up the one-key duplication instruction set being associated with described configuration information.
3. the duplication maintaining method of SQL Server data base as claimed in claim 2, it is characterised in that set up and join with described
Include after the one-key duplication instruction set of confidence manner of breathing association:
Increase new issuing and new subscription；
According to described new issuing and the new subscription described configuration information of renewal；
Revise the most saved described issue and the configuration information of described subscription；
Or, delete the most saved described issue and the configuration information of described subscription.
4. the duplication maintaining method of the SQL Server data base as described in any one of claims 1 to 3, it is characterised in that institute
State configuration information to include:
The title of the described publisher server pre-set, publisher server run the computer user of snapshot agent process and fast
Connect the mode of publisher server according to agency, the title of described publication database, username and password, described in pre-set；
The title of the described Distributor pre-set, the title of described distribution database, user name, password and filename and
Snapshot；
The title of the described Subscriber pre-set, distribution proxy isochronous this subscribe to luck traveling journey computer user and
Distribution agency connects this Subscriber mode, the title of described subscription database, user name, password, described in pre-set
Subscriber.
5. the duplication maintaining method of SQL Server data base as claimed in claim 1, it is characterised in that described method is also wrapped
Include:
Receive a key and delete instruction set, delete instruction set according to a described key and delete the issue and subscription created.
6. system is safeguarded in the duplication of a SQL Server data base, it is characterised in that described system includes:
Authentication module, is used for receiving server log information and verifying described server log information；
Server-connection module, if passing through for described server log Information Authentication, is then connected to the issue clothes pre-set
Business device, Distributor and Subscriber；
One-key duplication module, is used for receiving one-key duplication instruction set, according to described one-key duplication instruction set call described in set in advance
The configuration information of publisher server, Distributor and the Subscriber put, and according to the most newly-built of described configuration information
Cloth and subscription.
7. system is safeguarded in the duplication of SQL Server data base as claimed in claim 6, it is characterised in that described system is also wrapped
Include:
Server arranges module, is used for pre-setting publisher server, Distributor and Subscriber；
Issue creation module, be used for selecting publication database, select distribution database, newly-built issue；
Subscribe to creation module, for selecting newly-built described issue, select subscription database, newly-built subscription；
Memory module, for preserving described issue and the configuration information of described subscription；
One-key duplication instruction set sets up module, for setting up the one-key duplication instruction set being associated with described configuration information.
8. system is safeguarded in the duplication of SQL Server data base as claimed in claim 7, it is characterised in that described system is also wrapped
Include:
Increase module, for increasing new issuing and new subscription；
More new module, for according to described new issuing and the new subscription described configuration information of renewal；
Modified module, for revising the most saved described issue and the configuration information of described subscription；
Removing module, for deleting the most saved described issue and the configuration information of described subscription.
9. system is safeguarded in the duplication of the SQL Server data base as described in any one of claim 6～8, it is characterised in that institute
State configuration information to include:
The title of the described publisher server pre-set, publisher server run the computer user of snapshot agent process and fast
Connect the mode of publisher server according to agency, the title of described publication database, username and password, described in pre-set；
The title of the described Distributor pre-set, the title of described distribution database, user name, password and filename and
Snapshot；
The title of the described Subscriber pre-set, distribution proxy isochronous this subscribe to luck traveling journey computer user and
Distribution agency connects this Subscriber mode, the title of described subscription database, user name, password, described in pre-set
Subscriber.
10. system is safeguarded in the duplication of SQL Server data base as claimed in claim 6, it is characterised in that described system is also
Including:
One key removing module, deletes instruction set for receiving a key, deletes instruction set according to a described key, and deletion has created
Issue and subscribe to.
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 true CN106302473A (en) | 2017-01-04 |
| CN106302473B 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) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110557975A (en) * | 2018-04-02 | 2019-12-10 | 甲骨文国际公司 | Tenant data comparison for multi-tenant identity cloud services |
| 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 |
| CN112181677B (en) * | 2020-09-02 | 2024-05-31 | 珠海格力电器股份有限公司 | 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 |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110557975A (en) * | 2018-04-02 | 2019-12-10 | 甲骨文国际公司 | Tenant data comparison for multi-tenant identity cloud services |
| 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 |
| CN112181677B (en) * | 2020-09-02 | 2024-05-31 | 珠海格力电器股份有限公司 | Service processing method and device, storage medium and electronic device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106302473B (en) | 2019-09-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101854392B (en) | Personal data management method based on cloud computing environment | |
| CN106991035A (en) | A kind of Host Supervision System based on micro services framework | |
| CN104699423B (en) | The method and apparatus that drive is bound in linux system | |
| US20210091924A1 (en) | Blockchain partial ledgers | |
| CN111406260B (en) | Object storage system with secure object replication | |
| CN103064927A (en) | Data access method and device of distributed file system | |
| CN105184144A (en) | Multi-system privilege management method | |
| CN102170440A (en) | Method suitable for safely migrating data between storage clouds | |
| CN107273440A (en) | Computer application, date storage method, micro services and microdata storehouse | |
| CN110795709A (en) | Method and device for performing business operation, electronic equipment and storage medium | |
| CN106341371A (en) | Cloud storage data encryption method and cloud storage system | |
| CN105915338A (en) | Key generation method and key generation system | |
| US20210176328A1 (en) | Management Services for Distributed Computing Architectures Using Rolling Changes | |
| CN112235193B (en) | Data transmission method, device, equipment and medium based on cross-network multi-level routing | |
| CN106878084A (en) | A kind of authority control method and device | |
| CN105072183A (en) | Management method and management device for cloud operation system (OS) software repository | |
| CN109558191A (en) | A kind of method, apparatus, storage medium and computer equipment configuring the page | |
| CN103226612A (en) | Content management system based on main memory database | |
| CN101945097A (en) | Electronic bill processing method, device and system | |
| CN106302473A (en) | The duplication maintaining method of a kind of SQL Server data base and system | |
| CN111290776B (en) | Management device and method for managing blockchain nodes | |
| CN105159797B (en) | A kind of method for backing up and recovering based on oracle database | |
| CN104217283A (en) | Data sharing device and data sharing system | |
| CN113312669B (en) | Password synchronization method, device and storage medium | |
| CN113407626B (en) | Planning management and control method based on blockchain, storage medium and terminal equipment |
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 |