CPC G06F 16/213 (2019.01) [G06F 8/60 (2013.01); G06F 8/76 (2013.01); G06F 8/77 (2013.01)] | 20 Claims |
1. A system, comprising:
a database change management system coupled to a database server maintaining a database according to a database schema, the database change management system including a processor and a non-transitory computer readable medium storing computer executable instructions executable to provide a set of services comprising:
a packaging service configured to:
retrieve Structured Query Language (SQL) scripts from a source code manager repository;
package the SQL scripts, wherein packaging the SQL scripts comprises generating changesets pointing to the SQL scripts;
process the changesets to generate change objects that model changes to be applied to the database, wherein generating the change objects comprises parsing the SQL scripts and identifying, from the SQL scripts, the changes to be applied to the database;
apply the changes in the change objects to a virtual model of the database to simulate changing the database;
generate a forecast report based on simulating changing the database, wherein the forecast report is indicative of a prediction of a failure or success of an implementation of the changes to the database; and
responsive to a predicted implementation success, deploy the changes to the database.
|