Most DBMS allow to add columns without changing existing data. I think it will be the safest way to upgrade.
Paul Worrall wrote:
Help much appreciated,
I am upgrading from 0.9.5 to 1.0 rc3 and I am told in the release notes
to:
- Intern table OJB_HL_SEQ (used by SequenceManagerHighLowImpl)
has changed! Now need an additional column 'VERSION' of type INTEGER
When updating from earlier version drop/reinstall table with additional field
Can I just alter the existing table to add the column VERSION?
If I drop it is there a script a run to rebuild it?
Will it affect the integrity of my existing data tables?
TIA.
Kind regards,
Paul Worrall Architect | Director
Apcentric Limited
The Soft Science of J2EE Deployment
m: +44 (0) 77 1133 0213 w: www.apcentric.com <http://www.apcentric.com/>
Any opinions expressed in the email are those of the individual and not necessarily of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient. It may contain material protected by attorney-client privilege. If you are not the intended recipient or person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. If you have received this email in error please notify the IT manager.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
