Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQL (structured query language) Server based automatic script upgrading system and method

An automatic upgrade and script technology, applied in the database field, can solve problems such as incomplete coverage, and achieve the effect of reducing the difficulty of document management, simplifying upgrade operations, and improving efficiency

Inactive Publication Date: 2014-10-15
FUJIAN XINGHAI COMM TECH
View PDF4 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

There is also a sequence of script execution. Technical support personnel need to execute in strict accordance with the upgrade instructions to successfully upgrade the database version. Checking the upgrade results can only be judged by querying the upgrade record table or the verification function. The verification function is verified through the actual operation of the software product , often cannot completely cover the

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 (structured query language) Server based automatic script upgrading system and method
  • SQL (structured query language) Server based automatic script upgrading system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] like figure 2 As shown, the database in the present invention releases the database installation software and the database template at the same time when releasing the database, wherein the original library of the production library is the database to be upgraded, the production library generation template is the database template to be upgraded, and the release library template is the target database template;

[0034] A method for automatically upgrading scripts based on SQL Server, the method comprising the steps of:

[0035] Step 1. Select the target database template and automatically detect the version of the database template;

[0036] Step 2, the connection information of setting database, this connection information comprises IP address, database name, login user name and password;

[0037] Step 3. Execute 0_ check partition logical name and stored procedure script.sql, check and correct the stored procedure and partition logical name of the template library...

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 invention provides an SQL (structured query language) server based automatic script upgrading method. The method includes steps of selecting a target database; generating a database template; comparing the database template with a target database template and generating an upgrading script; executing the upgrading script; generating the upgraded database template, comparing the upgraded database with the target database to generate the upgrading script, and checking whether the upgraded database template and the target database template are consistent or not, if yes, upgrading successfully, if not, repeatedly upgrading. The invention further provides an SQL server based automatic script upgrading system comprising a database template selection module, a database setting module, a database template generating module, an upgrading script generating module, an upgrading script executing module and a checking module. Once upgrading of the database is realized and is accurate, upgrading operation is simplified, and file management difficulty is reduced.

Description

technical field [0001] The invention relates to the field of databases, in particular to a system and method for automatically upgrading scripts based on SQL Server. Background technique [0002] In the upgrade process of software products, the supporting upgrade of the database is generally the most troublesome. like figure 1 As shown, when the existing database is released, it includes the database installation package and the upgrade script. Each database version is based on the previous version, and the released upgrade scripts must be executed in sequence. If you upgrade across versions, you need to refresh each Several scripts for version releases. This method of updating scripts one by one needs to insert an upgrade record in the upgrade log table after each upgrade script is successfully executed to record whether the database has successfully upgraded the script. Large-scale systems are generally composed of multiple subsystems, which are developed with the coope...

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): G06F9/445G06F17/30
Inventor 邹山青魏军福
Owner FUJIAN XINGHAI COMM TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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