Method and system of database migration

A system for generative artificial intelligence (GenAI) powered database migration, the system comprising:

• at least one memory configured to store machine-executable instructions;
• and
• at least one processor communicatively coupled with the at least one memory, and configured to execute the machine-executable instructions to perform operations comprising:
• extracting a metadata structure of a database associated with a source system of a plurality of source systems, wherein the database comprises at least one of visuals, relations, tables, and dependencies;
• generating, based upon the metadata structure, a prompt for converting the metadata structure of the database associated with the source system into a corresponding metadata structure associated with a destination system;
• generating a response to the prompt using a dynamic large language model, wherein the response comprises conversion of the metadata structure of the database associated with the source system to the metadata structure associated with the destination system;
• and
• migrating, based upon the response to the prompt, the database from the source system to the destination system.

A non-transitory computer-readable media (CRM) comprising machine-executable instructions stored thereon, which, when executed by at least one processor of a computing device, cause the at least one processor in migration of data using generative artificial intelligence (GenAI) by performing operations comprising:

• extracting a metadata structure of a database associated with a source system of a plurality of source systems, wherein the database comprises at least one of visuals, relations, tables, and/or dependencies;
• generating, based upon the metadata structure, a prompt for converting the metadata structure of the database associated with the source system into a corresponding metadata structure associated with a destination system;
• generating a response to the prompt using a dynamic large language model, wherein the response comprises conversion of the metadata structure of the database associated with the source system to the destination system;
• and
• migrating, based upon the response to the prompt, the database from the source system to the destination system.