I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data from our legacy system, once this has been done then the users of our application will be adding data to these excel files which is required by our new application. Once these Excel files have been fully populated i then need to upload to the new application,
I guess my question is have any of you gone through this kind of process, and if so how did you manage it.
One problem i can see is when i bring the data down to excel from legacy system, Excel does not keep the formats of each field, this would mean i need to specify the format for eac field again in Excel before uploading to new application.
Thanks in advance for any help
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!