Repository-based state diffing system and migration script generating system for databases

A computing system, comprising:

• one or more computing devices including at least one processor connected to at least one memory;
• and
• a state diffing system configured with executable instructions stored on a non-transitory computer readable medium that when executed by at least one processor of the one or more computing devices, cause the computing system to migrate objects from a developmental database to a repository;
• wherein the state diffing system includes an export function configured to automatically control placement of selected objects into the repository in a standardized manner based on at least placement rules that specify a folder structure and designated folder locations in the folder structure for different types of objects;
• wherein the placement rules specify at least a first type of object is stored in a first designated folder in the repository and a second type of object is stored in a second designated folder in the repository based on the folder structure;
• wherein the state diffing system further includes a formatting function configured to automatically reformat code from the selected objects being exported in a consistent standardized format based on a set of formatting rules;
• wherein the formatting function is configured to reformat a particular type of code based on a designated format associated with the particular type of code, wherein occurrences of the particular type of code that appears in multiple objects of the selected objects is reformatted to have a consistent format across the multiple objects;
• and
• wherein the state diffing system is configured to export state details that define a state of the selected objects at a point in time for comparing each selected object to itself at a different point in time;
• wherein the state diffing system further includes:
• a diffing command configured to deploy a feature branch in the repository to a target branch;
• wherein the diffing command is configured to:
• perform a cross comparison on contents of the feature branch with contents of the target branch;
• determine content changes between the feature branch and the target branch based on the cross comparison;
• generate a distribution folder including the content changes;
• and
• generate one or more migration scripts based on at least the content changes, wherein the one or more migration scripts are executable to change the state of a target database to match a state of the repository.

A method performed by a computing system, the method comprising:

• receiving an export command to export selected objects of a database feature from a developmental database to a repository:
• in response to receiving the export command, initiating an export function that causes the computing system to export the selected objects from the developmental database to the repository, wherein the export function performs actions comprising:
• identifying the selected objects from the export command;
• automatically controlling placement of the selected objects into the repository based on at least placement rules that specify a repository location for different types of objects;
• determining a location within the repository to place the selected objects based on at least the placement rules;
• storing the selected objects into the repository, wherein a first type of object is stored in a first designated folder in the repository and a second type of object is stored in a second designated folder in the repository based on the placement rules;
• executing a formatting function configured with formatting rules that reformat the selected objects to have a standardized format;
• and
• exporting state details that define a state of the selected objects at a point in time to allow a comparison function to compare each selected object to itself at a different point in time;
• in response to receiving a diffing command that is configured to determine changes between a feature branch in the repository and a target branch:
• performing a cross comparison on contents of the feature branch with contents of the target branch;
• determining content changes between the feature branch and the target branch based on the cross comparison;
• generating a distribution folder including the content changes;
• and
• generating one or more migration scripts based on at least the content changes, wherein the one or more migration scripts are executable to change the state of a target database to match a state of the repository.