Database table conversion
AssigneeSap SE
InventorsJuergen Specht, Volker Driesen
Life of this patent
Estimating the term…
Abstract
Methods, systems, and computer program products for converting a database table and implementing upgrades and/or migrations are described. A bridge schema comprising a bridge view for a table in a database of an original schema is created and a bridge application server instance is created, the bridge application server instance configured to utilize the bridge schema to access the table of the original schema. The table of the original schema is revised to conform to a specified target schema and a target application server instance configured to access the revised table is created.
Claims20
A computerized method for performing an upgrade, the method comprising:
- creating a bridge schema comprising a bridge view in the bridge schema for a table of an original schema, wherein a first field of the table is of a first data type in the original schema, and wherein the first field is of a second data type in a target schema;
- adding to the table a revised first field having the second data type, wherein the bridge view accesses the first field and does not access the revised first field;
- creating a bridge application server instance, the bridge application server instance configured to utilize the bridge schema containing the bridge view to access the table;
- copying data from the first field to the revised first field, wherein the copying comprises modifying the data from the first field from the first data type to the second data type;
- deleting the first field;
- renaming the revised first field to a name of the first field;
- and
- creating a target application server instance configured to access the table.
An apparatus for performing an upgrade, the apparatus comprising:
- one or more hardware processors;
- memory to store instructions that, when executed by the one or more hardware processors perform operations comprising:
- creating a bridge schema comprising a bridge view in the bridge schema for a table of the original schema, wherein a first field of the table is of a first data type in an original schema, and wherein the first field is of a second data type in a target schema;
- adding to the table a revised first field having the second data type, wherein the bridge view accesses the first field and does not access the revised first field;
- creating a bridge application server instance, the bridge application server instance configured to utilize the bridge schema to access the table;
- copying data from the first field to the revised first field, wherein the copying comprises modifying the data from the first field from the first data type to the second data type;
- deleting the first field;
- renaming the revised first field to a name of the first field;
- and
- creating a target application server instance configured to access the table.
A non-transitory computer-readable medium embodying instructions that, when executed by a processor, perform operations comprising:
- creating a bridge schema comprising a bridge view for a table in a database of an original schema, wherein a first field of the table is of a first data type in the original schema, and wherein the first field is of a second data type in a target schema;
- adding to the table a revised first field having the second data type, wherein the bridge view accesses the first field and does not access the revised first field;
- creating a bridge application server instance, the bridge application server instance configured to utilize the bridge schema to access the table;
- copying data from the first field to the revised first field, wherein the copying comprises modifying the data from the first field from the first data type to the second data type;
- deleting the first field;
- renaming the revised first field to a name of the first field;
- and
- creating a target application server instance configured to access the table.
Dependencies are inferred from the claim text.