Data migration system
Assigneesalesforce.com, inc.
InventorsMinh Nguyen, Neeraj Ahuja
Life of this patent
Estimating the term…
Abstract
Disclosed are some implementations of systems, apparatus, methods and computer program products for facilitating data migration. Data migration is customizable according to user-specified data formats. A data migration system monitors the data migration process and automatically retries data migration tasks that have failed. In addition, the results of data migration are reversed according to detected threshold conditions.
Claims20
A system comprising:
- a database system implemented using a server system, the database system configurable to cause:
- generating data capable of being processed by a client device to cause display of a graphical user interface (GUI) configured to present, for each one of a plurality of source record types, for each one of a corresponding plurality of source fields, a plurality of user selectable options indicating a plurality of destination fields, each of the destination fields being associated with a corresponding one of one or more destination record types;
- processing, for each of one or more of the source record types, for each of one or more of the corresponding source fields, a user selection of one of the plurality of user selectable options indicating a corresponding one of the destination fields;
- responsive to processing the user selection for each of the one or more of the source fields for each of the one or more of the source record types, storing a field mapping that associates each of the one or more of the source fields, for each of the one or more of the source record types, with a corresponding one of the destination fields;
- performing data migration of record data from at least a portion of a plurality of source data records to at least a portion of a plurality of destination data records according to the field mapping, the destination data records being stored in at least one database;
- and
- responsive to detecting a threshold condition, reversing the data migration for the portion of the destination data records such that the record data stored in the portion of the destination data records is stored in the portion of the source data records.
A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising computer-readable instructions configurable to cause:
- generating data capable of being processed by a client device to cause display of a graphical user interface (GUI) configured to present, for each one of a plurality of source record types, for each one of a corresponding plurality of source fields, a plurality of user selectable options indicating a plurality of destination fields, each of the destination fields being associated with a corresponding one of one or more destination record types;
- processing, for each of one or more of the source record types, for each of one or more of the corresponding source fields, a user selection of one of the plurality of user selectable options indicating a corresponding one of the destination fields;
- responsive to processing the user selection for each of the one or more of the source fields for each of the one or more of the source record types, storing a field mapping that associates each of the one or more of the source fields, for each of the one or more of the source record types, with a corresponding one of the destination fields;
- performing data migration of record data from at least a portion of a plurality of source data records to at least a portion of a plurality of destination data records according to the field mapping, the destination data records being stored in at least one database;
- and
- responsive to detecting a threshold condition, reversing the data migration for the portion of the destination data records such that the record data stored in the portion of the destination data records is stored in the portion of the source data records.
A method, comprising:
- generating data capable of being processed by a client device to cause display of a graphical user interface (GUI) configured to present, for each one of a plurality of source record types, for each one of a corresponding plurality of source fields, a plurality of user selectable options indicating a plurality of destination fields, each of the destination fields being associated with a corresponding one of one or more destination record types;
- processing, for each of one or more of the source record types, for each of one or more of the corresponding source fields, a user selection of one of the plurality of user selectable options indicating a corresponding one of the destination fields;
- responsive to processing the user selection for each of the one or more of the source fields for each of the one or more of the source record types, storing a field mapping that associates each of the one or more of the source fields, for each of the one or more of the source record types, with a corresponding one of the destination fields;
- performing data migration of record data from at least a portion of a plurality of source data records to at least a portion of a plurality of destination data records according to the field mapping, the destination data records being stored in at least one database;
- and
- responsive to detecting a threshold condition, reversing the data migration for the portion of the destination data records such that the record data stored in the portion of the destination data records is stored in the portion of the source data records.
Dependencies are inferred from the claim text.