Supercharge Your Innovation With Domain-Expert AI Agents!

SQL Server database replicating and maintaining method and system

A technology for maintaining systems and databases, applied in the field of SQL Server databases, can solve the problems of complex operations, increase the work intensity of operators, and inefficient copy operation methods, and achieve the effects of simplifying copy operations, improving copy efficiency, and reducing maintenance costs.

Active Publication Date: 2017-01-04
SHENZHEN KINGDOM TECH
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The object of the present invention is to provide a kind of copy maintenance method and system of SQL Server database, aim at solving the copy operation of SQL Server database and require the operator to have professional knowledge of database copy, before upgrading the system that includes SQLServer database, the copy must be deleted earlier, The operation of rebuilding the replication after the upgrade is more complicated. For the system that needs frequent upgrades and updates, the traditional SQL Server database replication operation method is inefficient and increases the work intensity of the operators.

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL Server database replicating and maintaining method and system
  • SQL Server database replicating and maintaining method and system
  • SQL Server database replicating and maintaining method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] Such as figure 1 As shown, the replication maintenance method of the SQL Server database provided by the present embodiment includes:

[0024] Step S101: Receive server login information and verify the server login information.

[0025] In this embodiment, QL Server database replication refers to publishing the data to be synchronized on the data source database server, and then subscribing to the publication on the target database server, so as to realize real-time synchronization of database data. The data source database server is the publisher, and the target database server is the subscriber server. The distributor is used to transfer the database data published by the publisher to send to one or more subscribers respectively.

[0026] In a specific application, the server login information includes database user login information and computer user login information of the publishing server, distribution server and subscription server, and the user login informati...

Embodiment 2

[0046] Such as figure 2 As shown, before step S101 in the first embodiment, this embodiment also includes:

[0047] Step 201: pre-setting the publisher, distributor and subscriber.

[0048] In a specific application, the preset publishing server, distribution server, and subscription server specifically refer to pre-selecting and configuring configuration information of the publishing server, distribution server, and subscription server.

[0049] Step S202: Select a release database, select a distribution database, and create a new release.

[0050] In a specific application, selecting a publishing database specifically refers to selecting a publishing server for performing the new publishing operation, and then selecting a database or all or part of data in the database to be published in the selected publishing server. Correspondingly, selecting a distribution database refers to selecting a distribution server for performing the new publishing operation, and then selectin...

Embodiment 3

[0075] Such as image 3 As shown, the replication maintenance system of the SQL Server database provided by this embodiment includes:

[0076] A verification module 101, configured to receive server login information and verify the server login information;

[0077] The server connection module 102 is used to connect to the pre-set publishing server, distribution server and subscription server if the server login information is verified;

[0078] The one-key copy module 103 is configured to receive a one-key copy instruction set, call the preset configuration information of the publishing server, distribution server, and subscriber server according to the one-key copy instruction set, and automatically create a new publication according to the configuration information and subscribe.

[0079] In one embodiment, the system further includes a maintenance module, configured to maintain the preset configuration information of the publisher, distributor and subscriber;

[0080] ...

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

No PUM Login to View More

Abstract

The present invention is applicable to the SQL Server database field, and provides an SQL Server database replicating and maintaining method and system. The method comprises: receiving server login information and verifying the server login information; if verification on the server login information succeeds, connecting to a publishing server, a distribution server, and a subscription server that are disposed in advance; receiving a one key replication instruction set, invoking the configuration information according to the one key replication instruction set, and automatically establishing publishing and subscription according to the configuration information. According to the SQL Server database replicating and maintaining method and system, security verification is performed on the server login information, to ensure validity of a login user, and when the one key replication instruction set is received, the configuration information of the publishing server, the distribution server, and the subscription server that are disposed in advanced is invoked, to automatically establish publishing and subscription, so that a one key database replication function may be implemented, a database replication operation is simplified, database replication efficiency is improved, a workload of operating personnel is reduced, and maintenance costs are reduced.

Description

technical field [0001] The invention belongs to the field of SQL Server databases, in particular to a method and system for duplicating and maintaining SQL Server databases. Background technique [0002] SQL Server database is a relational database management system launched by Microsoft Corporation. It is mainly used to solve the problem of database real-time synchronization. It copies and distributes data and database objects from one database to another or several databases, then synchronizes between databases, and compares database snapshots to ensure data integrity. [0003] However, the replication operation of the SQL Server database requires the operator to have professional database replication knowledge. Before upgrading the system including the SQL Server database, the replication must be deleted first, and the replication must be rebuilt after the upgrade. The operation is more complicated. Systemically speaking, the traditional SQL Server database replication o...

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
no application Login to View More
IPC IPC(8): H04L29/06H04L12/24G06F17/30
Inventor 丁广社
Owner SHENZHEN KINGDOM TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com