Invention Grant
- Patent Title: Systems and methods for migrating database data
-
Application No.: US14837862Application Date: 2015-08-27
-
Publication No.: US10366074B2Publication Date: 2019-07-30
- Inventor: Richard Cline , William J. Pothoff , Thomas G. Price
- Applicant: BMC SOFTWARE, INC.
- Applicant Address: US TX Houston
- Assignee: BMC Software, Inc.
- Current Assignee: BMC Software, Inc.
- Current Assignee Address: US TX Houston
- Agency: Brake Hughes Bellermann LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/23 ; G06F16/178 ; G06F16/21 ; G06F11/14

Abstract:
In one aspect, a computer-implemented method for ensuring a source database (e.g., target space or index space) has correct version information before a migration includes executing, using at least one processor, instructions recorded on a computer-readable storage medium. The instructions include determining whether a table has been changed since a most recent alter of the table, performing an update on the table when it is determined that the table has not been changed since the most recent alter, and performing a rollback on the table after the update. The method may also include creating an image copy of the data in the source database and refreshing data in a target database with the image copy of the data in the source database. The method may also include automatically repairing the target database when the version information of the target does not correspond with the version information for the source.
Public/Granted literature
- US20150363458A1 SYSTEMS AND METHODS FOR MIGRATING DATABASE DATA Public/Granted day:2015-12-17
Information query