
columns, which will work fine. For date columns, VEA will insert the result
of a date function in the column.
b. If the target column is the subject of a unique index, the INSERT statement
that restores the backup data will fail. The only way around this is to make
the changes via script instead of ODBC connection. Remove the unique
index from the script and put the index on later, when you can get the
real data.
c. If the new column is mandatory and a foreign key, you need to do some
preparation prior to running the update. You have a few choices to handle this
situation.
i. Edit the script to remove the
NOT NULL qualification for the new column.
Also ...