Transfer
A utility to transfer the contents of one version of a database to a later
one when doing development work. This is to replace having to manually merge
each table one at a time.
A couple (well lots) of notes on it:-
- Any field present in the new database but not in the old is ignored, but
any default value for the new field will be entered.
- Any field present in the old database but not in the new is ignored and
the data is not transfered.
- Any field where the type has been changed will cause the programme to fail
to run with a standard error message.
- You must use the reorganise file option on the new file after using it otherwise
you can get weird results.
- The 'source' database is not affected in anyway, it is simply read from.
- The 'target' database need not be empty of data as all tables are cleared
before the new data is transfered. (this is particularly useful if the transfer
fails because of 3 above or 7 below, saves you having to empty the database.)
- You will need to specify the order that the tables are done in to stop 'this
record cannot be deleted or changed because a related .....' errors
- The downlaod is small - 18K
I would welcome comments on this utility, particularly whether people find
it usefull, if so I'll concider improving it. (or perhaps it could become a
colborative effort.)
Return to Datapower Page
|
Download Transfer(18Kb)
|
|
|
|
