Granted Patent B2

US 12,579,114 · App. 18/806,247 · Granted Mar 17, 2026

Inventors: Jeffrey Allen Erickson (Farmersville, TX); Marjorie Ann Bue (Clear Lake, MN); Richard Forrest Herwig, Jr. (Burnsville, MN); Michael Shaun Ogilvie (Little Canada, MN); George Reynard Davis, Jr. (Charlotte, NC); Denise May Broderick (Zimmerman, MN)

Assignee: Wells Fargo Bank, N.A.

G06F16/214G06F16/212G06F16/2282G06F16/2379

Abstract

Claims (71)

1 . A computer-implemented method for a relational database management system, comprising:

generating a graphical user interface, the graphical user interface including a first migration button and a second migration button, wherein the graphical user interface is configured such that:

(i) a first selection of the first migration button generates a first Structured Query Language (SQL) computer-executable database management script configured to modify a data entry of an initial control table to adapt the data entry to a first database metadata attribute associated with a first control table of a first database; and

(ii) a second selection of the second migration button generates a second SQL computer-executable database management script that is configured to modify the data entry of the initial control table to adapt the data entry to a second database metadata attribute associated with a second control table of a second database; and

migrating the data entry to one of the first control table of the first database and the second control table of the second database based on the first selection or the second selection,

wherein the first SQL computer-executable database management script is different from the second SQL computer-executable database management script;

wherein the first database is different from the second database; and

wherein the first database metadata attribute is different from the second database metadata attribute.

2 . The computer-implemented method of claim 1 ,

wherein selection of the first migration button causes the data entry to be modified by updating the data entry to be compatible with first metadata of the first database; and

wherein selection of the second migration button causes the data entry to be modified by updating the data entry to be compatible with second metadata of the second database.

3 . The computer-implemented method of claim 2 ,

wherein the first metadata includes first schema of the first control table; and

wherein the second metadata includes second schema of the second control table.

4 . The computer-implemented method of claim 3 , wherein each of the first metadata and the second metadata includes one or more of:

a number of table rows;

a type of table row; and

a data type of a table field.

5 . The computer-implemented method of claim 3 , wherein each of the first metadata and the second metadata includes a data type of a table field, the data type including one of:

a character only data type;

a numerical only data type; and

an alphanumeric data type.

6 . The computer-implemented method of claim 3 , wherein each of the first metadata and the second metadata includes a data type of a table field, the data type including a number of decimal places data type.

7 . The computer-implemented method of claim 1 ,

wherein execution of the first SQL computer-executable database management script generates a first indicator that an update of first data fields of a first table succeeded or failed; and

wherein execution of the second SQL computer-executable database management script generates a second indicator that an update of second data fields of a second table succeeded or failed.

8 . The computer-implemented method of claim 1 , wherein the first migration button and the second migration button are selectable from a dropdown menu.

9 . The computer-implemented method of claim 1 ,

wherein the first SQL computer-executable database management script is generated after:

the first migration button is selected; and

a third button is selected to commit selection of the first migration button; and

wherein the second SQL computer-executable database management script is generated after:

the second migration button is selected; and

the third button is selected to commit selection of the second migration button.

10 . A relational database management system, comprising:

a database associated with a database environment, the database environment having database attributes;

at least one processor; and

a non-transitory computer-readable medium storing instructions that when executed by the at least one processor cause the at least one processor to:

generate a graphical user interface, the graphical user interface including a first migration button and a second migration button

generate, based on a first selection of the first migration button, a first Structured Query Language (SQL) computer-executable database management script configured to modify a data entry of an initial control table to adapt the data entry to a first database metadata attribute associated with a first control table of a first database; and

generate, based on a second selection of the second migration button, a second SQL computer-executable database management script that is configured to modify the data entry of the initial control table to adapt the data entry to a second database metadata attribute associated with a second control table of a second database; and

migrate the data entry to one of the first control table of the first database and the second control table of the second database based on the first selection or the second selection,

wherein the first SQL computer-executable database management script is different from the second SQL computer-executable database management script;

wherein the first database is different from the second database; and

wherein the first database metadata attribute is different from the second database metadata attribute.

11 . The relational database management system of claim 10 , wherein the instructions, when executed by the at least one processor, cause the at least one processor to:

update, based on the selection of the first migration button, the data entry to be compatible with first metadata of the first database; and

update, based on the selection of the second migration button, the data entry to be compatible with second metadata of the second database.

12 . The relational database management system of claim 11 ,

wherein the first metadata includes first schema of the first control table; and

wherein the second metadata includes second schema of the second control table.

13 . The relational database management system of claim 12 , wherein each of the first metadata and the second metadata includes one or more of:

a number of table rows;

a type of table row; and

a data type of a table field.

14 . The relational database management system of claim 12 , wherein each of the first metadata and the second metadata includes a data type of a table field, the data type including one of:

a character only data type;

a numerical only data type; and

an alphanumeric data type.

15 . The relational database management system of claim 12 , wherein each of the first metadata and the second metadata includes a data type of a table field, the data type including a number of decimal places data type.

16 . The relational database management system of claim 10 , wherein the instructions, when executed by the at least one processor, cause the at least one processor to:

execute the first SQL computer-executable database management script and, based thereon, generate a first indicator that an update of first data fields of a first table succeeded or failed; and

execute the second SQL computer-executable database management script and, based thereon, generate a second indicator that an update of second data fields of a second table succeeded or failed.

17 . The relational database management system of claim 10 , wherein the graphical user interface includes a dropdown menu that includes the first migration button and the second migration button.

18 . The relational database management system of claim 10 ,

wherein the first SQL computer-executable database management script is generated after:

the first migration button is selected; and

a third button is selected to commit selection of the first migration button; and

wherein the second SQL computer-executable database management script is generated after:

the second migration button is selected; and

the third button is selected to commit selection of the second migration button.

Assignments (2)

Continuity (3)

References Cited (32)