|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
 Posted - 07/24/2012 : 06:10:01
|
First thing is to map your columns between old and new, so from the above, MATERIAL_ID would map to ID in Material, SHOW would map to IsVisible etc..
From there, it is a case of bulking out the other columns with values (they may be defualt or condition based, you need to ask the architect or the BA questions to know what to put into the new fields).
Once you have found all this out, write a SELECT query that gets the data out of the old system in the new systems format, then go back to your BA and ask them if it looks correct, then write the INSERT. |
 |
|
Help on data import/export needed
