|
Karen
I know unloading and loading the data
will
be a real pain but I figured it might be
just
as hard to upgrade these 6.1 apps the
other
way. They could end up with forms that
will
not load because they are missing a
field.
I think I am in for fun either way, I will just
take it slow and not stress myself out
with
this mess.
Marc
----- Original Message -----
Sent: Thursday, May 12, 2005 3:11
PM
Subject: [RBG7-L] - Re: Update old
users
I went
through that just recently. I actually don't like bringing
in data
from an old database to the new one, although it is
nice to "rebuild" all
your data from scratch.
Possible problems: You have to be
careful of the order you
load data because of contstraints. If
you've made changes to
the structure of any of the tables, a simple
"unload data" command
will not work to bring it in. If your tables
have autonumbers, then
you must remember to recalculate the next
autonumber for every
single one of those columns.
I prefer to keep
a running list of structural changes I make, and then
just bring in the
forms and reports table.
Karen
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.
|
