|
|
Data Migrations
Almost all businesses migrate information from one format to another. A migration may be a
one time event as in the conversion of legacy data to a new enterprise wide ERP solution.
A migration may be repetitive in the case of exporting data to a data warehouse or
reporting subsystem.
Each migration is different, as are the solutions required to accomplish the task.
One set of tools is not the correct approach, nor is it correct to spend large
amounts of money on migration efforts that have little long term business impact.
Steve Guthman & Associates takes a realistic approach to data migrations matching experience
with correct toolsets. We provide the tools and can provide the required hardware needed for the conversion
effort. The end result is a successful migration at a reasonable cost.
Key elements of a one-time migration:
- Source Host Identification: what operating system, where located, how is the host physically
connected to the target host
- Source Identification: what application, what database, data formats, field formats,
business rules, export options, security issues
- Target Host Identification: what operating system, where located
- Target Identification: what application, what database, data formats, field formats,
business rules, import options, security issues
- Mapping Discovery: mapping field to field, mapping through conversion tables, summaries,
exception processing
- Determine where programmatic mapping is the best solution. Determine where data entry is the correct approach.
- Determine data transport: FTP, tape, etc.
- Detailed mapping process
- Determine required documentation and training
- Define testing and balancing procedure
- Simulated go-live test
- Final go-live
Top
|
|
|
