Easiest Way to Export/Import
Posted on 2003-11-04
I have a question, I am export some data from 11 different tables, but its only the Primary Keys that I am actually exporting.
Its a little hard to explain but I am just going to give an example
Column 1 Value ---> 72
Column 2 Value ---> 59
Column 3 Value --> 'John'
Column 1 Value --->59
Column 2 Value --->77
Now because these numbers are generated by the system, they will probably exist in the target DB. So when I import, if I change Table1.Column2 Value to 85, I want an easy way to change Table2.Column1 Value to 85 also but I am working on a much larger scale.
I was thinking of using a Search and Replace function but then there are certain Columns that might have the same value and I might not want to change it. I was also thinking of using a collection, holding the old Value and the New Value, then check in the collection if a new value exists before I insert my record and then do the replace....
I am pretty sure that there is a better way to do this, I am just looking at a easy way to read and write... All my data once loaded is stored in an array of array, basically an array for each row in a table...
Any advice would be appreciated