A record migration is the process or result of migrating (or converting) records from one data format or system, into a different format or system. Migrating records is similar to a data or database migration, but differs in that the perspective of looking at the data, as well as cost, are pre determined based on the number of records.
To demonstrate the difference between a legacy system migration and a record migration, consider the following example.
A) A company purchases a new enterprise software system and needs all of their data from the previous system migrated into the new system.
B) A different company uses financial software for all of their financial records and transactions, and as part of a lawsuit, they need to provide a law firm with all records or transactions of a specific type.
In Example A, this would be considered a data migration, as the entire legacy system data needs to be moved or migrated into the newer system.
In Example B, this would be considered a record migration, as only specific records (and an amount that can be counted and determined), needs to be converted or aggregated into some format for distribution to the law firm.
In general, data migrations are larger, encompass many different types of records, the records' metadata, other related data, as well as files and other artifacts. And a record migration is generally more narrow or specifically scoped to certain types of records.
Any person or company that needs specific records converted into a different format, or into a different storage location (or both). Examples of records could be customers, invoices, transactions, products or other entries. If a company needs these records to be:
Then it is the case that the individual or company could benefit from having their records converted or migrated.
Below are just a few examples of records that we have migrated for our clients across the world:
|Client's Industry||Client's Objective||Our Service Delivery / Solution|
|Construction||Our client had an Asset Management system, but for their worldwide fleet of construction equipment, the AM system was not the system of record (although it should have been). Their objective was for us to accurately gather all of the distinct records of their fleet, as well as the assemblies which make up each machine, which spanned multiple product lines across multiple continents and manufacturing centers, and merge them into one maintainable location and to serve as their system of record (source of truth for their fleet).||
The challenge in this project was that all of the data came from secondary and tertiary systems, often times not even from any kind of Asset Management system, but rather from
their Technical Publications groups who produced technical documentation for the equipment that each publisher's site manufactured. Our solution involved successfully decrypting,
ingesting and analyzing data across multiple systems, and aggregating a single database for their worldwide fleet.
In total, we:
|E-Commerce||Our client manufactures reed diffusers for large retail chains throughout the United States, eg Walmart, Kohl's, Sears, K-Mart etc. While a large portion of their business was selling in bulk to large retail chains, they also wanted to offer B2C sales via an e-commerce website. All of their product records were stored in their ERP MAS90 system, and their objective was to migrate these records into a new eCommerce / Website Database Schema to make product listings available via the web.||
In addition to migrating the records, we were also responsible for developing a new database schema to store their products.
In total, we:
If you or your company would like to inquire about working with Data Migration Services Services to convert or migrate records for you, please contact us or use our free consultation form page to request a free consultation with one of our Lead Solutions Architects.