Database item versioning
AssigneeMicrosoft Corporation
InventorsSteven J. Kruy, William W. Ramos, Patrick Dengler, Julia Zhenglei Liuson
Life of this patent
Estimating the term…
Abstract
Database item versioning, such as items like stored procedures found in databases such as Standard Query Language (SQL) databases. In one embodiment, a program such as an editor, a database, a source and a mechanism. An editor program provides for editing a stored procedure. The databases includes the stored procedure. The SCC system stores versions of the stored procedure. The mechanism checks in and checks out the stored procedure to provide for effective versioning thereof.
Claims24
A computer-implemented method for a user to check out a database item from a source code control system, comprising:
- comparing a database item stored in the source code control system with a database item stored in a database;
- determining whether the compared database item in the source code control system is identical to the compared database item in the database;
- if it is determined that the compared database item in the source code control system is identical to the compared database item in the database, checking out the database item;
- and
- if it is determined that the compared database item in the source code control system is not identical to the compared database item in the database:
- providing the user a choice to select one of the database item in the source code control system and the database item in the database;
- and
- checking out the selected database item;
- wherein a historic record of the checked out database item is maintained, permitting changes to the database item to be traced thus enabling determination of when a change was introduced.
A computer-readable storage medium having instructions stored thereon for execution by a computer to perform a method, comprising:
- comparing a database item stored in the source code control system with a database item stored in a database;
- if it is determined that the compared database item in the source code control system is identical to the compared database item in the database, checking out the database item;
- and
- if it is determined that the compared database item in the source code control system is not identical to the compared database item in the database:
- providing the user a choice to select one of the database item in the source code control system and the database item in the database;
- and
- checking out the selected database item;
- wherein a historic record of the checked out database item is maintained, permitting changes to the database item to traced thus enabling determination of when a change was introduced.
Dependencies are inferred from the claim text.