Imagine a table named Customers the has various fields including; Country, State, City, ZIP. In my redesign I want a separate table for each of those - Country table, State table, etc. that will be related to the new Customers table. Naturally, I don't want to loose all of the data I have entered. How do I get the old data structure into the new data structure?
Let me start with a simple (?) question (and this is where I have started). Should I import the separate data into the new tables and work out a method for finding the correct relationship, or should I fill the new table data and build the relationship as I go?