1 Tip, 1 question

[Ivan Smahin]

Hello Neal,

Thursday, July 17, 2008, 7:01:08 PM, you wrote:

> So this method would have a discrete update path for each update iteration?

> I was thinking of two possible scenarios which I wonder if the first
> one would work:
> 1. export the database, then import it under the different scheme.
> What happens if a previously existing field no longer exists in the
> table, VExceptions in this approach?

Yes, it should be exception in case of different fields count.

> 2. a similar method as with my xml files, a query on each table
> whether a field is present and if not add it. This also suffers from
> vestigial fields being left behind but I guess I could have a periodic
> cleanup routine to look for dead fields and delete them. Is there any
> issues with deleting a field that has data, indices, etc.?

It should be no issues - nothing special.




-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com