1 Tip, 1 question

[Ivan Smahin]

Hello Neal,

Thursday, July 17, 2008, 6:33:21 PM, you wrote:


> Now the question:
> In dealing with changes to table definitions that occur over time (for
> instance to support new features), what is the preferred way to
> migrate old data to new? In my programs where I use XML preference
> files, for instance, I validate that all of the xml tags are present
> and add those on the fly if not. Is that how people do it with
> Valentina?

The database can be "versioned" with SchemaVersion property.
See "Schema Version" database property in VStudio.

It is available from any Valentina ADK.

So it could be something like

if( db.SchemaVersion == 1 )
{
    // Do something for upgrade db structure
    db.SchemaVersion = 2;
}




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