BACKGROUND

Field of the Invention

This application relates to a database metadata transfer system and methods thereof. More particularly, embodiments of the present disclosure are related to a system and method for transforming an output produced by a database scanner and creating instructions to transfer database metadata to a new database.

Description of the Related Art

In software deployment, methods often include testing new code in a development environment system (“pre-production” or “preprod”) that runs the same code that the end users will use (“production” or “prod”) but with new code pushed to the preprod environment first. Code changes are first pushed to pre-production, validation tests are executed, and when they pass the code changes are pushed to production. By testing and analyzing the output of the pre-production system, the impact of the code change on the production system can be determined. There may also be several stages in between preprod and prod. This structured release management process allows phased deployment (rollout), testing, and rollback in case of problems.

A problem exists because often preprod data and prod data do not match. Solutions for fixing this problem have included having the developers fill out manual forms to alert others charged with fixing the problem or having additional developers or users fix the problem. The problem with these solutions is they take a significant amount of time and effort to complete, and these manual processes increase the risk of human error. A need exists for an improved system of correcting the problem of mismatched preprod and prod data in a quick and automatic way.

SUMMARY

Example embodiments of the present application provide at least a database metadata transfer system and methods thereof. According to an exemplary embodiment of the present invention, there is provided a method comprising receiving a command to transfer preproduction metadata to production metadata; reading preproduction database metadata; generating a data file for making the change, the data file comprising SQL commands (upinserts) and/or insert statements; and executing a transfer from preproduction metadata to production metadata based on the SQL commands and/or insert statements. In some embodiments, the database may be a call center database and the data file may an Extensible Markup Language (XML) file.

