CN107103041A - A kind of storage method and storage system of SQL SERVER database updates - Google Patents
A kind of storage method and storage system of SQL SERVER database updates Download PDFInfo
- Publication number
- CN107103041A CN107103041A CN201710194224.4A CN201710194224A CN107103041A CN 107103041 A CN107103041 A CN 107103041A CN 201710194224 A CN201710194224 A CN 201710194224A CN 107103041 A CN107103041 A CN 107103041A
- Authority
- CN
- China
- Prior art keywords
- renewal
- database
- new
- updated
- script
- 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.)
- Pending
Links
Classifications
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of update method and more new system of SQL SERVER databases, and the update method includes：Database schema change DDL triggers are created, and database to be updated is associated with the DDL triggers；The renewal to the framework of the database to be updated is received, the DDL triggers and record more new content and renewal time are started according to described update；More new script, and more new script described in issue are generated according to the renewal time and more new content.Implement the embodiment of the present invention, the renewal personnel updated every time and renewal time can be not only obtained from DDL triggers, and incremental update script can be generated according to renewal time.
Description
Technical field
The present invention relates to electric data processing field, more particularly to a kind of storage method of SQL SERVER database updates and
Storage system.
Background technology
In project development, exploration project is completed jointly by the member of project team.On stream, each member can
In the presence of the change to database schema, change record is difficult to safeguard and reviewed, and typically hand is passed through when final version updates
Flowing mode or third party's instrument compare source database and target database framework production script.Manual integration more new script is poorly efficient
And easily malfunction；Comparison instrument equally exists 2 problems：1st, it can not review and examine when whom which change grasped by
Make.2nd, can only be based on current source database and all framework comparing differences of target data production more new script, it is impossible to according to tool
Body time point generates incremental update script.
The content of the invention
In view of this, the present invention provides a kind of update method and more new system of SQL SERVER databases, existing to solve
The problem of thering is technology can not inquire about renewal personnel, and incremental update script can not be generated.
Specifically, the present invention is achieved through the following technical solutions：
The present invention provides a kind of update method of SQL SERVER databases, and the update method includes：
Database schema change DDL triggers are created, and database to be updated is associated with the DDL triggers；
The renewal to the framework of the database to be updated is received, the DDL triggers are started according to the renewal and remembered
Record more new content and renewal time；
More new script, and more new script described in issue are generated according to the renewal time and more new content.
Present invention also offers a kind of more new system of SQL SERVER databases, the more new system includes：
Associative cell, for creating database schema change DDL triggers, and database to be updated is touched with the DDL
Hair device is associated；
Recording unit is updated, the renewal for receiving the framework to the database to be updated starts according to described update
The DDL triggers simultaneously record more new content and renewal time；
More new script release unit, for generating more new script according to the renewal time and more new content, and issues institute
State more new script.
The embodiment of the present invention, creates database schema change DDL triggers, and by database to be updated and DDL triggers
Be associated, receive and treat the renewal of the framework for updating the data storehouse, according to update start DDL triggers and record more new content and
Renewal time, more new script is generated according to renewal time and more new content, and issue renewal script so that the renewal to database
All recorded by DDL triggers, be easy to from DDL triggers inquire about more new content and renewal time, not only can be from DDL
Trigger obtains the renewal personnel updated every time and renewal time, and can generate incremental update script according to renewal time.
Brief description of the drawings
Fig. 1 is a kind of flow of the update method of SQL SERVER databases shown in an exemplary embodiment of the invention
Figure；
Fig. 2 is a kind of structure of the more new system of SQL SERVER databases shown in an exemplary embodiment of the invention
Figure.
Embodiment
Here exemplary embodiment will be illustrated in detail, its example is illustrated in the accompanying drawings.Following description is related to
During accompanying drawing, unless otherwise indicated, the same numbers in different accompanying drawings represent same or analogous key element.Following exemplary embodiment
Described in embodiment do not represent and the consistent all embodiments of the present invention.On the contrary, they be only with it is such as appended
The example of the consistent apparatus and method of some aspects be described in detail in claims, the present invention.
It is the purpose only merely for description specific embodiment in terminology used in the present invention, and is not intended to be limiting the present invention.
" one kind ", " described " and "the" of singulative used in the present invention and appended claims are also intended to including majority
Form, unless context clearly shows that other implications.It is also understood that term "and/or" used herein refers to and wrapped
It may be combined containing one or more associated any or all of project listed.
It will be appreciated that though various information, but this may be described using term first, second, third, etc. in the present invention
A little information should not necessarily be limited by these terms.These terms are only used for same type of information being distinguished from each other out.For example, not departing from
In the case of the scope of the invention, the first information can also be referred to as the second information, similarly, and the second information can also be referred to as
One information.Depending on linguistic context, word as used in this " if " can be construed to " ... when " or " when ...
When " or " in response to determining ".
It is a kind of update method of SQL SERVER databases shown in an exemplary embodiment of the invention as shown in Figure 1
Flow chart, the update method includes：
Step S101, creates database schema change DDL triggers, and by database to be updated and the DDL triggers
It is associated.
In embodiments of the present invention, the database schema change recordable upgating object of DDL triggers includes：Tables of data,
View, storing process, function, index, method, constraint etc., as long as having carried out above-mentioned change, you can trigger data storehouse framework becomes
More DDL triggers, therefore the present invention creates database schema change DDL triggers first, and by the DDL triggers and treat more
New database is associated.
Step S102, receives the renewal to the framework of the database to be updated, is touched according to the startup DDL that updates
Send out device and record more new content and renewal time.
In embodiments of the present invention, due to DDL triggers being associated with database to be updated, therefore when storage system
When system receives the renewal of any framework treated and update the data storehouse, storage system starts DDL triggers according to the renewal, and leads to
Spend the DDL recording triggers more new content and renewal time.Wherein, more new content includes but is not limited to：Upgating object, renewal
Operation information.The information of record includes：The metadata information of object after the original XML information of change operation and renewal.
Renewal of the reception to the framework of the database to be updated, including：
Receive and pass through renewal of the script to the framework of the database to be updated；And/or,
Receive and pass through renewals of the SSMS to the framework of the database to be updated.
In embodiments of the present invention, the renewal to SQL SERVER databases generally passes through script or SSMS by operating personnel
(SQL SERVER Management Studio) is realized, therefore storage system can be received by script or treated more by SSMS
The renewal of the framework of new database.
Step S103, more new script, and more new script described in issue are generated according to the renewal time and more new content.
In embodiments of the present invention, according to specify at the beginning of between and the end time (recording in DDL triggers), carry
Take the metadata latest edition and benchmark version corresponding objects member of the object that has altered in the range of the time started to end time
Comparing, automatically generates more new script, and issues the more new script, preserves all benchmark database versions and does not change object
Metadata and changed the metadata latest edition snapshot of object, be used as new database version, registration database version number
And update operation current time.
The embodiment of the present invention, creates database schema change DDL triggers, and by database to be updated and DDL triggers
Be associated, receive and treat the renewal of the framework for updating the data storehouse, according to update start DDL triggers and record more new content and
Renewal time, more new script is generated according to renewal time and more new content, and issue renewal script so that the renewal to database
All recorded by DDL triggers, be easy to from DDL triggers inquire about more new content and renewal time, not only can be from DDL
Trigger obtains the renewal personnel updated every time and renewal time, and can generate incremental update script according to renewal time.
A kind of more new system for the SQL SERVER databases being illustrated in figure 2 shown in an exemplary embodiment of the invention
Structure chart, the structure chart includes：
Associative cell 201, for creating database schema change DDL triggers, and by database to be updated and the DDL
Trigger is associated.
In embodiments of the present invention, the database schema change recordable upgating object of DDL triggers includes：Tables of data,
View, storing process, function, index, method, constraint etc., as long as having carried out above-mentioned change, you can trigger data storehouse framework becomes
More DDL triggers, therefore the present invention creates database schema change DDL triggers first, and by the DDL triggers and treat more
New database is associated.
Recording unit 202 is updated, the renewal for receiving the framework to the database to be updated is opened according to the renewal
Move the DDL triggers and record more new content and renewal time.
In embodiments of the present invention, due to DDL triggers being associated with database to be updated, therefore when storage system
When system receives the renewal of any framework treated and update the data storehouse, storage system starts DDL triggers according to the renewal, and leads to
Spend the DDL recording triggers more new content and renewal time.Wherein, more new content includes but is not limited to：Upgating object, renewal
Operation information.The information of record includes：The metadata information of object after the original XML information of change operation and renewal.
Renewal of the reception to the framework of the database to be updated, including：
Receive and pass through renewal of the script to the framework of the database to be updated；And/or,
Receive and pass through renewals of the SSMS to the framework of the database to be updated.
In embodiments of the present invention, the renewal to SQL SERVER databases generally passes through script or SSMS by operating personnel
(SQL SERVER Management Studio) is realized, therefore storage system can be received by script or treated more by SSMS
The renewal of the framework of new database.
More new script release unit 203, for generating more new script according to the renewal time and more new content, and is issued
The more new script.
In embodiments of the present invention, according to specify at the beginning of between and the end time (recording in DDL triggers), carry
Take the metadata latest edition and benchmark version corresponding objects member of the object that has altered in the range of the time started to end time
Comparing, automatically generates more new script, and issues the more new script, preserves all benchmark database versions and does not change object
Metadata and changed the metadata latest edition snapshot of object, be used as new database version, registration database version number
And update operation current time.
The embodiment of the present invention, creates database schema change DDL triggers, and by database to be updated and DDL triggers
Be associated, receive and treat the renewal of the framework for updating the data storehouse, according to update start DDL triggers and record more new content and
Renewal time, more new script is generated according to renewal time and more new content, and issue renewal script so that the renewal to database
All recorded by DDL triggers, be easy to from DDL triggers inquire about more new content and renewal time, not only can be from DDL
Trigger obtains the renewal personnel updated every time and renewal time, and can generate incremental update script according to renewal time.
Device embodiment described above is only schematical, wherein the unit illustrated as separating component can
To be or may not be physically separate, the part shown as unit can be or may not be physics list
Member, you can with positioned at a place, or can also be distributed on multiple NEs.It can be selected according to the actual needs
In some or all of module realize the purpose of the present invention program.Those of ordinary skill in the art are not paying creative labor
In the case of dynamic, you can to understand and implement.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all essences in the present invention
God is with principle, and any modification, equivalent substitution and improvements done etc. should be included within the scope of protection of the invention.
Claims (6)
1. a kind of update method of SQL SERVER databases, it is characterised in that the update method includes：
Database schema change DDL triggers are created, and database to be updated is associated with the DDL triggers；
The renewal to the framework of the database to be updated is received, the DDL triggers are started according to the renewal and recorded more
New content and renewal time；
More new script, and more new script described in issue are generated according to the renewal time and more new content.
2. update method as claimed in claim 1, it is characterised in that the reception is to the framework of the database to be updated
Update, including：
Receive and pass through renewal of the script to the framework of the database to be updated；And/or,
Receive and pass through renewals of the SSMS to the framework of the database to be updated.
3. the update method as described in any one of claim 1~2, it is characterised in that more new content includes：Upgating object, more
New operation information.
4. a kind of more new system of SQL SERVER databases, it is characterised in that the more new system includes：
Associative cell, for creating database schema change DDL triggers, and by database to be updated and the DDL triggers
It is associated；
Update recording unit, the renewal for receiving the framework to the database to be updated, according to starting the renewal
DDL triggers simultaneously record more new content and renewal time；
More new script release unit, for generating more new script according to the renewal time and more new content, and described in issue more
New script.
5. more new system as claimed in claim 4, it is characterised in that the reception is to the framework of the database to be updated
Update, including：
Receive and pass through renewal of the script to the framework of the database to be updated；And/or,
Receive and pass through renewals of the SSMS to the framework of the database to be updated.
6. more new system as claimed in claim 4, it is characterised in that more new content includes：Upgating object, renewal operation letter
Breath.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710194224.4A CN107103041A (en) | 2017-03-28 | 2017-03-28 | A kind of storage method and storage system of SQL SERVER database updates |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710194224.4A CN107103041A (en) | 2017-03-28 | 2017-03-28 | A kind of storage method and storage system of SQL SERVER database updates |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107103041A true CN107103041A (en) | 2017-08-29 |
Family
ID=59674852
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710194224.4A Pending CN107103041A (en) | 2017-03-28 | 2017-03-28 | A kind of storage method and storage system of SQL SERVER database updates |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107103041A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108733743A (en) * | 2018-03-23 | 2018-11-02 | 山东昭元信息科技有限公司 | A kind of time series database version management implementing method based on time shaft |
| CN111741038A (en) * | 2019-03-25 | 2020-10-02 | 华为技术有限公司 | Data transmission method and data transmission device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN105447014A (en) * | 2014-08-15 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Metadata management method based on binglog, and method and device used for providing metadata |
| CN105955746A (en) * | 2016-05-06 | 2016-09-21 | 中国银行股份有限公司 | Version management method and apparatus |
-
2017
- 2017-03-28 CN CN201710194224.4A patent/CN107103041A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN105447014A (en) * | 2014-08-15 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Metadata management method based on binglog, and method and device used for providing metadata |
| CN105955746A (en) * | 2016-05-06 | 2016-09-21 | 中国银行股份有限公司 | Version management method and apparatus |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108733743A (en) * | 2018-03-23 | 2018-11-02 | 山东昭元信息科技有限公司 | A kind of time series database version management implementing method based on time shaft |
| CN108733743B (en) * | 2018-03-23 | 2021-04-23 | 山东昭元信息科技有限公司 | Time-axis-based time sequence database version management implementation method |
| CN111741038A (en) * | 2019-03-25 | 2020-10-02 | 华为技术有限公司 | Data transmission method and data transmission device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8683430B2 (en) | Synchronizing development code and deployed executable versioning within distributed systems | |
| US9720994B2 (en) | Replicated database structural change management | |
| US20200050588A1 (en) | Automatic file version verification within electronic mail | |
| US8918447B2 (en) | Methods, apparatus, systems and computer readable mediums for use in sharing information between entities | |
| US8561023B2 (en) | Software change management extension for uniformly handling artifacts with relaxed contraints | |
| US9116899B2 (en) | Managing changes to one or more files via linked mapping records | |
| US10740298B2 (en) | File synchronization with reduced conflicts in computing systems | |
| US10255308B2 (en) | Conforming data structure instances to schema versions | |
| US10402408B2 (en) | Versioning of inferred data in an enriched isolated collection of resources and relationships | |
| US8306946B2 (en) | Deployment manager for master data management | |
| US20120290544A1 (en) | Data compliance management | |
| US10698681B2 (en) | Parallel development of a software system | |
| US8805777B2 (en) | Data record collapse and split functionality | |
| US20110161931A1 (en) | Automated stream-based change flows within a software configuration management system | |
| US8412681B2 (en) | Content archival and retrieval | |
| CN107103041A (en) | A kind of storage method and storage system of SQL SERVER database updates | |
| US20090282388A1 (en) | Optimizing the handling of source code requests between a software configuration management (scm) system and a software integrated development environment (ide) using projected ancillary data | |
| US20090282083A1 (en) | configuration of multiple database audits | |
| Ali et al. | Customization of software as a service application: problems and objectives | |
| US20150100888A1 (en) | Providing a common interface for accessing and presenting component configuration settings | |
| US20100114898A1 (en) | Publication services | |
| JP6287093B2 (en) | Software development support apparatus, software development support method and program | |
| US20240086416A1 (en) | Methods and systems for integrating external systems of records with final report | |
| US10506060B2 (en) | Method and system for tracking chain of custody on unstructured data | |
| US11971708B2 (en) | Method for providing context based artefact access |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170829 |
|
| RJ01 | Rejection of invention patent application after publication |