On 19 Dec 2005 at 18:31, d_sameer wrote:

>just because they fell behind on updates. What types of design pattern
>would you recommend where in I could do a schema validation and then
>an update. Something similar to ADOX in the old com model
><TableDefs/QueryDefs>. I guess GetSchema would achive at least
>partially what I would want to do,

You can query metadata, of course to find out list of tables,
fields, constaints, etc, but I would not care about all this and keep
current version of DB in a table. Then just "select version from
the_table" and if it is not the current - upgrade. Upgrade process
updates the field as the last stage.

--
SY, Dimitry Sibiryakov.