Hi Albert, Gunnar and David Albert, yes,yes, I would like that program. I have 70+ users that are at different versions, some over 3 years old. I have expanded some columns like address from 20 to 35 and even added email address columns to some tables.
So, I was wanting to be able to unload columns x,y,z.... for each table then load then into the new 7.1db but I am afraid I will miss something and their program will not work. I think I remember most of the changes...? I hope. Since I am a FOOL and updating these offices for FREE, I know please kick me, I want to automate it as much as possible. thanks for the help, Marc ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, May 12, 2005 11:29 AM Subject: [RBG7-L] - Re: Update old users > 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] > >
