Database metadata transfer system and methods thereof
Disclosed herein are database metadata transfer systems and methods thereof. The database metadata transfer methods may include 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 or insert statements; and executing a transfer from preproduction metadata to production metadata based on the SQL commands 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.
1. A method for database metadata transfer, the method comprising:
receiving, by a computer, a command to transfer preproduction metadata from a preproduction database to a production metadata database containing production metadata;
reading, by the computer, the preproduction metadata from the preproduction database;
generating, by the computer, an extensible markup language (XML) data file containing the preproduction metadata;
generating, by the computer, structured query language (SQL) commands in the XML data file;
generating, by the computer, a list of preproduction metadata to be transferred using the XML data file; and
transferring, by the computer, the list of preproduction metadata to the database containing production metadata in response to the SQL commands.
2. The method of claim 1 , wherein the database is a call center database.
3. The method of claim 1 , wherein the SQL commands are completed using micro language.
4. The method of claim 1 , wherein the data file comprises a list of commands generated by the system that allow development of a list of data that needs to be transferred into a production database.
5. An apparatus comprising:
memory; and
a processor configured to:
receive a command to transfer preproduction metadata from a from a preproduction database to a production metadata database containing production metadata;
read the preproduction metadata from the preproduction database;
generate an extensible markup language (XML) data file containing the preproduction metadata;
generate structured query language (SQL) commands in the XML data file;
generate a list of preproduction metadata to be transferred using the XML data file; and
transfer the list of preproduction metadata to the database containing production metadata in response to the SQL commands.
6. The apparatus of claim 5 , wherein the database is a call center database.
7. The apparatus of claim 5 , wherein the SQL commands are completed using micro language.
8. The apparatus of claim 5 , wherein the data file comprises a list of commands generated by the system that allow development of a list of data that needs to be transferred into a production database.
9. A non-transitory computer readable storage medium configured to store instructions that when executed by a processor causes the processor to:
receive a command to transfer preproduction metadata from a from a preproduction database to a production metadata database containing production metadata;
read the preproduction metadata from the preproduction database;
generate an extensible markup language (XML) data file containing the preproduction metadata;
generate structured query language (SQL) commands in the XML data file;
generate a list of preproduction metadata to be transferred using the XML data file; and
transfer the list of preproduction metadata to the database containing production metadata in response to the SQL commands.
10. The non-transitory computer readable storage medium of claim 9 , wherein the database is a call center database.
11. The non-transitory computer readable storage medium of claim 9 , wherein the SQL commands are completed using micro language.
12. The non-transitory computer readable storage medium of claim 9 , wherein the data file comprises a list of commands generated by the system that allow development of a list of data that needs to be transferred into a production database.