×

Online data migration

  • US 8,356,010 B2
  • Filed: 08/11/2010
  • Issued: 01/15/2013
  • Est. Priority Date: 08/11/2010
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method comprising:

  • migrating data during uptime from a first table to a second table in a first schema in a database, a first application server connecting to the database using the first schema, a second application server connecting to the database using a second schema, the first application server running a first version of a software program, the second application server running a second version of the software program, the second schema having a first alias pointing to the first table and a second alias pointing to the second table;

    adding entries during uptime to a change table in the first schema characterizing changes to the first table during the data migration, the second schema including a change alias pointing to the change table;

    recursively updating the second table to include the entries referred to in the change table using the second application server, the recursively updating comprising;

    reading data from the first alias corresponding to the entries referred to in the change table, and writing the data from the first alias to the second alias until a remaining number of the entries is below a pre-defined threshold; and

    initiating downtime to migrate remaining entries in the change table to the second table, delete the first table, and rename the second table to have a same name as the first table prior to deletion so that during uptime the second application server connects to the second table and runs the second version of the software program.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×