DATABASE SCHEMA MIGRATION

摘要

Various example embodiments are directed to systems and methods for migrating a database from a source database having a source schema to a target database having a target schema. For example, a computing device may identify a first source schema table associated with a first migration instruction. The first migration instruction may comprise a plurality of migration instruction sets. Each of the plurality of migration instruction sets may correspond to a version of the first source schema table. The computing device may determine that there is a match between the first source schema table and a first migration instruction set and may execute the first migration instruction set. Executing the first migration instruction set may comprise selecting at least one column of the first source schema table and writing the at least one column of the first source schema table to a first target schema table.

主权项

1. A computer-implemented system for migrating a database from a source database having a source schema to a target database having a target schema, wherein the source schema defines a plurality of source schema tables, the system comprising:
at least one processor and operatively associated memory, wherein the at least one processor is programmed to:
receive a list of tables at the source database, wherein the list of tables comprises a first source schema table;traverse the list of tables, wherein the traversing comprises, for each table in the list of tables, determining whether there is a corresponding migration instruction;for the first source schema table, identify an associated first migration instruction, wherein the first migration instruction comprises a plurality of migration instruction sets, wherein each migration instruction set of the plurality of migration instruction sets corresponds to a version of the first source schema table, and wherein each migration instruction set of the plurality of instruction sets is associated with schema identifier data identifying the version of the source schema table corresponding to the migration instruction set;match the first source schema table to schema identifier data associated with a first migration instruction set selected from the plurality of migration instruction sets; andexecute the first migration instruction set, wherein executing the first migration instruction set comprises selecting at least one column of the first source schema table and writing the at least one column of the first source schema table to a first target schema table.