Marc, take a copy of the db from the clients and compare it to what it should be. If columns are missing, run the appropriate updates. When you are satisfied, then convert to 7.1 and create the show.
You can always compare the structures - I have a command file that will do it for you if you want it. It compares the row counts and column counts for every table in the database, including the system tables. The system tables give you the counts for views, reports, labels and forms, so that is handy as well. --- Marc <[EMAIL PROTECTED]> wrote: > HI > > I have lots of users in 6.x and want to update > them to 7.1. > > About a year ago someone suggest unloading > their data and "importing" it into an empty 7.1 > data base. > > My question is.... how can I make sure the > columns in each table match. > > Some of these offices never ran the updates > I sent over the years or didn't run them properly. > So, I am afraid they will have missing columns > in some tables or worse, columns that have > changed names over the years. > > thanks > Marc > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
